June 19, 2013

Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency

… 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_pool_instances=16 metadata_locks_hash_instances=32 table_open

Post: Percona Server 5.6.11-60.3 first Release Candidate now available

… Server 5.6 series. All of Percona’s software is open-source and free, all the details of the release can… any bitmap files. Bug fixed #1184427. Query to the INNODB_CHANGED_PAGES table would cause server to stop with an I/O… an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug fixed #1185040. The INNODB_CHANGED_PAGES table couldn…

Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

… bug fixes in it. All of Percona’s software is open-source and free, all the details of the release can… to a typo. Bug fixed #1175447. Query to the INNODB_CHANGED_PAGES table would cause server to stop with an I/O… changed page tracking is enabled. Bug fixed #1184517. The INNODB_CHANGED_PAGES table couldn’t be queried if the log tracker wasn…

Post: Percona Server for MySQL 5.5.31-30.3 now available

…. All of Percona’s software is open-source and free, all the details…innodb_read_views_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB… version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release…

Post: Benchmarking Percona Server TokuDB vs InnoDB

… SSD innodb_flush_neighbor_pages = none innodb_adaptive_flushing_method = keep_average innodb_file_per_table = true innodb_data_file_path = ibdata1:100M:autoextend innodb_flush… innodb options (fixed) port = 3306 back_log = 50 max_connections = 2000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache…

Post: MySQL and Percona Server in LinkBench benchmark

…=barracuda innodb_file_per_table innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 5000 sync_binlog=0 max_connections=5000 table_open_cache=5000 table

Post: Percona Server for MySQL 5.5.30-30.2 now available

… bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb_lazy_drop_table has been deprecated. Feature has… if there is a transaction that executed a query which opened that table. Bug fixed #1127008 (Sergei Glushchenko). Fix for bug #1070856…

Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue

… bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb_lazy_drop_table has been deprecated. Feature has… if there is a transaction that executed a query which opened that table. Bug fixed #1127008 (Sergei Glushchenko). Fix for bug #1070856…

Post: Percona XtraBackup 2.0.7 for MySQL available for download

… the world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. This… crash when preparing the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables that were dropped between taking a full backup… all InnoDB error or diagnostic messages are never printed by xtrabackup_56. Bug fixed #1169971. innobackupex would still run with FLUSH TABLES

Post: Virident vCache vs. FlashCache: Part 2

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 innodbinnodb options (fixed) back_log = 50 wait_timeout = 120 max_connections = 5000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open