…show_statusblogpercona.commanual Com_show_storage_enginesblogpercona.commanual Com_show_table_statusblogpercona.commanual Com_show_tablesblogpercona.commanual Com_show_triggersblogpercona.commanual Com_show_variablesblogpercona.commanual Com_show…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…) ==9090== Address 0x5e06270 is 0 bytes inside a block of size 800000 alloc’d ==9090== at 0x4C28FDF: malloc (vg_replace_malloc…: show_status_array(THD*, char const*, st_mysql_show_var*, enum_var_type, system_status_var*, char const*, st_table*, bool, Item*) (sql_show.cc…_schema_table_state) (sql_show.cc:6238) ==9090== by 0x6A5E0C: JOIN::exec() (sql_select.cc:1863) ==9090== by 0x6A7D72: mysql_select(THD*, Item***, TABLE…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** 1. …size=512K sql-mode=STRICT_TRANS_TABLES symbolic-links table-definition-cache=16384 table-open-cache=128 thread-cache-size=32 thread-stack=256K tmp-table-size…
Post: Innodb Table Locks
July 31, 2012 By 4 Comments
… sec fetching rows mysql tables in use 1, locked 1 9417 lock struct(s), heap size 915896, 696679 row lock(s) MySQL thread id… simple – SHOW INNODB STATUS does not know anything about MySQL level locks, so table locked on MySQL level with LOCK TABLES will not show up out… older MySQL versions). MySQL level locks are entirely different story. Explicitly locking tables on MySQL level will prevent tables from being accessed and will not show…
Post: How much space does empty Innodb table take ?
December 16, 2008 By 7 Comments
…`), KEY `c_2` (`c`,`i`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 mysql> show table status like “test_innodb” \G *************************** 1. row *************************** Name: test_innodb… very inaccurate for small tables. For example it will show 16K as average row size for table with one row: mysql> show table status like “test_innodb…. As we populate table we will see Free space will remain at zero as Data_length is small: mysql> show table status like “test…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…Tables MEMORY tables can take memory. There are implicit MEMORY tables which are allocated for query execution, which size can be controlled by tmp_table_size…
Post: When Does InnoDB Update Table Statistics? (And When It Can Bite)
October 6, 2011 By 7 Comments
…MySQL and InnoDB plugin’s manual: Metadata commands like SHOW INDEX, SHOW TABLE STATUS and SHOW [FULL] TABLES (or their corresponding queries from INFORMATION_SCHEMA.TABLES…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
… table – myisam_data_pointer_size is 6 default plus we need space for delete flag which makes 7 minimum row size …columns. Lets see how things look for MyISAM for same tables: mysql> show table status like “%bool%” \G *************************** 1. row *************************** Name: bbool Engine: …
Post: Be productive with the MySQL command line
December 21, 2012 By 14 Comments
… you want to estimate a good size for you InnoDB redo logs: the … mysql> pager grep sequence PAGER set to ‘grep sequence’ mysql> show engine innodb status\Gselect sleep(60);show …mysql> tee queries.log Logging to file ‘queries.log’ mysql> use sakila Reading table information for completion of table…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
…mysql-clients-5.5.30-1 percona-server-5.5.29_rel29.4-1 Total Download Size: 8.07 MiB Total Installed Size… 100% Installing MySQL system tables… OK Filling help tables… OK …mysql client: [root@alarmpi ~]# /usr/bin/mysql Welcome to the MySQL monitor. Commands end with ; or \g. [...] mysql> SHOW…
