Hall of Fame

[dtiberio]

I am having issues where there are too many database connections, so the database is preventing me from browsing the site.

also, when the crons are running, and Inserting data, you should use the LOAD INFILE sql command instead of the INSERT command. it will be 100 times faster and use far fewer resources. you can load thousands of entries with 1 database connection instead of 1,000 connections.

you should try to store as much data on the hard drive in a regular file as possible, even if just for 15 minutes. it reduces the number of database connections and makes the site perform better on a busy site.

[Marius P.]

Noted. Good thing I've fired the sql guy. Need a job?
Will look into updating this and at your other threads.

[sharekhan]

if iam not wrong.please try to increase max connections to higher value in mycn file..

or

check you are database port is open so that some one hitting attacking sql install some firewall

[Marius P.]

That will work, but he is right in the optimization tip provided, we will try it and update to use it.