… reference, these are the lines I had to add to my config file for the plugin to work (plus one commented line for switching…”:”0″,”user”:”debian-sys-maint”,”priv_user”:”debian-sys-maint”,”host“:”localhost”,”cmd”:”Connect”,”query”:”Connect”} {“msg-type”:”activity”,”date”:”1369155747373…-sys-maint”,”host“:”localhost”,”cmd”:”Connect”,”query”:”Connect”} In conclusion, the plugin API seems to be opening new possibilities of extending MySQL‘s…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…host filesystem rather than an actual physical volume. So, in effect, you’re adding performance hit to… disabled; on the relay master you add binary log filters; this ensures that…MySQL to determine when it’s not responsive? A: The easiest way to do this is to simply connect to it and attempt to…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… to add another layer of protection to the backups. innobackupex now uses Perl’s DBD::MySQL package for server communication instead of spawning the MySQL… –remote-host has been completely removed in Percona XtraBackup 2.1. Percona XtraBackup can use XtraDB changed page tracking feature to perform…
Post: Percona XtraBackup 2.1.0 for MySQL alpha now available
April 2, 2013 By Leave a Comment
…to add another layer of protection to the backups. innobackupex now uses Perl’s DBD::MySQL package for server communication instead of spawning the MySQL… for MySQL. After being deprecated in previous version, option –remote-host has been completely removed in Percona XtraBackup for MySQL 2….
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…or hearing you say “we are a SaaS hosted application for data mining stock market transactions,” or… Starting to look at MySQL Assuming I don’t see anything noteworthy here, I’ll move on to the MySQL … a “garbage” query that just adds latency and makes the overall time to complete an action longer. If…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…and EPEL repositories for software installation. To add these follow the instructions for Percona and EPEL to enable those. After configuring the …going to hit the c1 server. # sysbench –test=oltp –db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…to MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
… for short bursts is important to know. Add just a bit more data, or add a bit more load, …: 0 Rows_read: 0 # administrator command: Quit; # User@Host: webuser[webuser] @ [10.14.82.196] # Thread_id: … about it — and that’s where improvements to the MySQL source code are necessary. But in many cases …
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
… with RAID’ed EBS volumes and MySQL, versus RDS machines. For reasons that won’t add anything to this discussion, I got sidetracked…. Instead, I want to write an overview of these two approaches to hosting MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and EBS isn’t always great in comparison to what…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
…host name. While there, you could also assign a permanent IP address (still assigned via DHCP) by binding a MAC address to…mysql client: [root@alarmpi ~]# /usr/bin/mysql Welcome to the MySQL monitor. Commands end with ; or \g. [...] mysql… then 2GB, you can add another partition using fdisk & mkfs…
