June 20, 2013

Post: Understanding the maximum number of columns in a MySQL table

… code base. However… for those using MySQL, Percona Server, MariaDB or any other of the MySQL branches/forks, you get to have… UI for generating reports. This evolved into the SQL based MySQL, with MySQL 1.0 being released in 1995. The FoRM file… engine to InnoDB however, you will get an error message! The exact error message you get is not very interesting and just…

Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released

… it already tried pretty hard to keep working despite recoverable errors and such. Whereas pt-osc 2.1 only retries certain… a standard (http) connection. pt-stalk and pt-mysql-summary have built-in MySQL options No more “pt-stalk — -h db1 -u me”. pt-stalk 2.2 and pt-mysql-summary 2.2 have all the standard MySQL options built-in, like other tools…

Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue

… scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing… has been improved. (Laurynas Biveinis) Bugs Fixed: Due to parse error in the percona-server.spec Percona Server rpm packages couldn… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…

Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download

… version of Percona XtraBackup has implemented full support for new MySQL 5.6 features (GTID, remote/transportable tablespaces, separate undo tablespace… for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced… different implementation in MySQL 5.6 error messages were not printed to stderr directly. Because of that all InnoDB error or diagnostic messages…

Post: Percona Monitoring Plugins 1.0.3 for MySQL now available

… Percona Monitoring Plugins 1.0.3 for MySQL — high-quality components to add enterprise-grade MySQL monitoring and graphing capabilities to your…-privs didn’t throw the proper error on directory permissions issue (bug 1024001) * pmp-check-mysql-replication-running reported OK when a… Utilities. Also the following Cacti graphs need to be recreated: MySQLMySQL Threads”, Linux “Network Traffic”. A new tarball is available from…

Comment: Percona Server 5.5.30 with TokuDB for MySQL

I follow http://dev.mysql.com/doc/refman/5.5/en/binary-installation.html and seems to be fine, but when I try to run mysql command-line I found this: # bin/mysql bin/mysql: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory What I miss?

Comment: Percona XtraBackup 2.0.7 for MySQL available for download

… get this error: “innobackupex: fatal error: no ‘innodb_buffer_pool_filename’ option in group ‘mysqld’ in MySQL options” My server is MySQL 5.5…” innodb_buffer_pool_filename is not a global variable of MySQL 5.5, why this error? thanks!

Comment: Percona Server 5.5.30 with TokuDB for MySQL

I can start the server but failed to connect the server. error message: $ mysql -S /u01/tokudb/run/mysql.sock -uroot ERROR 2012 (HY000): Error in server handshake Is there any solution?

Post: Virident vCache vs. FlashCache: Part 2

…time=7200 ­­–max­-requests=0 ­­–percentile=95 ­­\ –mysql­-user=root –mysql­-socket=/tmp/mysql.sock ­­–mysql­-table­-engine=innodb ­­\ –oltp­-read­-only=off run…max_connections = 5000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache = 10240 max_allowed_packet = 16M binlog…

Post: Benchmarking Percona Server TokuDB vs InnoDB

…=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on… max_connections = 2000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache = 2048 max_allowed_packet = 16M binlog… = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related options are…