… features in MySQL 5.6 - (Vadim Tkachenko, Percona) – Tuning Innodb is a huge part of my job, and getting up to 5.6…. Codership is really planning some exciting things for their 3.0 release. Day 3 Migrating to Percona XtraDB cluster - Once again… archiving using MySQL 5.6 new features of Portable Tablespace and EXCHANGE PARTITION - (Marco Tusa, Pythian) — This seems like a great 5.6 improvement…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
Post: Getting History of Table Sizes in MySQL
December 8, 2010 By 13 Comments
… watching the growth of space used on partition is not very helpful. Now as MySQL 5.0+ has information schema collecting and keeping this… put it to the cron to run nightly as: 1 0 * * * mysql -u root -e “INSERT INTO stats.tables SELECT DATE(NOW…’re looking to keep it completely inside MySQL you can create appropriate event in MySQL 5.1+ Unless you’re having millions of…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… happened – for XFS file system on a raw partition I was using full partition size which was slightly over 1TB in size… running on a Percona Server 5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/mysqld…; sunit/swidth set during mkfs. No LVM at this point. 5. Partition table aligned properly; sunit/swidth set during mounting but not…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
… the partition but it is not really empty: # df -h [...] /dev/loop0 985M 961M 0 100% /tmp Lets see which files has MySQL… /tmp partition. Increase the size of the binary log cache. binlog_cache_size and binlog_stmt_cache_size. Before 5.5.9 binlog… was used for both transactional and no transactional statements. After 5.5.9 the cache was splitted in two, binlog_cache_size…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… there’s striping like in RAID0, 5, 6 or any variation of them (5+0, 1+0, 1+0+0 etc.). While IO inside the RAID… –dataalignmentoffset. If you have set the offset correctly when creating partitions (see below), you don’t need to use –dataalignmentoffset, otherwise… RAID with 256k stripe element size and a misalignment in partition table – partition /dev/sdb1 starts 11 sectors ahead of the stripe…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
…-conflicts… Targets (4): libaio-0.3.109-6 libmysqlclient-5.5.30-1 mysql-clients-5.5.30-1 percona-server-5.5.29_rel29.4-1 Total… [########################################################] 100% mysql-clients-5.5.30-1-armv6h 736.6 KiB 395K/s 00:02 [########################################################] 100% :: Retrieving packages from community… libaio-0.3.109… card which is larger then 2GB, you can add another partition using fdisk & mkfs.ext4 (comment below if you cannot work…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…atomically, not just for new connections as in MySQL. This is very helpful for measurement as …0.1160 1.4% 5 0.0232 1.00 0.00 SELECT film # 9 0xCFC0642B5BBD9AC7 0.0987 1.2% 50 0.0020 1.00 0…`wp_blog_one `.`wp_options`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT option_name, option_value FROM wp_options…
Post: Percona Server 5.5.8 Beta Release
February 16, 2011 By 16 Comments
… Server 5.5.8-20.0 is now available for download. This is a beta release of Percona’s enhancements to the MySQL 5.5.8… to replication, partitioning, stored procedures More diagnostics and tunability More pluggability, including pluggable authentication In addition to building on MySQL 5.5, here are…
Post: Announcing Percona XtraBackup 2.0.5
January 23, 2013 By Leave a Comment
…what extra file to read the default MySQL options before the standard defaults-file. It…error message. Bug fixed #1089375 (Hartmut Holzgraefe). Partitioned tables were not correctly handled by the –databases, … all the bugfixes for Percona XtraBackup 2.0.5 are available in our online documentation. …
Post: Reading MySQL Enterprise future...
December 9, 2008 By 13 Comments
…mysql-5.1.30.rhel4.spec file from MySQL RedHat 4 SRPM. I found there few MySQL Enterprise Editions, namely: MySQL Enterprise Server – Advanced Edition MySQL… PARTITION_BUILD 0 %define INNODB_BUILD 1 So this one comes without Partitions. And MySQL Enterprise Server – Classic Edition %define PARTITION…
