…. A star schema presents some unique challenge to the database optimizer. The SSB benchmark consists of four sets of queries. Each… user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log_buffer_size=32M innodb_buffer…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… nothing wrong with a virtual-machine approach, but for the optimal production deployment you want two identical physical boxes with at… replicate a specific database, a set of databases, or specific tables; you can also configure the slave to replicate everything EXCEPT… get the server up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL and several other InnoDB and query optimizer…Warnings: 0 mysql> SHOW CREATE TABLE test\G *************************** 1. row *************************** Table: test Create Table: CREATE TABLE `test` ( `id` int(11)…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… optimization. Server Configuration: [mysqld] user=root port=3306 innodb_status_file=0 innodb_data_file_path=ibdata1:100M:autoextend innodb_…innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file_per_table = true innodb…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… #1099387 (Alexey Bychko). Reduced the overhead from innodb_pass_corrupt_table value checks by optimizing them for better CPU branch prediction. Bug fixed…. Bug fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and –no-data options, all secondary key definitions would…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… #1099387 (Alexey Bychko). Reduced the overhead from innodb_pass_corrupt_table value checks by optimizing them for better CPU branch prediction. Bug fixed…. Bug fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and –no-data options, all secondary key definitions would…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb_flush_method = O_DIRECT innodb…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with… are thousands of tables and slow IO then XtraBackup can spend a lot of time opening all the tablespaces. Optimization has been… all InnoDB error or diagnostic messages are never printed by xtrabackup_56. Bug fixed #1169971. innobackupex would still run with FLUSH TABLES…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with… are thousands of tables and slow IO then XtraBackup can spend a lot of time opening all the tablespaces. Optimization has been… all InnoDB error or diagnostic messages are never printed by xtrabackup_56. Bug fixed #1169971. innobackupex would still run with FLUSH TABLES…
Post: MySQL alternative Percona Server 5.1.68 -14.6 now available
April 19, 2013 By 3 Comments
…. Bugs fixed #1031427 and #1051874. When mysqldump was used with –innodb-optimize-keys option it produced invalid SQL for cases when there… secondary keys from deferred key creation optimization. Bug fixed #1081016. When mysqldump was used with –innodb-optimize-keys and –no-data options, all… missing help texts in the MySQL client because the help tables were missing. Bug fixed #1041981. Other bugs fixes: bug fixed…
