…FILES_LIMIT | 1024 | 5000 | | INNODB_AUTOEXTEND_INCREMENT | 8 | 64 | | MAX_CONNECT_ERRORS…files is expensive operation (such as using MySQL on NFS file system). innodb_data_file_path got a…number of different variables which would make more sense in my opinion. MySQL 5.6 adds a…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…in the system…in this case it resides in /usr/sbin, because the other file is just a manual. For the following operations…in a comma-separated string. [microtime, query_plan, innodb…in seconds. Instead it will want you to specify the number…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…2 cores, run 80 workers. Test the system. You should see the following row count (the first number…INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file-per-table innodb-flush-log-at-trx-commit=1 innodb…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…systems with similar features set for other operation systems. Veritas File System can do it for Solaris. Most SAN systems…file system Why snapshot based MySQL backups are great ? There are number of reasons: Almost Hot backup In…
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
…operational…in particular for classic database/storage systems. Few systems are design with so much error detection and automated handling in mind as Google File System. In…Innodb…a large waste, especially as most of systems have even number…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…systems. Provide data to “external triggers” such as Gearman jobs. CDC tools usually operate in…error. It will exit with a message “setup completed” otherwise. Verify installation The binary log stores it progress in a…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…operation…file Run myloader –threads=x Load the schema-post file I will get into specifics on the tips/tricks to restore data in a…error and are aborted, we send a critical alert immediately to be investigated The number…
