…column, pk_column FROM tbl WHERE key_column=x ORDER BY key_column (Note that secondary keys in InnoDB contain primary key columns) Buffer each pk_column…1 1 1 1 1 As you can see from the status counters above that both MySQL 5.6 and MariaDB 5.5 are reporting high numbers for Innodb…
Post: Hijacking Innodb Foreign Keys
January 2, 2012 By 2 Comments
…Innodb is able to drop indexes without rebuilding table since MySQL 5.1 (Innodb…columns whenever they have changed or not: mysql> set foreign_key_checks=1; Query OK, 0 rows affected (0.00 sec) mysql…
Post: Bug#12704861
November 20, 2011 By 1 Comment
… fixed in MySQL 5.1.60. I’ll repeat here the full documentation from the release notes: “InnoDB Storage Engine: Data from BLOB columns could… 5.1.58 and 5.1.59. Now, just because this bug is there doesn’t mean you’ll hit it all the time, InnoDB…) by btr_mark_freed_leaves(nonfree=TRUE). btr_page_alloc(): Add the parameter init_mtr, allowing the page to be initialized…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…my next point: Use InnoDB Assuming that you will use the stock MySQL server, InnoDB is usually your best bet… get the totals you add them. Did this gain us anything? We dropped one column, and we just… that work by either using MySQL 5.1‘s row-based replication, or in MySQL 5.0 and earlier, doing the…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…MySQL 5.1+ row based logging (binlog_format=1) unique server_id in the my.cnf log_slave_updates=1, if this is a MySQL…innodb; Query OK, 0 rows affected (0.00 sec) mysql> insert into test.demo values (1,1); Query OK, 1…
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
…ON | | slow_query_log_file | /var/lib/mysql/slow_query.log | for compatibility with MySQL 5.1 and | userstat_running | OFF | to …Adds INFOMATION_SCHEMA.PROCESSLIST with TIME_MS column | 1.0 | Percona | GPL | | | innodb_locks_held.patch | Add locks held, remove locked records in SHOW INNODB STATUS | 1…
Post: Percona Server version 10
April 13, 2010 By 3 Comments
… XtraDB storage engine. Since the previous release 9.1 there are following changes MySQL 5.1.45 as a basis for the release I… SE Name at mysql start Bug #550867:5.1.45+xtradb-10 compilation fails on Ubuntu Karmic Bug #547230:Add new columns to innodb_table_stats Bug #548442:INFORMATION_SCHEMA.TABLE_STATISTICS is broken in XtraDB 9.1 Bug #509017…
Post: XtraDB storage engine release 1.0.6-9
January 13, 2010 By 9 Comments
… new features: The release is base on 1.0.6 version of InnoDB plugin. MySQL 5.1.42 as a base release Separate purge thread… innodb_buffer_pool Fixed bugs: Bug#488315: rename columns and add unique index cause serious inconsistent with mysqld Bug #495342: “MySQL 5.1.41 + InnoDB 1.0.6 + XtraDB patches extensions-1.0…
Post: What's up with HandlerSocket?
March 28, 2011 By 42 Comments
… from the MySQL interface. No support for auto increment – Exactly as it sounds, you couldn’t have auto-incrementing columns get an… of MySQL 5.1 are not using the InnoDB plugin because it is not enabled by default! If people cannot be bothered to add a couple of lines to my.cnf to enable the InnoDB plugin, they certainly cannot be…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 16 Comments
… to add …InnoDB, … PARTITION p253 VALUES LESS THAN (’2008-12-01′) ENGINE = InnoDB, PARTITION p254 VALUES LESS THAN (MAXVALUE) ENGINE = InnoDB…column. I partitioned the table into months using the FlightDate column using the improved MySQL 5.5 partitioning options which work directly on columns….1 …
