… secs or so…Com_help’, ’0′ ‘Com_insert‘, ’17889656′ ‘Com_insert_select’, ’11′ ‘Com_kill…unlock_tables’, ’102′ ‘Com_update‘, ’15146253′ ‘Com_update_multi’, ’0′ ‘…mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
MySQL Server has tons of variables which may be adjusted to change behavior or…updating indexes for MyISAM tables. Good for performance but tables will be badly corrupted on crash. delayed_insert_limit, delayed_insert… storage engines transaction logs, slow query log or general log. flush, flush_time …
Post: Fighting MySQL Replication Lag
September 22, 2008 By 7 Comments
…transaction containing millions of simple updates instead of one large update to help MySQL replication lag it is …per batch in multiple row insert statement or Fetching data you’re planning to update/delete and having …cases is to simply space it out and slow down your batch job (such as adding sleep…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
…-variable=max_connections=1500 log_slow_queries=/var/log/mysql-slow.log sql-mode=TRADITIONAL concurrent_insert=2 low_priority_updates=1 The problem was… so fragmented or come to its knees with the transaction record as mentioned above (a small fraction of INSERTs and UPDATEs)? We explored… issue. We do a “VACCUM” every *month* or so and we’re fine. MySQL, I have come to realize, is as good…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
…all that extra network traffic would really slow down transactions. You may have already guessed…node2 mysql> insert into autoinc (j) values (‘node2′ ); Query OK, 1 row affected (0.00 sec) node2 mysql> insert… or similar so if your main writer node fails, clients fail over gracefully. Update …
Post: Some little known facts about Innodb Insert Buffer
January 13, 2009 By 12 Comments
…insert buffer to “cheat” and not to update index leaf pages when at once but “buffer” such updates so several updates…insert buffer to survive transaction commits and even MySQL…
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
…MySQL on Debian or Ubuntu with InnoDB? You might want to disable /etc/mysql/debian-start. When you run /etc/init.d/mysql… would be extremely slow on this machine…| 6344 | user | | NULL | 6345 | user | Updating | update … | 6346 | user | Sorting result | insert … | 6351 | user | | NULL | 6355 | …
Comment: Edge-case behavior of INSERT...ODKU
October 31, 2012 By 6 Comments
…InsODKU just didnt cut it. It was slow as a dog (even when batching in…a question of how many rows to insert / update at once. Furthermore, this does not …and determine if it will be an insert or a select (and you must do …would be a VERY good feature in MySQL. InsODKU would be much better implemented …
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
… â€.. only an in memory or read-only engine, and that’s why inserts are so fastâ€. This ….net/mysql-patch/mytools What makes fractal indexes so interesting is the amount of IO operations to update …problem of random IO, waste of RAM memory and slow inserts. This is where I think Tokutek appears to …
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… things like whether Query cache was used or not, if Filesort was used, whether …the vanilla MySQL server, you would see an entry like this in the slow query log: # … 89 0.0022 1.00 0.01 UPDATE wp_options # 7 0x7AEDF19FDD3A33F1 0.1381 1… 260 0.0002 1.00 0.00 INSERT poller_output # MISC 0xMISC 0.8137 10…
