New answers tagged

2

query_cache_size = 1G -- This is really bad. Don't set it bigger than about 50M. It won't directly cause a crash, but it can cause lengthy stalls, which could lead to a crash. When any write occurs to a table, all entries in the QC for that table is purged. The bigger the QC the longer that takes. The QC is "in front of" the engines (MyISAM and InnoDB). ...



Top 50 recent answers are included