…MySQL enforce this kind of constraints? For many reasons: the first one because it would break 99% of all applications out there that use MySQL…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath=/usr/share/java/mysql-connector-java… level overview of the table sizes and an easy way to use the search feature of your browser to zero in on a particular table Constraints…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…table would cause server to stop with an I/O error if a bitmap file in the middle of…-mysql-perl package. Fixed by adding the package dependency. Bug fixed #1003776. XtraDB changed page tracking used… #1186690. Under very rare circumstances, deleting a zero-size bitmap file at the right moment would …
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… was used. O_DIRECT was used so, there was no caching of data at the filesystem level. The InnoDB indexes were built using ALTER TABLE… sort via ALTER TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…MySQL version 5.6.11-60.3[/caption] Percona is glad to announce the first Release Candidate release of…calloc() directly instead of using InnoDB heap …size. Bug fixed #1169494. Fixed the RPM package dependencies issues. Bug fixed #1186831. Reduced the overhead from the Handle Corrupted Tables…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… The Solaris side is cleverly setup using zones and ZFS and this …easily handle the write load of all the MySQL instances. The original idea was…size to 4GB. I don’t want to start a war but ZFS performance level was less than half of…the snapshot while holding a “flush tables with read lock” and the …
Post: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
…of a MySQL standby server hot using MySQL…mysql/slow_query.log { nocompress create 660 mysql mysql size 1G dateext missingok notifempty sharedscripts postrotate /usr/local/bin/mysql…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…of data size of datadir ~10GB). We used this dataset to check server behavior when data fully fits buffer pool(size of…size of the buffer pool is the same – 30GB. So now we explore the IO-bound scenario. Percona Server 5.5 outperforms MySQL…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…of a replication feedback mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the lack of understanding of…size of the transactions, which translates into number of unique key lookups into the certification index, which is a hash table…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… kernel in use for all of the benchmarks on both systems. The benchmark tool used was sysbench 0.5 and the version of MySQL used was… base MySQL configuration (configuration A) appears below: #####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table…
