Hello MySql,
I'm dealing with a large (think so) production mysql server. There are up to
~2500 small databases (each ~1-4 MB Data in 10 Tables). The system is
growing and the CPU gets more and more loaded. A new behaviour is that
apache get sometimes out of clients, caused by bad response times from the
mysql server.
At the moment the system is running on one machine, however the concept is
scalable. I have no feeling/experience where are the limits with mysql. When
I have to setup the next db-server? Are ~300 queries per sec. a joke for
mysql? It's difficult to valuate if I'm going towards the hard limit or if I
have a problem with my db design.
Are there people who can share there knowledge about large mysql servers?
Linux 2.4.4 SMP
2x PIII 800
512 MB RAM
80 GB EasyRaid System. Lev. 5 (~130 MB sec)
average of ~ 330 queries per second.
Regards,
Oliver Krapp
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
