Finally you seem to say that you 've setting max_connections with a limit. Can you tell how many 100 or 200 ?
No. It turns out that setting max_connections to 0 is the same as setting no limit at all. This was my initial misunderstanding. The server is not currently in danger of overload, and I am sysadmin, DBA and primary web developer (small company), so I am free to work with no restrictions until I feel they're necessary.
Also you say :Here's the configuration: MySQL Ver 12.21 Distrib 4.0.14, for pc-linux (i686) PHP 4.3.2 Red Hat 9.0
Have you enable QUERY CACHE feature with MySQL 4.0.14 ?
Not that I'm aware of. As I said in my first post, I'm familiar with MySQL from the web developer's standpoint, but this is my first experience running and tuning the server. I'm sure there's a lot of things I could be doing to configure it better, but it's not clear to me yet what they are. It's pretty much a default configuration now, with my_large.cnf with a few tweaks as the my.cnf file.
pjm
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]