… improvements. List of changes: Fixes merged from upstream (Codership-mysql) Support for MyISAM, now changes to MyISAM tables are replicated to other nodes…
Comment: Multi Column indexes vs Index Merge
May 10, 2012 By 30 Comments
…when using index merge executes in 3.8 secs. I dont understand why MySQL uses index merge after … | id | select_type | table | type | possible_…
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
…API (experimental) Some of the Percona InnoDB patches have been merged Since Drizzle 7.0 (which was released last year), …DATA_DICTIONARY tables, the Drizzle protocol plugin, authentication from a file, MySQL UNIX socket protocol, javascript plugin, authentication via tables (similar to MySQL), …
Post: AUTO_INCREMENT and MERGE TABLES
September 11, 2008 By Leave a Comment
… data to: mysql> truncate table a2; ERROR 1105 (HY000): MyISAM table ‘a2′ is in use (most likely by a MERGE table). Try FLUSH TABLES. mysql> flush tables; Query OK, 0 rows affected (0.01 sec) mysql> truncate table…
Post: Merge Tables Gotcha
May 9, 2007 By 4 Comments
… 1 in merge table however select querying by primary index returns only one. Following EXPLAIN shows why this is the case – MySQL knows… merge table so we could not drop PRIMARY KEY so I thought I should try using key on the given column instead: mysql… NULL for the merge table: “create table tx (id int unsigned, key(id)) type=merge union(t1,t2)” If you create table this way it…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 7 Comments
… on the backup with innodb_fast_shutdown=0 and therefore merging all the insert buffers. # innobackupex –defaults-file=/etc/my.cnf…/mysql/data/employees/ Import the new tablespace: mysql> set FOREIGN_KEY_CHECKS=0; mysql> ALTER TABLE salaries IMPORT TABLESPACE; mysql> set FOREIGN_KEY_CHECKS=1; mysql…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…-8K per table though complex tables can require larger sizes, so this is mainly the problem for smaller servers. Table Cache Merge Tables – Table Cache is… the case with Merge tables for example – creating and accessing few merge tables with 1000 of subtables will likely cause your MySQL server to run…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… to provide our estimates. If we’re running Innodb with MySQL we can use Innodb_data_reads , Innodb_data_writes, Innodb… ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld) S….88k 258.55k 1.46k # Merge passes 0 0 0 0 0 0 0 # Tmp tables 21.36k 0 2 0.01….88k 1.23k 1.46k # Merge passes 0 0 0 0 0 0 0 0 # Tmp tables 0 0 0 0 0…
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
…table I am getting: mysql> check table test; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> check table test; +———–+——-+———-+———-+ | Table | … modes to block purging activity, insert buffer merge or recovery from transactional logs all together. …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… referring to the amazing MySQL manual, especially the option and variable reference table. But just as frequently,…commanual socketblogpercona.commanual sort_buffer_sizeblogpercona.commanual Sort_merge_passesblogpercona.commanual Sort_rangeblogpercona.commanual Sort_rowsblogpercona.commanual…
