…(about 23GB). So it makes sense to check if the dataset size makes any difference…threads = 8 innodb_io_capacity = 2000 max_connections=5000 table_open_cache=5000 query_… –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point…
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;
Post: Introducing the pmp-check-mysql-status Nagios Plugin
March 29, 2012 By 2 Comments
…you can use for fairly arbitrary checks of status counters and variables. This is the pmp-check-mysql-status plugin, which can perform…purposes: Check whether the Uptime variable is too small, indicating the server has been restarted Check whether Threads_connected is approaching max_connections, …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… pmp-check-mysql-status plugin to alert when the server’s Uptime variable is too small. The server is approaching max_connections. Overflowing… this error appropriately. The pmp-check-mysql-status plugin can be configured to alert when Threads_connected approaches max_connections too closely, which can…
Post: Checking for a live database connection considered harmful
May 5, 2010 By 38 Comments
…. If the connection is alive when checked, there’s no guarantee that it is still alive by the time connection.execute(sql) is…. Performance Overhead Checking whether the connection is active typically involves a call to the ‘ping’ or ‘statistics’ command at the MySQL protocol level…% of the server’s total query time. Eliminating the useless connection checks could have nearly halved the load on this database server…
Post: Debugging MySQL SSL problems
November 8, 2012 By Leave a Comment
… had my SSL files correctly) Checking grants Double-checking the my.cnf for misspellings Restarting mysql Checking file perms of the ssl… what I had been looking for: # mysql –ssl-ca=/data/mysql/etc/mysql/DigiCertCA.pem … mysql> … ————–Connection id: 101 Current database: Current user: …
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… or more likely you have listen queue overflow. You can check if it is the case by running netstat -s and… 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: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… [Note] /usr/sbin/mysqld: ready for connections. Version: ’5.5.24-log’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Percona XtraDB Cluster… CSV version is good for trending and alerting). Here MySQL is checked via HTTP checks. MySQL won’t serve these requests. As part of… able to use check MySQL via HTTP. The clustercheck script is a simple shell script, which accepts HTTP requests, and checks MySQL on incoming…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
…4/4) checking for file conflicts [########################################################] 100% (4/4) checking available disk space …Connect using the mysql client: [root@alarmpi ~]# /usr/bin/mysql Welcome to the MySQL monitor. Commands end with ; or \g. [...] mysql…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…, key_buffer_size etc, you have reasonable amount of connections but yet MySQL takes much more memory than you would expect, causing… >> ps.log sleep 60 done Check for Table Cache Related Allocations There are cases when MySQL will allocate a lot of memory… max_packet_size per connection) are all connection buffers and so if you close connection MySQL can clean them up. Killing connections (or stopping related…
