… libdbd-mysql-perl package. Fixed by adding the package dependency. Bug fixed #1003776. XtraDB changed page tracking used to hold the log… bug #69379 which caused MySQL clients to return bogus error number for host-not-found errors on Ubuntu 13.04. Bug fixed… page tracking is enabled. Bug fixed #1184517. The INNODB_CHANGED_PAGES table couldn’t be queried if the log tracker wasn’t…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… we’re running Innodb with MySQL we can use Innodb_data_reads , Innodb_data_writes, Innodb_os_log_fsyncs for your disk… query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld) S 1… requires significant number of CPU. With Percona Server, enabled full query logging and log_slow_verbosity=full you can also get great amount…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
…, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses …v0123456789 (Other) Service Tag | 0123456789 Platform | Linux Release | Ubuntu 12.04.1 LTS (precise) Kernel …enable Random Read_Ahead which is not available in MySQL 5.5 (different version is added back in MySQL…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…mysql You can also the whole branch from here: https://github.com/y-trudeau/resource-agents/zipball/master On my Ubuntu…enabled=”false” \ no-quorum-policy=”ignore” \ last-lrm-refresh=”1322236006″ property $id=”mysql_replication” \ replication_info=”10.2.2.162|mysql… if slaves are logging replication …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… Summary Report ############################## Platform | Linux Release | Ubuntu 10.04.2 LTS (lucid)…mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb_flush_log… used. With WT cache enabled, single thread performance improvement…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
… Server would fail to install on a vanilla Ubuntu 12.04 server. Bug fixed #1103655 (Ignacio Nin… command line option innodb_changed_pages_limit. MySQL option handling would then shadow the former …plan information were being logged even if they weren’t enabled for the slow query log. Bug fixed #730173…
Post: Percona XtraDB Cluster: SElinux is not always the culprit !
December 20, 2012 By 5 Comments
…doesn’t work properly and a node having SElinux enabled won’t be able to join the cluster. So… first reflex is to have a look at audit.log. But recently I faced another problem: the node … it seems that on this server (Ubuntu TLS), a previous version of MySQL was installed and then removed but the…
Post: Announcing Percona Server 5.1.66-14.1
October 26, 2012 By Leave a Comment
…tests failures on Ubuntu Oneiric hosts. Bug fixed #902471 (Laurynas Biveinis). Fixed the upstream MySQL bug #62856 …support resulted in confusing messages in the error log on Percona Server startup, even when flashcache … and when set to 1 checks are enabled. Error message has been made more verbose …
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 21 Comments
…influence, because those idle threads are presents in internal MySQL list objects that need to be scanned and …: innodb_buffer_pool_size=1G innodb_log_file_size=64M innodb_log_buffer_size=8M innodb_flush_method=…is running Ubuntu 10.04, has 8GB of RAM and a Core i5 CPU (dual core with HT enabled). …
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
… Log output to syslog is enabled by default Updated DEB and RPM packages Query log …MySQL UNIX socket protocol, javascript plugin, authentication via tables (similar to MySQL), RabbitMQ, regex policy, logging to…-stable from source tar package. The Ubuntu packages are available from the Drizzle PPA…
