…a particular MySQL schema and then reload it with a different schema name on the …mysql/orig_old Make sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run: ALTER TABLE…and allow remote users to compare on a live system without needed to grant access …
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…differently than traditional hardware, and I’ve seen situations where even under just a moderate load on the host system…system; there really isn’t anything quite like that in the MySQL world, except maybe MyISAM files on…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… a production system, you will…mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create a new table on the master: mysql> create table…different replication modes on different servers, but only if all servers have gtid_mode set to ON. Could it be interesting to run file…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…different major versions of Percona Server. Bug fixed #1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL…files. Bug fixed #1184427. Incorrect schema definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
…system where the storage engines themselves owned their own metadata. This was a radical departure from the MySQL…on each field you reduce the number of different…MySQL table. So what’s the maximum number of columns in a MySQL table? Well.. I tried a few things before I settled on…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…TABLE statement was used, but it will still replicate in case DROP TABLE statement is used on a temporary table… replication position on Ubuntu 10.04, because the different shell was … than once in the MySQL configuration file (my.cnf). Bugs fixed #…them to our bug tracking system. UPDATE[18-04-2013]:…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…on both systems. The benchmark tool used was sysbench 0.5 and the version of MySQL…couple of different dirty-page ratios on …mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration A) appears below: #####fixed innodb options innodb_file…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… pt-table-…on its primary objective: analyzing MySQL…MySQL that have critical bugs. Version check will warn you about these if your system…mysql-summary 2.2 have all the standard MySQL options built-in, like other tools: –user, –host, –port, –password, –socket, –defaults-file…little differently. …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…on the partition table, but proper alignment options on the file system. This is what we get when file system…Different file sizes made no difference too. Write-back cache gave an incredible performance boost – up to 33x in single-threaded workload. File system…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… loaded the values from MySQL 5.5.30 and MySQL 5.6.10 to the different tables and ran the query: mysql [localhost] {msandbox} (test… significant gains unless opening and closing files is expensive operation (such as using MySQL on NFS file system). innodb_data_file_path got a small change…
