… MySQL treats updates as higher priority operations. You can use SELECT HIGH_PRIORITY or UPDATE LOW_PRIORITY to adjust that or you can simply set low_priority_updates option… in cache but it is only part of the problem. The other problem is – it is hard to manage resources, especially if…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 139 Comments
…/mysql-slow.log sql-mode=TRADITIONAL concurrent_insert=2 low_priority_updates=1 The problem was that at about 3pm GMT the SELECTs from…, the above query would execute in 0.00 seconds. The problem was: why would this table get so fragmented or come… record as mentioned above (a small fraction of INSERTs and UPDATEs)? We explored a bunch of issues including questioning our hardware…
