May 25, 2012

Post: Percona-XtraDB version 9.1

…-XtraDB should be installed. It will replace currently installed mysql-server, mysql-client, etc. Centos platform. 1. If you didn’t install yet Percona…. Install Percona-XtraDB # yum install Percona-XtraDB-server Percona-XtraDB-client Debian platform. 1. Add Percona repository to the sources.list…

Comment: Slow Query Log analyzes tools

CentOS 4.4 (RHEL compatible) x86_64 Server 14M MySQL-server-5.0.33-0.glibc23.x86_64.rpm Max 3.3M MySQL…_64.rpm Microslow 2.6M MySQL-microslow-5.0.33-0.glibc23.x86_64.rpm Client 4.9M MySQL-client-5.0.33-0.glibc23.x86_64.rpm Shared libraries 1.7M MySQL-shared-5.0…

Comment: Which Linux distribution for a MySQL database server? A specific point of view.

…’ quite hard to get it to run. Running the commandline client from a cmd.exe is really not nice as resizing… MySQL Python module is only available if you bought a support contract). On CentOS/RHEL/OEL: The system MySQL is easy to install. CentOS 5 ships with MySQL 5.0.77 which is…

Post: XtraDB benchmarks - 1.5X gain in IO-bound load

… RAM on board with CentOS 5.2 as OS. This is quite typical server we recommend to run MySQL on. What is… compiled in MySQL) For benchmarks I used scripts that emulate TPCC load and datasize 40W (about 4GB in size), 20 client connections… as Linux kernels 2.6.18+ (which are used on CentOS / RedHat 5.2) are coming with CFQ scheduler as default…

Post: Percona Server 5.1.47-rel11.0

… fails to compile with CFLAGS=-DUNIV_DEBUG #569156 CentOS 5: mysql-server conflicts with MySQL-server #589639 Recovery process may hang when tablespaces….47-rel11.0.46.rhel5.x86_64.rpm Percona-Server-client-51-5.1.47-rel11.0.46.rhel5.x86_64…: “Percona-Server” is a name of the product. “server” or “client” – sub-package 51 – suffix, which means the packages are based…

Comment: Percona Server 5.1.53-11.7

When I try to compile this version from source, (CentOS 5.5 x86_64) I got 2 errors: ../libmysql/.libs/… returned 1 exit status make[2]: *** [mysql] Error 1 make[2]: Leaving directory `/root/Percona-Server1/client‘ make[1]: *** [all] Error 2 make[1]: Leaving directory `/root/Percona-Server1/client‘ make: *** [all-recursive] Error 1 ———- This problem solved by me…

Comment: Why MySQL could be slow with large tables ?

… = /var/lib/mysql socket = /var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using… installed, but when I change mysql vars and restart server, my configs are not applied, defautl mysql applied, and my.cnf are… Server with Apache 2.2. Mysql ver. 5.0.45 via socket on x86_64 centos 5.2, 1 CPU 4core with…