… PCIe cards. It really makes sense to test it under MySQL workload, but before getting to that, let me review the… is the one that has biggest installation base. Driver information: Fusion-io driver version: 2.3.10 build 110; Firmware v5.0.7…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
…= $fields[2]; $PUBDNS = $fields[3]; $STATUS = $fields[5]; $START = $fields[10]; print “$SecGroup|$IPAdd|$Instance_ID|$AMI_ID|$PUBDNS|$STATUS|$START… will just install the MySQL version in the Ubuntu repository by doing: root@hamysql:~# apt-get install mysql-server-5.1 The package install MySQL has an…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… for MySQL 5.0.45, 5.0.51a, 5.0.54a and 5.0.56. I assume you have some MySQL version installed already… about installing MySQL on your platform. Also have a look at the files in the Docs directory. Thank you for choosing MySQL! Otherwise… yourself a cup of tea, because for the next 5-10 minutes, depending on the hardware, you will be sitting idle…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… : 4 fpu : yes fpu_exception : yes cpuid level : 10 wp : yes flags : fpu vme de pse tsc… /var/lib/mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different…etc etc. Nothing unusual. Next I check what the MySQL version is, and I check (with the ‘file’ command) …
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
…Pacemaker configuration A MySQL resource agent Here I will not cover the Pacemaker installation since this…the solution you’ll need my version of the MySQL resource agent, it is not yet…-lrm-refresh=”1322236006″ property $id=”mysql_replication” \ replication_info=”10.2.2.162|mysql-bin.000090|106″ rsc_…
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
…Server 5.5 series. In addition to MySQL 5.5.10 now being the base version, here are the changes that have been…following links: Downloads – binary distributions and Percona Software Repositories Installation instructions Consulting, support, training, and custom development Release notes …
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 20 Comments
…Updated version here. I recently had to work with many customers having large number of connections opened in MySQL…use them for benchmarking. On the desktop, I installed Percona-Server-11.2 which I configured with…open_files_limit = 32768 The desktop is running Ubuntu 10.04, has 8GB of RAM and a Core…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… hardware with you in SAN, NAS or Cloud installations. It all can be the cause of the … slowdown when data doubles, while in other case 10-20% difference in data size can be the… slave never is able to catch up. MySQL or OS version changesMySQL version changes (even minor upgrade) may introduce …
Post: MySQL Server Upgrade
August 11, 2006 By 9 Comments
…installing does not yet works with MySQL 5.0. Second – I know my applications designed to work with MySQL…MySQL 4.1 does not optimize well and so MySQL 5.0 will likely reduce performance. It is probably just 5-10…do not have to rush and use latest MySQL version neither it always makes sense to upgrade…
Post: MySQL for Hosting Providers - how do they manage ?
November 28, 2008 By 15 Comments
…over a year ago about 10+ ways to crash or overload MySQL and since that people have come…fresh our MySQL 5.1 GA or even something major on the roadmap for future MySQL versions. May be…MySQL/DOS server on purpose but rather cause most of the issues unintentionally by running bad queries or installing…
