…before it occurs. For example, if you see a large number of long-running queries in the output …information in file: ‘./mysql/servers.frm’ Running mysql_install_db under strace, I saw that it was getting …-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… and a followup by Dimitri Kravchuk, we have received a large number of questions on why the benchmark results in both…-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects…-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… several hundred. This really will open a large window where rows won’t be able … really bad in standalone Innodb, you might consider relaxing the fsync: set innodb_flush_log_at_… database periodically? if( $last_count % 100 == 0 ) { $db->do( “UPDATE achievements SET count = $last_count where …
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…_5_15]# sysbench –test=oltp –db-driver=mysql –mysql-host=localhost –mysql-table-engine=innodb –mysql-db=test –oltp-table-name=md_cache…_5_15]# sysbench –test=oltp –db-driver=mysql –mysql-host=localhost –mysql-table-engine=innodb –mysql-db=test –oltp-table-name=md_cache… individually Sysbench gives about 330 req/sec and mysqldump for large table completes in about 95 seconds. If we run them…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… large number of connections Innodb will only print number of them, cutting the list so SHOW INNODB STATUS output will not grow too large… thread is not runniing inside innodb kernel status could be “waiting in InnoDB queue” or “sleeping before joining InnoDB queue”. Latest one is… pool size 262144 Free buffers 0 Database pages 258053 Modified db pages 37491 Pending reads 0 Pending writes: LRU 0, flush…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… upgrades. The RDS instance was a Quadruple Extra Large DB Instance. I used default settings for RDS, and …innodb_checksums ON innodb_commit_concurrency 0 innodb_concurrency_tickets 500 innodb_data_file_path ibdata1:10M:autoextend innodb_data_home_dir /rdsdbdata/db/innodb innodb_doublewrite ON innodb…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
…can be quite large because of the…processlist; +——-+——+———–+———-+———+——+————————-+—————————–+———–+—————+———–+ | Id | User | Host | db | Command | Time | State | Info | Rows…’re just using Innodb tables and you’…
Post: Can Innodb Read-Ahead reduce read performance ?
June 26, 2007 By 2 Comments
… today. We needed to dump and reload large database and we had pretty good IO … Free buffers 0 Database pages 784458 Modified db pages 361 Pending reads 261 Pending writes: LRU… ————– 8 queries inside InnoDB, 3 queries in queue 12 read views open inside InnoDB Main thread process no….
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
… RDS instance, which is listed as “High-Memory Quadruple Extra Large DB Instance: 68 GB of memory, 26 ECUs (8 virtual cores…-disk threshold, as famously happens in B-Tree inserts (see InnoDB vs TokuDB for example). This doesn’t mean that we… minute, and some samples of more data such as SHOW INNODB STATUS. But I was on the client’s time and…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…innodb_change_bufferingblogpercona.commanual innodb_checksumsblogpercona.commanual innodb_commit_concurrencyblogpercona.commanual innodb_concurrency_ticketsblogpercona.commanual innodb_data_file_pathblogpercona.commanual Innodb_data_fsyncsblogpercona.commanual innodb…
