"Florian G. Pflug" <[EMAIL PROTECTED]> writes:
> Hi
>
> I am running Mysql on a Machine with two PIII-600, and 1 GB of RAM.
> The disks are connected via U2W-SCSI.
>
> I tried tuning mysql for maximal performance the last days, but I'm not
> exactly sure which parameters I should increase, und to what value.
>
> Our web application is quite slow at the moment, and often the server is
> slower in doing the queries than they are created by the users, which
> steadily increases the number of running mysql-processes until they reach
> max_connection (which is 100 at the moment).
don't do this. you disappear up your own tailpipe. put a second apache
behind your first and limit its MaxClients setting. this is a standard
mod_perl trick and is in the mod_perl guide.
> Our Application searches through about 1.000.000 Records, and does heavy
> grouping, sometimes over 100.000 records.
>
> Is there any chance, that we can keep doing this queries on the fly, or will
> we have to cache them somehow? (which has a _lot_ of downsides, since the
> data changes quite frequently, about once every 1/2 hour).
Have you had a good hard look at your EXPLAINs?
>
> Which server parameters should we increase to make things faster?
>
> Since a lot of users "do the same thing" on this website, we often have the
> very _same_ query running 5 to 10 times, one started within 5 seconds or so
> after the other.
Definitely look at some form of cacheing. Do the result sets have the
same columns in the result sets? you might want to consider selecting
into a new results table...?
--
Dave Hodgkinson, http://www.hodgkinson.org
Editor-in-chief, The Highway Star http://www.deep-purple.com
Apache, mod_perl, MySQL, Sybase hired gun for, well, hire
-----------------------------------------------------------------
---------------------------------------------------------------------
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
