… Lorch III). Fixed the upstream bug #62578 which caused MySQL client to abort the connections on terminal resize. Bug fixed #925343… loaded with Perl and Python clients when plugin-dir option was set in the [client] section of the my.cnf. Bug fixed #1155859 (Sergei… #1154954 (Hrvoje Matijakovic). Release notes for Percona Server for MySQL 5.5.30-30.2 are available in our online documentation. Bugs…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… Lorch III). Fixed the upstream bug #62578 which caused MySQL client to abort the connections on terminal resize. Bug fixed #925343… loaded with Perl and Python clients when plugin-dir option was set in the [client] section of the my.cnf. Bug fixed #1155859 (Sergei… #1154954 (Hrvoje Matijakovic). Release notes for Percona Server for MySQL 5.5.30-30.2 are available in our online documentation. Bugs…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
…has been moving towards the parallelized purge: in MySQL 5.5 there is an option to have a single… provided by Sysbench, a single table workload, 16 client threads. The growth of the history list and… results are on Benchmark Wiki and the relevant my.cnf settings were innodb_buffer_pool_size=16G innodb…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…introduced an incompatible change in collations in MySQL 5.1.24. If the following collations were…across machine restarts. The configuration variables for my.cnf have been kept for compatibility and …FEDERATED engine and a replication environment, its client connection to the remote server was …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… to use in some cases): vmstat 5 5 iostat -dx 5 5 If you don’t know how …my.cnf quickly for anything weird: [percona@db1 ~]$ grep -v ‘^#’ /etc/my.cnf | grep . My goal here is to look at the my.cnf…be.) Or maybe the client is doing queries like “… WHERE client IN (SELECT id FROM clients)” which is …
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… the client node. # yum -y install haproxy sysbench After installing everything, let’s configure PXC first. On the first node, my.cnf should…_xtrabackup ‘joiner’ ’10.195.206.117′ ” ‘/var/lib/mysql/’ ‘/etc/my.cnf‘ ’20758′ 2>sst.err’ 120619 13:20:19 [Note] WSREP…:21:19 [Note] /usr/sbin/mysqld: ready for connections. Version: ‘5.5.24-log’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… a micro instance, simply decrease the values in the /etc/my.cnf file if you really want to try micro instances.*EDIT…-8eb648e7 shard-query-innodb-demo-64bit x86_64 Percona Server 5.5.11 with XtraDB. Requires m1.large or larger. ami-f65ea19f….287,581.295,11.042,63.366,14.573 InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…for instance include –default-file=/etc/my.cnf (if this is where your my.cnf file is located) in order to… (check if you can login with your mysql client), you would execute whatever steps you think are…: handle_slave_sql (in /usr/local/percona/mysql-5.5.28/usr/sbin/mysqld) | | | ->10.10% (7,135,…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options… The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /tmp/… max_sort_length=2048 long-query-time=5 log-slow-queries=/apps/log/slow-query…
Comment: Why MySQL could be slow with large tables ?
November 14, 2008 By 141 Comments
…password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords…vars and restart server, my configs are not applied, defautl mysql applied, and my.cnf are not modified. Why?…Load avg: 0.81 (1 min) 0.68 (5 mins) 0.73 (15 mins) Real memory …
