On Friday, Sep 5, 2003, at 13:41 US/Eastern, Thierno Cissé wrote:
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]



Reply via email to