Utherr12 Posted December 10, 2010 Share Posted December 10, 2010 Is 3000 queries per minute too much for a mysql database? The tables are in MyIsam, and I'm hosting my own database on linux ubuntu 10.04, it's hosted on my pc which i frequently use for different activities.So are 3000 queries too much for me? (brief pc specs: intel dual core @ 3ghz, 4GB ddr2, 16mb buffer 7,2k rpm hdd samsung).And related to this question, how many queries per minute does a serious sql database usually handle? Link to comment Share on other sites More sharing options...
justsomeguy Posted December 10, 2010 Share Posted December 10, 2010 It all depends on the capabilities of the server and the efficiency of the database design. Not all queries are equal. You're in a better position to determine whether your server can handle high traffic on your database design. Link to comment Share on other sites More sharing options...
[dx] Posted December 10, 2010 Share Posted December 10, 2010 I was wondering how huge web sites like facebook uses databases and storage disks. It's normaly that it uses many servers.So is there, example: profile database and table on one server, and like statuses on other server, or maybe example: 1-200 000 Id's using one server for everything, 200 001-400 000 using other server and so on.So does it uses by tables, or by ID numbers?Also, regarding to this topic, if u see that your server can't work fine, u should add one server more. Link to comment Share on other sites More sharing options...
boen_robot Posted December 10, 2010 Share Posted December 10, 2010 Facebook in particular I've heared that it doesn't use foreign keys, because the delay of a milisecond is too much for them... they use cron jobs to keep separate copies and do cleanups instead.For non mission critical sites like Facebook, that's acceptable, since (for example) it isn't all that important if you'll keep friends with someone for a few mintues more or less.They also compile their PHP with their own compiler to further improve performance. And of course, they use multiple powerful servers, which, like I said, keep separate copies of the database for the sake of both efficiency and fallback. Link to comment Share on other sites More sharing options...
[dx] Posted December 10, 2010 Share Posted December 10, 2010 So excuse me if I'm wrong. But let's say I'm viewing my photos now. It data are not on main server, it copy pictures from backup, and after some time it deletes it? Link to comment Share on other sites More sharing options...
boen_robot Posted December 10, 2010 Share Posted December 10, 2010 There are several "main" servers, so I'm not sure I see what you mean... I guess it's possible that a photo you deleted suddenly came back for a few seconds (minutes at worst), and then got deleted again, if that's what you mean... I suppose they've made their timings in a way that would minimize the possibility of that scenario. Link to comment Share on other sites More sharing options...
Utherr12 Posted December 10, 2010 Author Share Posted December 10, 2010 DO big web sites like facebook myspace etc, use mysql for their database ? Link to comment Share on other sites More sharing options...
justsomeguy Posted December 13, 2010 Share Posted December 13, 2010 Is MySQL used on some big sites? Yeah. Do all big sites use the same database? No. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.