… #714925. mysql_set_permission was failing on Debian due to missing libdbd-mysql-perl package. Fixed by adding the package dependency…, potentially limiting performance on write-intensive workloads. Bug fixed #1171699. Missing path separator between the directory and file name components in… bug #69379 which caused MySQL clients to return bogus error number for host-not-found errors on Ubuntu 13.04. Bug…
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
… component of the tool. There are additional tabs: Tables – Names, number of children, parents, count of columns, row counts, and comments… if you have any implicit constraints that you might have missed and can then write into your metadata file. Donate – This…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still register to view the recording and… between 47000 and 50000 with no movies, but your random number generator picks values in that range with equal frequency as…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… master_port=10002; mysql> start slave; # And then check the number of records from the t table s1> select count(*) from… slave will be the new master is to recover the missing events with mysqlbinlog. Let’s say that we want to…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…) This release of Percona Server for MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has…. Bug fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing. Bug fixed #1041981 (Alexey Bychko). Fixed the upstream bug #68197…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…) This release of Percona Server for MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has…. Bug fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing. Bug fixed #1041981 (Alexey Bychko). Fixed the upstream bug #68197…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… built from the source rpm, wsrep revision information would be missing. Bug fixed #1128906 (Alexey Bychko). The method of generating md5… (Teemu Ollakka). Standard MySQL port would be used when port number wasn’t explicitly defined in the wsrep_node_incoming_address… fixed #1164992 (Alex Yurchenko). Percona-XtraDB-Cluster-galera package version number didn’t match the wsrep_provider_version one. Bug fixed…
Post: Percona XtraBackup 2.1.2 for MySQL available for download
May 18, 2013 By 4 Comments
… download site here and Percona Software Repositories. This release fixes number of high-priority bugs since version 2.1 became GA…. Bug fixed #1180672. The format of xtrabackup_galera_info was missing the ‘:’ separator between the values of wsrep_local_state_uuid…
Post: Percona Playback 0.6 for MySQL now available
April 9, 2013 By 1 Comment
…-threads-count option, which can be used to specify the number of threads in the thread pool dispatcher plugin. Bugs fixed… query parsing has been improved. Bug fixed #1080648 (Vlad Lesin). Missing build dependences have been added to the README file. Bug…
Post: What MySQL buffer cache hit rate should you target
June 29, 2006 By 5 Comments
… you have 100 rows per page you will get 1 miss per page and 99 hits, making your hit ratio 99… be to look at response time contribution – how much buffer misses (physical reads) contributed to response time ? This would take into… the number of misses – number of IOs which MySQL needs to do. You better to look at global and local (per thread) numbers and…
