… 3 sec fetching rows, thread declared inside InnoDB 334 mysql tables in use 4, locked 4 3264 lock struct(s), heap… handle 0x2b3c1c776940, query id 16838101 localhost root Copying to tmp table create table t as SELECT ld.label_id, cai.inventory_id…) group by ld.label_id, cai.inventory_id All 4 tables in the query are locked!
Comment: What Are Full, Incremental, and Differential Backups?
May 22, 2013 By 9 Comments
… of the weeks. Can you give an example in a table? I am doing a project with Open university, and would…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… the filesystem level. The InnoDB indexes were built using ALTER TABLE fast index creation (merge sort). For the MyISAM tests I… innodb_buffer_pool_instances=16 metadata_locks_hash_instances=32 table_open_cache_instances=8 sort_buffer_size=128k read_rnd… innodb_undo_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb_flush_method=O_DIRECT…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… slave; and let’s create a new table on the master: mysql> create table test.t (id int not null auto_increment primary key); Executing SHOW TABLES FROM test on both slaves shows that the table has been created everywhere. So once…
Comment: Derived Tables and Views Performance
May 21, 2013 By 16 Comments
… menu and sub menu using php and mysql TABLE `menu` ( `id` int(11) NOT NULL auto_increment, `label` varchar…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… | +————–+—–+——–+——+——–+———+————–+——-+ SYS_INDEXES This table lists all indexes the table has, secondary as well as the primary. CREATE TABLE `SYS_INDEXES` ( `TABLE_ID` bigint(20…_COLUMNS stores fields names and type information of the table. CREATE TABLE `SYS_COLUMNS` ( `TABLE_ID` bigint(20) unsigned NOT NULL, `POS` int…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… static rows in MySQL */ reclength=max(file->min_record_length(table_options),reclength); if (info_length+(ulong) create_fields.elements*FCOMP… of number of columns to create) to produce the CREATE TABLE sql statement: sub cname ($) { my $c=shift; my $name=”"; while….=’0′ foreach(length $name .. shift); return $name } my $sql= “CREATE TABLE `”.cname(16,63).”` (“; foreach(1..shift @ARGV) { my $n=cname…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… –num-threads=32 –test=tests/db/oltp.lua –oltp_tables_count=32 \ –oltp-table-size=10000000 –rand-init=on –report-interval=1…=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL…_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb_flush_method…
Comment: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 16, 2013 By 10 Comments
i just did: http://www.percona.com/forums/questions-discussions/percona-xtradb-cluster/10162-xtradb-cluster-only-replicating-ddl-statements innodb tables
Comment: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 16, 2013 By 10 Comments
@Ricardo, What kind of tables? Can you create a new thread in the forums and post your configuration and wsrep_* status there.
