… pmp-check-mysql-deleted-files plugin will alert when files have been deleted but remain open via a filehandle. Wrong filesystem privileges. It’s very easy for a file to creep into MySQL‘s data directory with wrong… actual failure. The pmp-check-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running checks that replication is…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
… it already was if the filesystem on top of DRBD was fried beforehand. Let us again compare MySQL Replication to DRBD in… very natural for them to use same approach for MySQL as they use for PostgreSQL for example instead of investing time to learn about MySQL Replication or just looking to keep MySQL infrastructure…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just …capacityblogpercona.commanual innodb_lock_wait_timeoutblogpercona.commanual innodb_locks_unsafe_for_binlogblogpercona.commanual innodb_log_buffer_sizeblogpercona.commanual innodb_log_…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
… Filesystem volume name: Last mounted on: /mnt/data Filesystem UUID: f9f7a0c3-0350-46d5-9930-29c3ac1f4b32 Filesystem magic number: 0xEF53 Filesystem revision #: 1 (dynamic) Filesystem …, which is probably not needed for partition you store MySQL data on, as chances are MySQL server is only one doing …
Post: Why you can't rely on a replica for disaster recovery
July 31, 2010 By 25 Comments
… specialized tools for doing. It’s an intensive process that costs a little money.) The problem was that the filesystem was ext2… over the interconnect, without regard to logical consistency on the filesystem level. Two things can help avoid such a disaster: 1… way. At a higher level, MySQL replication has the same weakness. If you rely on a MySQL slave for a “backup,” you’ll…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… tests for MyISAM and Innodb tables on ext3 filesystem. Here is what I found: The fragmentation we speak in this article is filesystem… number of inserts going to random tables. I used default MySQL settings for MyISAM (table_cache=64) and set innodb_buffer_pool… contrary to my expectation this filesystem was created without dir_index option which should add significant overhead for insert with many tables…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
…-16G for Swap — 10-20G for the OS (/) Possibly 10G+ for /tmp (note you could also point mysql‘s tmpdir elsewhere) Everything else for MySQL (/mnt/data or similar): (sym-link /var/lib/mysql into here when you setup mysql) Are… FAQ is a good place to check out for more details. Mount the filesystem Again, there are many options to use here…
Post: Percona Server tree with support of Fusion-io atomic writes and DirectFS
September 24, 2012 By Leave a Comment
… to providing a native filesystem (directFS) with a goal to avoid overhead from kernel and regular Linux filesystems: ext4 and xfs. This requires a support from application, it should use special calls for IO. With help… to general release. Contact Fusion-io at developer.fusionio.com for details, or speak with Fusion-io in New York at…
Post: Fusion-io atomic writes and DirectFS
September 20, 2012 By Leave a Comment
… to providing a native filesystem (directFS) with a goal to avoid overhead from kernel and regular Linux filesystems: ext4 and xfs. Fusion… share performance numbers. It is not too late to register for conference and talk with Fusion-io engineers directly. “PerconaNY” registration…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
….02 | +————–+—————+—————————–+—————+ 22 rows in set (0.02 sec) Recovering filesystem space Now astute innodb experts will realize that …, then you can rebuild the tablespace for your table by simply doing: mysql> alter table mytable ENGINE=Innodb; …
