… not good for fast inserts, but it is suitable for range selects by `id`. However it will interesting how both InnoDB and TokuDB…/sysbench/insert-roll-2, command line to run: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… for MySQL is a hot thing right …May Not Even Work! MyISAM tables are supported within Percona XtraDB Cluster…can, you should consider moving to InnoDB altogether. There are very few… is to avoid collisions when INSERTs are happening on not only a…able to execute events as fast, on top of that, other…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration A) appears below: #####fixed innodb options innodb…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 3 lock struct(s), heap size 368, undo log entries 1 MySQL…and being sequential writes these logs writes are pretty fast. ———————- BUFFER POOL AND MEMORY ———————- Total memory allocated 4648979546;…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option and variable reference table…Innodb_truncated_status_writesblogpercona.commanual innodb_use_native_aioblogpercona.commanual innodb_use_sys_mallocblogpercona.commanual innodb_versionblogpercona.commanual innodb_write_io_threadsblogpercona.commanual insert…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
… a recovery process on the backup with innodb_fast_shutdown=0 and therefore merging all the insert buffers. # innobackupex –defaults-file=/etc/my… InnoDB data we are going to recover only the “salaries” table: Discard the tablespace of the salaries table: mysql> set FOREIGN_KEY_CHECKS=0; mysql…
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
…means index is very small and also very fast to build by insertion as insertions happen in the “end” of index tree. …of data and index size: mysql> show table status like “sbtest” \G *************************** 1. row *************************** Name: sbtest Engine: InnoDB Version: 10 Row_format: …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… MySQL 5.1 Q15: How frequently does Innodb fuzzy checkpointing is activated HT: InnoDB… INSERT with multiple values? We build up INSERTS on our clients and insert …though). The index is required for fast lookups: it can be used … ORDER and ORDERLINE tables are joined to form a single table), it might …
Post: InnoDB: look after fragmentation
November 5, 2009 By 12 Comments
…(`block_id`) ) ENGINE=InnoDB Table has 11864696…inserted not in order. +—————————+ | count(distinct username) | +—————————+ | 5903053 | +—————————+ 1 row in set (2 min 8.92 sec) mysql> SHOW STATUS LIKE ‘Innodb…XtraDB / InnoDB-plugin with FAST INDEX…
Post: Announcing Percona Server 5.5.27-28.0
August 23, 2012 By 5 Comments
…MySQL As A Service. New Expanded Program Option Modifiers have been added to allow access control to system variables. New table INNODB…MySQL bug #64284. Bug fixed #1015109 (Stewart Smith). Fixed the upstream MySQL bug #66301. Concurrent INSERT … ON DUPLICATE KEY UPDATE statements on a table…
