… candidates for dropping (why keep old data if you don’t need to?). ….10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0…high level overview of the table sizes and an easy way to use…. This is basically a quick sanity check of your schema for any significant…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3…_CHANGED_PAGES query started returning data to indicate an incomplete result set. …size. Bug fixed #1169494. Fixed the RPM package dependencies issues. Bug fixed #1186831. Reduced the overhead from the Handle Corrupted Tables check…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… this benchmark for MySQL Server 5.5.30, 5.6.11 and Percona Server 5.5.30 and check how these servers…(after load of data size of datadir ~10GB). We used this dataset to check server behavior when data fully fits buffer pool(size of buffer…. Percona Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate notable drops…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…). So it makes sense to check if the dataset size makes any difference. We first excluded…spherical read-only cow and throw some data updates into the mix, limitations of … –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…check-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running checks that replication is functioning correctly. Replicas have different data… handle max_connections problems (the use of fixed-size connection pooling, for example, which can sometimes require …
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… installed something for graphing check out Cacti Tempates which have a lot of such goodness. Data Size ChangesThe more data you have the more… may see only modest slowdown when data doubles, while in other case 10-20% difference in data size can be the difference between slave never lags and slave never is able to catch up. MySQL or OS…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… to the amazing MySQL manual, especially the option and variable reference table…data_pending_readsblogpercona.commanual Innodb_data_pending_writesblogpercona.commanual Innodb_data_readblogpercona.commanual Innodb_data_readsblogpercona.commanual Innodb_data_writesblogpercona.commanual Innodb_data…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… Check for Table Cache Related Allocations There are cases when MySQL …mysql> select sum(data_length+index_length) from information_schema.tables where engine=’memory’; +——————————-+ | sum(data… allocated 2623331 Buffer pool size 7864319 Buffer pool size, bytes 128849002496 Free …
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
… blocks: 3616208434 Free inodes: 226918374 First block: 0 Block size: 4096 Fragment size: 4096 Reserved GDT blocks: 316 Blocks per group: 32768… these auto check functions for your data partition and just check it manually as needed, same as you would every so often check MySQL tables…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… a disk problem, I pointed the MySQL 5.6.10 at the MySQL 5.5.30 data directory. Tthe speed was essentially the… data size, so I configured the server with a 4GB buffer pool. I tested both versions, and as you can see above, MySQL….000000 | 0.000000 | 0 | 0 | 0 | 0 | 1 | 1 | | 4 | checking permissions | 0.000015 | 0.000014 | 0.000000 | 0.000000 | 0…
