Hi all, mySQL question here.
I have several tables (over 20) in a database with some that have over 20,000 records. Those are used primarily for archiving records from other similar tables and are not accessed on a regular basis. Those that are accessed, 4 or 5 normally, for the most part contain less than 2,000 records. All run in a virtual dedicated server.
Just recently (within the last couple of days) the time it takes to access the website has increased by at least 10 times what it normally would take (from 1-2 seconds to 10-15 seconds and as much as 30 seconds) even though the increase in records has not been unusually high. I was told by my ISP to "optimize" my tables, which I did via the admin for mySQL, which didn't help (all came out "ok"). I was further told by my by ISP: "Regarding the database on your site; one additional thing that you can look into is the query logging for MySQL. Sometimes this can be set to log every query to the database and this can also decrease performance. Basically if every query has to also log it's actions, even with several small optimized queries it can cause latency issues for the website." The link they provided for further information, http://dev.mysql.com/doc/refman/5.1/en/query-log.html, explained a lot but was rather confusing.
I researched this issue and found a possible command to run: "mysql> SET GLOBAL general_log=OFF;") to see if that helps. I tried doing that from the plugin "MySQL Console" and received the following error: MySQL Error: Unknown system variable 'general_log'
Question: is there a way to shut off the 'general' log from working while running a specific file? Or another way to limit all this writing that seemingly is causing the increase in latency?
TIA,
Eric