Too Many Connections With Mysql...

[guangdian 0]

Just in the morning....

*** FATAL *** Cannot connect to localhost ---MySQL said: Too many connectionsTrouble has been reported to system administrator.Please try again later. Thank you.

Oh...Trap17.So many men~oh.wish a more better server.

[brokebloke 0]

Hiya guys,Just wondering, does anybody know what cache is and how to implement it say for something like wordpress, would it be really useful, i.e cacheing sql queries so theres a lot less stress on the Xisto servers, for instance, if you only update your site once a day, does cache work by saving that query and only updating once per day (or whatever you set), so the visitors to your site don't automatically keep making new sql queries but is already cached, I've looked around on google, has anybody here got any experience, would be really helpful, thx.

[OpaQue 15]

The MYSQL servers must be having an internal cache.. However, most of the php mysql applications use their own cache. The Invision Board also caches most of the content so that many queries are saved. The Timeout thing is basically because, I have set the max. Queries for all the Xisto clients. The servers have very much powerful with 2 GB ram and 2.8 GHZ Dual processors. But there are some other clients too. Hence, In order to keep them unaffected when any of our members spam, We have put the MAX connections limit :-)

[guangdian 0]

What doz that mean:?

MySQL said: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LifeDATA ( ID INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY