… I/O priorities and arbitration. I’m not sure whether MySQL do leverage those features though (maybe it would be useful… TOS field) which would allow exposing this to consumers (although MySQL offers INSERT DELAYED). Back to the subject, I don’t know anything… layout) or is it more of a “plain sequential bulk insert/update on a very few tables” thing? Seekwatcher (http://oss…
Comment: No more MySQL Crash Safe Replication in 5.0 ?
August 10, 2010 By 7 Comments
…: position 0 517, file name mysql-bin.000002 InnoDB: Last MySQL binlog file position 0 98, file name ./mysql-bin.000002 —round 2… name ./mysql-bin.000001 The difference is consistently 27, which corresponds to unimportant binlog events: /*!40019 SET @@session.max_insert_delayed_threads=0…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… as read load. Here is simple example – assume you’re inserting the data at the same time as running reporting queries… MySQL Replication, such as filtered replication or cross storage engine replication, though which are not typically used for HA purposes. Time Delayed… transaction loss and automated fail over. Whenever you’re using MySQL Cluster, DRBD or MySQL Replication you have to have some compromises.
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
… DB,Refresh,Shutdown,Statistics,Processlist,Connect,Kill,Debug,Ping,Time,Delayed insert,Change user,Binlog Dump,Table Dump,Connect Out,Register Slave…(‘# administrator command: ‘, sql_text), sql_text), ‘;’ ) AS `# slow-log` FROM `mysql`.`slow_log`; GO echo “#” I host the script above in…
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
… it faster. By reading the rows for “INSERT“, “UPDATE“ and “DELETE“ statements but not updating …rebuild for foreign key changes. This unnecessarily delays their creation in a mysqldump output, so …KEY. #851674 (Alexey Kopytov). Backported fix for MySQL bug #53761 (Wrong estimate for RANGE query…
Post: Why Swapping is bad for MySQL Performance ?
January 18, 2010 By 11 Comments
So you get MySQL or other applications using too much memory on the box … designed before SSD era. For example Insert Buffer in MySQL makes a special effort to avoid (delay) IO. If it happens to go… consumption spike you may prefer to see slowdown instead of MySQL being killed because of out of memory but do react…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…have instead of how many systems they have” on MySQL UC2008 Scalability Panel ? Indeed disks MAY be the …doing all search heavy lifting we only need to insert new data and fetch few rows to show … 50 drives will unlikely be helpful solving replication delay or speeding up this 3 hours reporting query …
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… from the Percona Software Repositories). Based on MySQL 5.5.16, including all the bug …make it faster. By reading the rows for “INSERT“, “UPDATE“ and “DELETE“ statements but not updating them… rebuild for foreign key changes. This unnecessarily delays their creation in a mysqldump output, so –…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…_tmp_files’, ’4001′ ‘Created_tmp_tables’, ’669137′ ‘Delayed_errors’, ’0′ ‘Delayed_insert_threads’, ’0′ ‘Delayed_writes’, ’0′ ‘Flush_commands’, ’5′ ‘Handler_commit’,…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…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…domestic flights with information about flight length and delays. The data is available from 1988 to …each field. After that load statement is: mysql -S /tmp/mysql-ib.sock -e “LOAD DATA INFILE ‘/…allows you only LOAD DATA. InfoBright Enterprise allows INSERT / UPDATE but that also is not for online…
