… in turn, load that data into and pollute the buffer pool. Note that this can be somewhat mitigated using innodb_old… (redo logs, binlogs, etc) as well further polluting the buffer pool. Enter Xtrabackup… As a quick refresher, Xtrabackup works by copying… into the target database: mysql orig_old < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…, remote/transportable tablespaces, separate undo tablespace, 5.6-style buffer pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5… copying failure. Bug fixed #1170806. innobackupex would fail if the SQL_MODE was set to ANSI_QUOTES. Bug fixed #945161. Missing…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL will now be shipped… was used with –innodb-optimize-keys option it produced invalid SQL for cases when there was an explicitly named foreign key… operations as synchronous when they were actually asynchronous when Thread Pool feature was used. Bug fixed #1107539 (Sergei Glushchenko). Suboptimal code…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL will now be shipped… was used with –innodb-optimize-keys option it produced invalid SQL for cases when there was an explicitly named foreign key… operations as synchronous when they were actually asynchronous when Thread Pool feature was used. Bug fixed #1107539 (Sergei Glushchenko). Suboptimal code…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
April 2, 2013 By 10 Comments
… that accesses existing innodb buffer pool and real time data (good for quick simple lookups where the SQL overhead is significant as…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… apply to storage engines only and which are used on SQL layer and apply to all storage engines. Lets start with… Pool, Key Buffer etc. It works for certain storage engines which support large pages in general. Currently MyISAM and Innodb. Some SQL… (allocated by each thread once sorting needs to be done) SQL Layer so works for all storage engines. timed_mutexes Show…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…pool_read_requestsblogpercona.commanual Innodb_buffer_pool_readsblogpercona.commanual innodb_buffer_pool_sizeblogpercona.commanual Innodb_buffer_pool_wait_freeblogpercona.commanual Innodb_buffer_pool…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…_heap_create_block (mem0mem.c:333) ==9090== by 0x6B07D3B: buf_pool_init (mem0mem.ic:443) ==9090== by 0x6BC6379: innobase_start_or… that accesses to the fields of buf_pool->stat are unprotected. These are buffer pool statistics counters: number of read, written, evicted….c:1447) ==9090== by 0x7A2EDA: cleanup_variables(THD*, system_variables*) (sql_plugin.cc:2566) ==9090== by 0x7A6667: plugin_thdvar_init(THD…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… id 8079, query id 728899 localhost root Sending data select sql_calc_found_rows * from b limit 5 Trx read view… will not be equal to total size of buffer pool, because buffer pool also stores lock information, adaptive hash indexes and some… not read to the buffer pool. Finally you can see buffer pool hit ratio which measures buffer pool efficiency. 1000/1000 corresponds to…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… implications: when the data does not fit in the buffer pool, fast index creation provides even better performance as compared to…, so let’s repeat the last test with innodb_buffer_pool_sizeset to approximately 1/10th of the dataset: mysql> SET… -uroot test –innodb-optimize-keys > dump_optimized.sql $ time mysql -uroot test < dump_unoptimized.sql real 2m52.785s user 0m3.179s sys…
