June 19, 2013

Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

… drop in replacement for MySQL, downloads are available  here and from the Percona Software Repositories. Based on MySQL 5.1.69, this release… can be found in the 5.1.69-14.7 milestone at Launchpad. Bugs Fixed: In Ubuntu Precise libmysqlclient18 package was chosen… #1132412, bug fixed #1153651. Release notes for Percona Server for MySQL 5.1.69-17.4 are available in our online documentation…

Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available

… to announce the release of Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL on April 17, 2013. Binaries are available… script would fail to retrieve the Galera replication position on Ubuntu 10.04, because the different shell was used. Bug fixed… leave a slave hanging. Bug fixed #1130888 (Seppo Jaakola). If MySQL replication threads were started before running wsrep recovery, this would…

Comment: Is MySQL 5.6 slower than MySQL 5.5?

… of mysql-5.6! On 64bit Win7 host running 512 MB VirtulBox Ubuntu 12.04 guest(3.2.0-39-generic #62-Ubuntu SMP… size : 6144 KB fpu : yes fpu_exception : yes cpuid level : 5 wp : yes flags : fpu vme de pse tsc msr pae… (538.76 per sec.) # using skip-performance-schema with standard mysql-5.6.10-debian6.0-x86_64.deb package ! You may…

Post: Is MySQL 5.6 slower than MySQL 5.5?

… used Ubuntu 12.04 on some old Dell PowerEdge 2850 server. The questions I tried to answer are how much slower 5…=300 run For single thread MySQL 5.5 is 11% faster than MySQL 5.6. If you disable Performance Schema in MySQL 5.6 comes to just… production cases. For benchmark with 64 threads MySQL 5.5 is 26% faster compared to MySQL 5.6 and if you disable Performance Schema the…

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

…: CentOS, Debian, RedHat Enterprise Linux, SuSE Linux and Ubuntu. Of course CentOS and Ubuntu derive from RedHat and Debian respectively, but their…. In this particular case the problems were with MySQL packages upgraded from 5.1 to 5.5. The former were not fully uninstalled, the latter were in half-configured state. Obviously binutils has nothing to do with MySQL

Post: Is there room for more MySQL IO Optimization?

… cached — system files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses asynchronous IO which should allow it to… | Supermicro; PDSMi; v0123456789 (Other) Service Tag | 0123456789 Platform | Linux Release | Ubuntu 12.04.1 LTS (precise) Kernel | 3.2.0-35…

Post: Can we improve MySQL variable handling ?

… from command line with –no-defaults –verbose –help options: pz@ubuntu:~$ /usr/sbin/mysqld –no-defaults –verbose –help … timed-mutexes FALSE… with MySQL variables in automated way a lot more convenient would be extending INFORMATION_SCHEMA.GLOBAL_VARIABLES Currently as of MySQL 5.5 it…

Post: Announcing Percona Server 5.1.66-14.1

… 5.1.66-14.1 on October 26th, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.66, including all the bug fixes in it, Percona Server 5.1.66-14.1 is… causing SSL tests failures on Ubuntu Oneiric hosts. Bug fixed #902471 (Laurynas Biveinis). Fixed the upstream MySQL bug #62856 where check for…

Post: High availability for MySQL on Amazon EC2 – Part 4 - The instance restart script

…’|’ -f2` ssh -i /usr/local/bin/update_mysql ubuntu@$IP sudo ./updated_xinetd.sh $MYSQL_IP done < $TMPFILE rm $TMPFILE The full script.../update_mysql ubuntu@$IP sudo ./updated_xinetd.sh $MYSQL_IP done < $TMPFILE rm $TMPFILE /etc/init.d/heartbeat reload fi sleep 300 # 5 min…/bind-address/#bind-address/g’ /etc/mysql/my.cnf sudo service mysql restart sleep 5 /usr/bin/mysql -u root -proot -e “grant all…

Post: Percona Server and XtraBackup weekly news, March 19th

… our upcoming Percona Server 5.5 stable release. Vadim has also spent a lot of time benchmarking against MySQL 5.5. Sorry, I can’t… our Sales team to discuss. We have changed our Debian/Ubuntu packages to build with readline, not editline. This has been a problem with a lot of Debian/Ubuntu software. This fix will be released in the next version…