…MySQL server. Let’s take a recent 5.1 bzr version (pre-5.1.61) and a single test, innodb_plugin.innodb… unprotected access to the current LSN (log_sys->lsn), with a small wrinkle: the accesses…) ==9090== by 0x74E4DF: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:6238) ==9090…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
… Since they have a lot of tables, InnoDB uses over 3.5G of … happens: mysql> show processlist; +——+——————+—————-+————- | Id | User | State | Info +——+——————+—————-+————- | 7 | debian-sys-maint | NULL | CHECK TABLE tableA… | 739 …
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… a table containing 4 million rows and one secondary key: mysql> CREATE TABLE t(id INT AUTO_INCREMENT PRIMARY KEY, c FLOAT) ENGINE=InnoDB…. OPTIMIZE TABLE OPTIMIZE TABLE is mapped to ALTER TABLE … ENGINE=InnoDB for InnoDB tables and thus, is just a special case of the previous one: mysql> SET… user 0m3.179s sys 0m0.069s $ time mysql -uroot test < dump_optimized.sql real 1m20.958s user 0m3.204s sys 0m0.062s Caveats…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…innodb_sys_tables as t inner join innodb_sys_indexes as i using(table_id) inner join innodb…
Post: Innodb vs MySQL index counts
November 29, 2011 By 6 Comments
…] Table database_name/table_name contains 8 indexes inside InnoDB, which is different from the number of indexes 7 defined in the MySQL This… use the INFORMATION_SCHEMA.INNODB_SYS_INDEXES table, which exists in Percona Server 5.1, but doesn’t appear in MySQL until 5.6… Percona Server or MysqL 5.6. Another person (I’m looking at you, Baron) was adverse to trusting INNODB_SYS_INDEXES from some…
Post: How much memory Innodb Dictionary can take ?
May 6, 2010 By 3 Comments
… on amount of tables you have as well as number of fields and indexes. Innodb allocates this memory once table is accessed and… from real system: mysql> select count(*) from INNODB_SYS_TABLES; +———-+ | count(*) | +———-+ | 48246 | +———-+ 1 row in set (8.04 sec) mysql> select count(*) from INNODB_SYS_INDEXES; +———-+ | count…
Post: InnoDB compression woes
May 20, 2011 By 14 Comments
…–rand-type=uniform –max-time=1800 –mysql-user=root –report-interval=10…s check CPU stats: regular tables: —–cpu—— us sy id wa st 1…tables CPU utilization is 7%. Obviously we have some mutex serialization problem. Analyzing SHOW INNODB STATUS (SEMAPHORES) for workload with compression tables…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file-per-table innodb…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…innodb_table_locksblogpercona.commanual innodb_thread_concurrencyblogpercona.commanual innodb_thread_sleep_delayblogpercona.commanual Innodb_truncated_status_writesblogpercona.commanual innodb_use_native_aioblogpercona.commanual innodb_use_sys_mallocblogpercona.commanual innodb…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… MySQL buffers – query cache, key_buffer, mysql threads, temporary tables, per thread sort buffer which can be allocated. There are also things like innodb… to bypass cache for your Innodb tables but there are other things you need OS cache for – MyISAM tables (mysql database, temporary etc) will… be less eager to swap things by echo 0 > /proc/sys/vm/swappiness is another helpful change though it does not…
