On Mon, Sep 03, 2001 at 04:06:20PM +0200, Oliver Krapp - etracker.de e.K. wrote:
> 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.
So you can put Apache on a separate machine to scale better, right?
> 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.
I'd look at the 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.
Sounds reasonable given your hardware. If things are well tuned
(parameters in your my.cnf file), I'd guess that you can probably
double the load (maybe twice or more) and still have room to grow.
But if you have some unoptimized queries killing things, all bets are
off.
Do you have the slow query log enabled?
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 2 days, processed 42,311,572 queries (237/sec. avg)
---------------------------------------------------------------------
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
