… thinking about HA in a holistic fashion and help guide you towards asking the right questions when considering a new or upgraded HA deployment. This webinar will be both technical and non-technical in nature, beginning with a discussion… stack) and then conclude with some typical use cases where a given approach may be well-suited or particularly contraindicated. If…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
… seems to be down. Basically I have a problem regarding long running select query. A query runs for say 300 seconds and because the resultset is huge, it eventually starts creating a temp table on… by set global query_cache_size = 0; All this on a fairly decent size server where I have 6GB innodb_buffer…
Comment: Is there a performance difference between JOIN and WHERE?
May 29, 2013 By 30 Comments
…. If your boss is wildly deviating what he needs on a continual basis, he’s either incompetent, lazy, abusive, or just… that rule — extenuating circumstances and all that — but it shouldn’t be a daily (or even weekly) occurrence.
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…log tracker thread was unaware of the situation when the oldest untracked log records are overwritten by the new…bit signed integers. Fixed so that these values can be 64-bit unsigned integers now. Bug fixed #…dir variable didn’t have the path separator at the end. Bug fixed #1181887. A warning is now…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 2 Comments
…5.5.31-30.3). New Features: Percona Server has implemented…a bitmap file name could stop the server starting if the innodb_data_home_dir variable didn’t…STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) …Fixed so that these values can be 64-bit unsigned integers …
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…0.00 sec) In previous versions of MySQL, you can create two indexes with the same columns (in the … this is always naming your keys with a consistent pattern. This new behavior was introduced in 5.6….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 need too, and isn’t…a few sample output lines generated by the plugin with this configuration: {“msg-type”:”activity”,”date”:”1369155747373″,”thread… opening new possibilities of extending MySQL’s behavior in a way…
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 master… 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
… corosync[1535]: [MAIN ] parse error in config: Can‘t open logfile ‘/var/log/corosync.log’ for reason…QUORUM_TIMEOUT=0/g” /etc/sysconfig/cman And create the cluster, perform the following command on …then to delegate the fencing to pacemaker (adding a fence device, fence methods to specific node …
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…tests were done on a relatively fast machine with a Xeon E5-2680 (8 cores, 16 threads) with fast IO (OCZ…database is hot. I am only speculating (and I can investigate further), but I believe the adaptive hash …only when the buffer pool is cold. Please don’t take away that you should be using MyISAM …
