Large Number of Queries

[Anon]

Hello,

I have a MYSQL database which needs a large number of queries (INSERT and SELECT) in a short time. Also, there are many connections in a short time. How can I optimize performance by using nice PHP code or optimize Mysql server directly?

Yours faithfully,
Joe

[Anon]

What's you ratio of inserts to selects? MySQL just isn't made for lots of concurrent inserts/selects. As for tuning it, the manual is THE place to start.

[Anon]

If you are running mysql on a linux box, don't forget to have root set the /proc/sys/fs/file-max to something higher than the default 4096 (16384 is a good starting point) then monitor /proc/sys/fs/file-nr to see how many file handles get used during the select/inserts