…tracker thread was unaware of the situation when the oldest untracked log records are overwritten by the new…page data. Bug fixed #1108613. Percona Server wouldn’t start if the XtraDB changed page tracking …bit signed integers. Fixed so that these values can be 64-bit unsigned integers now. Bug fixed …
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…term basis which has given me time to explore new tools using their environments. One tool that I …a directory that can then be accessed by a web server. Also note that since I created the mysql….tab the most useful component of SchemaSpy, I don’t want to leave you with the impression that …
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… Server 5.5.31-30.3). New Features: Percona Server has implemented Log…_data_home_dir variable didn’t have the path separator at the …(CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) led …. Fixed so that these values can be 64-bit unsigned integers now. …
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based …0.00 sec) In previous versions of MySQL, you can create two indexes with the same columns (in the …also for filtering by just the first one. Why can‘t MySQL enforce this kind of constraints? For many …
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
…can be obtained from the slow or general log, but this involves a lot of data you don’t…”,”query”:”Connect”} {“msg-type”:”activity”,”date”:”1369155747373″,”thread-id”:”6439″,”query-id”:”219309″,”user”:”debian…, the plugin API seems to be opening new possibilities of extending MySQL’s behavior in…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…: mysqldump –no-data orig > /tmp/orig.schema.sql Create the new target database: mysqladmin create orig_old Load the schema into the target… rather than needing to import from a remote server. This can allow for more targeted restores, easier comparison, and allow remote… mind for this technique would be: Targeted schema migration (to new schema name) using –include=”^orig[.]“ (i.e. functional partitioning) Combine…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
…’t though.) Why don’t you try writing a SQL query optimizer and see how easy it is? ;-) Generative grammars like SQL can… optimizer analyzes queries for common patterns the MySQL designers know can be improved. But there’s a finite amount of engineer…` by a secondary index. But the result was that it created a temporary table to count the movies per production year…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… scenario can happen when you want to perform a planned failover. With GTIDs, all the operations are straightforward: #For s2 (the new… position needs to be done with care if you don’t want to break replication or corrupt your data. Scenario #2… can read the binary logs of the crashed master. The first thing to do after choosing which slave will be the new…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…:34:12 percona1 corosync[1535]: [MAIN ] parse error in config: Can‘t open logfile ‘/var/log/corosync.log’ for reason: Permission denied…_TIMEOUT=.*/CMAN_QUORUM_TIMEOUT=0/g” /etc/sysconfig/cman And create the cluster, perform the following command on one server only…: [ percona1 ] Slaves: [ percona2 percona3 ] We can see that some resources changed this is because we didn’t put it in maintenance on…
Comment: MySQL alternative Percona Server 5.1.68 -14.6 now available
May 28, 2013 By 3 Comments
Hi, I can‘t find any 5.1 files in the yum repos. Have they been moved to a new location (for example, I’m checking repo.percona.com/centos/5/os/x86_64/ )? The apt repo seems to be okay though. Thanks!
