…mysql> SHOW CREATE TABLE test\G *************************** 1. row *************************** Table: test Create Table: CREATE TABLE `test` ( `id` int(11) NOT NULL AUTO_INCREMENT, `col2` int(11) DEFAULT…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using … or different regions. The flights represent the type of investigations and drill-downs that are … TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…DEFAULT NULL, `TYPE` int(10) unsigned DEFAULT NULL, `SPACE` int(10) unsigned DEFAULT NULL, `PAGE_NO` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`TABLE…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max…_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 #default_table_type = InnoDB thread_stack = 192K tmp_table_size = 64M server-id…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…. There’s still one noticeable omission: pt-table-sync. It’s still unclear if or…pt-upgrade a try. It also reads every type of log now (slow, general, binary, and …mysql-summary 2.2 have all the standard MySQL options built-in, like other tools: –user, –host, –port, –password, –socket, –defaults…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… fast PCI-e flash card as storage. By default linkbench dataset has 10M ids(after load of…Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate…_connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…a vCache device with the default configuration, I started with a baseline HDD configuration for MySQL (configuration A, listed …-type=pareto \ –forced-shutdown=1 –max-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option and variable reference table…default_storage_engineblogpercona.commanual default_time_zoneblogpercona.commanual default_week_formatblogpercona.commanual defaults_extra_fileblogpercona.commanual defaults_fileblogpercona.commanual defaults…slave_type_…
Post: Wow. My 6 year old MySQL Bug is finally fixed in MySQL 5.6
August 30, 2012 By 2 Comments
…mysql> explain select count(*) from trunc where i=4147483647; +—-+————-+——-+——+—————+——+———+——-+——-+————————–+ | id | select_type | table | type…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… 100% Installing MySQL system tables… OK Filling help tables… OK …DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES | YES | YES | [...] mysql…mysql/my.cnf If you setup Percona Server to startup at boot time (step 12), give your little server a reboot (type…
