…I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage …at low concurrency. The SSB The SSB tests a database’s ability to optimize queries for a star schema. A …than MyISAM when the database is cold, but uses less CPU time when the database is hot. I am only …
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… of Percona Server 5.1.69-14.7 on June 10, 2013. A drop in replacement for MySQL, downloads are available… include all the bug fixes in it. All of Percona’s software is open-source and free, all the details of… Precise libmysqlclient18 package was chosen from the distribution’s repository instead of Percona’s which could lead to package conflicts. Bug fixed…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… test environment to get familiar with the technology, certainly there’s nothing wrong with a virtual-machine approach, but for the… slaves at the bottom of the replication topology. On the top-level master, you leave all filters disabled; on the relay… that in the MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… represented by both HTML links and entity-relationship diagrams. It’s also designed to help resolve the obtuse errors that a… properties file in use for my Percona Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc…-java.jar Example Schema CREATE TABLE `parent` ( `parent_id` int(10) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`parent_id`) ) ENGINE…
Comment: ZFS on Linux and MySQL
June 4, 2013 By 17 Comments
… caching. However, limited ARC size also limits ZFS file system’s internal metadata caching(which l2arc and deduplication both need plenty… servers, and 384GB for Xeon E5-2600 servers, so sacrificing 10% ram for ZFS metadata is worthwhile.)
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…@percona2 ~]# chkconfig corosync off [root@percona3 ~]# chkconfig corosync off Let’s specify that the cluster can start without quorum: [root@percona1.../cluster.conf --setcman keyfile="/etc/corosync/authkey" transport="udpu" Let's check if the configuration file is OK: [root@percona1 ~]# ccs…@percona3 ~]# clustat Cluster Status for lefred_prm @ Thu May 23 10:20:36 2013 Member Status: Quorate Member Name ID Status…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… instances. The original idea was to configure them with raid-10 + LVM, making sure to stripe the LV when we need… and give ZFS a try. So I trashed the raid-10 arrays, configure JBODs and gave all those drives to ZFS… too useful for backups (most apply also for btrfs). Let’s review them. Snapshots ZFS does snapshot, like LVM but… since…
Post: Webinar: SQL Query Patterns, Optimized
May 20, 2013 By Leave a Comment
Next Friday, May 31 at 10 a.m. Pacific, I’ll present Percona’s next webinar, “SQL Query Patterns, Optimized.” Based on…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
… will give a talk on this topic at next month’s RAMP conference in Budapest, Hungary. My presentation will provide an…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… server or can I use mysql data directory? 2. What’s the advantage of using Percona server over MySQL? 3. I…
