… 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610…comments=”Non-FK relationship, implicit relationship to parent”> <column name=”id” primaryKey=”true”> column> <column name=”parent_id”>
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… unnoticed by most (not all) DBAs. Duplicate Index Detection I commented about this on my last webinar, but did not have….00 sec) In previous versions of MySQL, you can create two indexes with the same columns (in the same order) and the… for filtering on both columns, but also for filtering by just the first one. Why can’t MySQL enforce this kind of…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
…/Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump … simply cannot replace in short term. Control Your Auto-Incrementing Columns PXC/Galera controls auto-incrementing values internally within the cluster…’d like to hear your thoughts and experience on the comments 
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… is the maximum number of columns in MySQL?” and “What is the minimum maximum number of columns in MySQL?”. Before you read on, ponder… the maximum number of columns in a MySQL table. So what’s the maximum number of columns in a MySQL table? Well.. I tried…).”‘) COMMENT ‘”.cname($_,254).”‘,\n”; } chop $sql; chop $sql; $sql.=”);”; print $sql; So the maximum number of columns for a table in MySQL is…
Comment: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
I got it to fail at 59 columns. The maximum column comment length was increased to 1023 in MySQL 5.5, so I modified your script to create comments of that length instead of 255 as you have.
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 8, 2013 By 32 Comments
….e. you have a separate table with TEXT column, which stores data, like this comment. In this case it might be helpful… own InnoDB compression, which is available in MySQL 5.6. So we may test MySQL 5.6 more to see what kind…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just…Com_show_charsetsblogpercona.commanual Com_show_collationsblogpercona.commanual Com_show_column_typesblogpercona.commanual Com_show_contributorsblogpercona.commanual Com_show_create_…
Post: Beware of MySQL Data Truncation
February 7, 2009 By 4 Comments
… article_comment values(4300000002,1); Query OK, 1 row affected, 1 warning (0.00 sec) mysql> select * from article_comment; +————+————+ | article_id | comment_id… (0.00 sec) mysql> insert into article_comment values(4400000000,1); ERROR 1264 (22003): Out of range value adjusted for column ‘article_id…
Comment: COUNT(*) vs COUNT(col)
April 25, 2007 By 45 Comments
… pages 0 The column rajid btw, is just a copy of the PK column comment_ID with a unique index: mysql> show create table wp_comments\G *************************** 1. row *************************** Table: wp_comments Create Table: CREATE TABLE `wp_comments` ( `comment…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…column, pk_column FROM tbl WHERE key_column=x ORDER BY key_column (Note that secondary keys in InnoDB contain primary key columns…, n_name, c_address, c_phone, c_comment from customer, orders, lineitem, nation where c_…workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read_…
