…volume. So, in effect, you’re adding performance hit to performance hit. The other reason is because virtual…directly connected from one machine to another and configured with Linux network interface bonding in balance-rr …-tables and insert a few rows into an InnoDB table, but trying to run a simple …
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… instances each of production database servers and will perform the backups. The write load is not excessive … the MySQL instances. The original idea was to configure them with raid-10 + LVM, making sure to … ready for the task. Snapshots work best with InnoDB, with MyISAM you’ll have to start the …
Post: Webinar: MySQL 5.6 Performance Schema
May 13, 2013 By 5 Comments
… overview of Performance Schema, focusing on new features that have been added in MySQL 5.6, go over the configuration and spend most time showing how you can use the wealth of information Performance Schema gathers to understand… Excessive internal mutex contention Slow queries due to waits on InnoDB locks and Meta Data locks Interested ? Sign up today!
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…configuration (configuration A) appears below: #####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… Configuration: [mysqld] user=root port=3306 innodb_status_file=0 innodb_data_file_path=ibdata1:100M:autoextend innodb_flush_log_at_trx_commit = 2 innodb… = 8 innodb_write_io_threads = 8 innodb_io_capacity = 2000 max_connections=5000 table_open_cache=5000 query_cache_type=OFF performance_schema…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb_lazy_drop_table… Bychko). UDF/configure.ac was incompatible with automake 1.12. Bug fixed #1099387 (Alexey Bychko). Reduced the overhead from innodb_pass_corrupt…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… performance issues around mutexes and Percona Server shows much better results Configurations and how to run benchmark: [mysqld] user=root port=3306 innodb_buffer_pool_size = 30G innodb_flush_method = O_DIRECT innodb_log…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable innodb_lazy_drop_table… Bychko). UDF/configure.ac was incompatible with automake 1.12. Bug fixed #1099387 (Alexey Bychko). Reduced the overhead from innodb_pass_corrupt…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. This release is the current… by log copying thread is now configurable by innobackupex –log-copy-interval. Making the interval configurable allows to reduce the time between…
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
…MYSQL server and found that Percona need some configuration setting regarding to memory allocation. So we ….cnf file, site performance was good. But from second day again performance degradation started and now ….66 [Percona XtraDB Cluster (GPL) (5.5.30)] (InnoDB Engine) PHP My Admin – 5.3.3 Hardware…
