…=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on…) port = 3306 back_log = 50 max_connections = 2000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache = 2048 max… = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related options are…
Comment: Percona Server 5.5.30 with TokuDB for MySQL
April 29, 2013 By 26 Comments
Mark, There is no many steps if you are on the good platform (CentOS or Fedora). I do scripts/mysql_install_db –datadir=/data/mysql bin/mysqld –datadir=/data/mysql and it is all good. connect from mysql client and check SHOW ENGINES;
Comment: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
April 17, 2013 By 12 Comments
… logout from server, connect ssh to server and restart: $ sudo service mysql2 restart [linko@g4 ~]$ ps -ax | grep mysql 35328 pts/1…=/usr –datadir=/var/lib/mysql2 –plugin-dir=/usr/lib64/mysql/plugin –user=mysql –log-error=/var/log/mysqld2.log –open-files-limit…/lib/mysql2/g4.dmz.local.pid –socket=/var/lib/mysql2/mysql.sock –port=3307 $ sudo cat /proc/35967/limits Limit Soft…
Comment: Fun with the MySQL pager command
May 1, 2013 By 6 Comments
… also counting the header lines. I modified it as follows: mysql> pager grep -v ‘\-\+\-’ | grep -v ” Id[ |]*User ” | awk -F ‘|’ ‘{print… ‘|’ ‘{print $6}’ | sort | uniq -c | sort -r’ mysql> show processlist; 5 Sleep 2 Connect 1 Query 8 rows in set (0.00…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… are _no_ parallel queries (within a single connection) anywhere in any ‘free’ variant of MySQL. PARTITIONs are scanned one at a time… PARTITIONing. I go into more details (and code) here: http://mysql.rjweb.org/doc.php/partitionmaint The third use case for…
Comment: Percona Server 5.5.30 with TokuDB for MySQL
April 25, 2013 By 26 Comments
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: Percona team at MySQL Connect today
September 29, 2012 By 1 Comment
Attending MySQL Connect ? Do not miss our talks! Peter Zaitsev is doing “Optimizing MySQL Configuration” talk at 2:30 PM in Golden Gate 4 room Vadim Tkachenko is talking about “MySQL and Solid-State Drives: Usage and Tuning” at 4:00 PM in the same room. See you around !
Post: MySQL Connection Timeouts
April 19, 2011 By 4 Comments
… busy MySQL server you will see sporadic connection timeouts, such as Can’t connect to MySQL server on ‘mydb’ (110). If you have connects timed… into how MySQL accepts connection. There is single main thread which is accepting connections coming to LISTEN sockets. Once there is connection coming it…
Post: Configuring MySQL For High Number of Connections per Second
January 6, 2012 By 23 Comments
… new connections to MySQL per second during peak times. This is a high number by any account. When a new connection to MySQL is made, it can go into the back_log, which effectively serves as a queue for new connections on operating system size to allow MySQL to handle spikes. Although MySQL connections are quite fast compared to…
Post: Debugging MySQL SSL problems
November 8, 2012 By Leave a Comment
…: mysql –ssl-ca=/etc/mysql/ssl/ca-cert.pem However in my case, I immediately got the dreaded: ERROR 2026 (HY000): SSL connection… got what I had been looking for: # mysql –ssl-ca=/data/mysql/etc/mysql/DigiCertCA.pem … mysql> … ————–Connection id: 101 Current database: Current user: root…
