MySQL Madness

Posted by: scoopseven 18 years, 1 month ago

Spent a good deal of time today learning about MySQL's limits when it comes to non-indexed tables. I had 4 column table which included a date, IP address and 2 integers. The CFMX server started going bananas, taking a long time to finish requests. I lowered the timeout, so long running requests would die and I increased the number of simultaneous requests in the ColdFusion administrator from 8 to 100! the server would eventually use all 100 connections and then start queuing requests, then die. Finally I decided to check out our MySQL database server, which is never the problem, and found tons of locked queries trying to select/insert/update into my 4 column table. There was over 500,000 records in the table!!! So, needless to say, it should have been indexed. It was decided that the data didn't actually need to be recorded, so we just stopped accessing the table. I'm sure 1 or 2 indexes would have solved the problem though. Share on Twitter Share on Facebook

• ← Fusebox 4.1 and Application.cfm
• Sorbs Sucks →