May 25, 2012

Comment: How much memory Innodb locks really take ?

I am considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program…

Comment: How to change innodb_log_file_size safely

… file. I renamed it and copied /usr/share/doc/mysql-server-5.0.95/my-medium.cnf to /etc/my.cnf After doing…

Comment: How to change innodb_log_file_size safely

… connections. Version: ‘5.0.95′ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution Also, I don’t see how MySQL could be using… other conf file other than /etc/my.cnf [root@tstlx1 mysql]# locate my.cnf /etc/my.cnf /etc/my.cnf.old /etc/my.cnf.rpmnew [root@tstlx1 mysql]# cat /etc/my.cnf | grep log_file # Set .._log_file…

Comment: How to change innodb_log_file_size safely

… able to change the logfile size in a 5.0.95 MySQL database running on RHEL 5. I add the following line to /etc…

Post: New distribution of random generator for sysbench - Zipf

…,000/(10,000^1.1) = 39 times. Obviously with θ=0 we are getting uniform distribution – each row is accessed equal… on how many times each row selected for different θ: 0.5, 0.9, 1.1: The curve is very skewed, so I… !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id…

Post: Percona Server 5.5.23-25.3 released!

… Server 5.5.23-25.3 on May 16, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.23, including all the bug fixes in it, Percona Server 5.5.23-25.3 is now… the details of the release can be found in the 5.5.23-25.3 milestone at Launchpad. Bugs Fixed: Percona Server…

Post: Announcement of Percona XtraDB Cluster 5.5.23

… XtraDB Cluster 5.5.23, which comes with bug fixes and improvements. List of changes: Fixes merged from upstream (Codership-mysql) Support for… tar.gz and RPM binaries for RedHat (CentOS, Oracle Linux) 5 and 6, and Debian packages. Downloads: http://www.percona.com…

Post: Zero-Downtime Schema Changes In MySQL

…_x table why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening? I would… disables binary logging at all. Are you using the 2.0 version of this tool? It was completely rewritten in version…

Post: Percona Server 5.1.62-13.3 released!

… available here and from the Percona Software Repositories). Based on MySQL 5.1.62, including all the bug fixes in it, Percona… the details of the release can be found in the 5.1.62-13.3 milestone at Launchpad. New option rewrite… encoded within the BINLOG ‘….’ statement. Release notes for Percona Server 5.1.62-13.3 are available in our online documentation.

Post: Percona Server 5.5.22-25.2 released!

… Server 5.5.22-25.2 on April 25, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.22, including all the bug fixes in it, Percona Server 5.5.22-25.2 is now… the details of the release can be found in the 5.5.22-25.2 milestone at Launchpad. Bugs Fixed: While running…