…tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) led to the maximum counter values being limited to…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 4 Comments
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…in-depth. If you try to do something like this in MySQL 5.5, you will succeed without errors or warnings: mysql> ALTER TABLE…in the default SQL mode, a duplicate index will throw a warning instead of a note. In…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… percona xtrabackup to 2.1.3. My node is crashed and I have this error in my log : 07…threads=2002 thread_count=6 connection_count=6 It is possible that mysqld could use up to key_buffer_size …in the manual which will help you identify the cause of the crash. 130528 09:53:56 mysqld_safe Number of…
Comment: How number of columns affects performance ?
May 25, 2013 By 12 Comments
…-10 ) different tables and minimize the record count in each table or would it be faster to add a column to differentiate between my types of data and put them all in the same table…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…of data in the largest table. You can find the individual SSB query definitions in my…number of rows must be joined together (Q4.1, Q4.2) but worse when small amounts of data are examined. Conclusion In…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
… about MHA for MySQL High Availability in the Cloud Matt Yonkovit, our VP of Consulting, will explain how to work with BigData effectively Justin… pt-table-checksum tool to verify replication integrity And finally, Andrew Ferlitsch will share with how MySQL can be used to provide access to government…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… without needed to grant access to another “backup” server. As noted by one of my colleagues (thanks Bill Karwin!), the cumbersome part of this process… to generate all of those statements for steps 7 and 10 in two scripts: mysql -N -B <<'EOF' > discard-ddl.sql SELECT CONCAT(‘ALTER TABLE `’, table…
Comment: ZFS on Linux and MySQL
June 7, 2013 By 17 Comments
… SSD for L2ARC, I’ll need to do the same for xfs… I am redoing my tpcc test with primarycache=metadata, if… to the filesystem. I took a look at OmniOS but frankly it was the first time I read something about it. How different is it from Solaris in term of porting? @kyle: Yes, that would be interesting…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… replication needs to replicate to all nodes at once, this means 1 copy of your replication message is sent to other node in the cluster… in my puny local VMs, but you get the idea. We can clearly see some factor in play adding the extra nodes. Multicast to… the scope of this post, but in my trivial VM environment, I just need to make sure that the multicast address space routes to my Galera…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…of snapshots. With LVM, your IO performance drops to 33% after the first snapshot so keeping a large number of… zealous. Pretty interesting to speed up point in time recovery when you …to start the snapshot while holding a “flush tables with read lock” and the flush operation will take some time to…
