…Features: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov…the PAM Authentication Plugin couldn’t be loaded with Perl and Python clients when … options, all secondary key definitions would be lost. Bug fixed #989253 (Alexey Kopytov). Warning …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov)…the PAM Authentication Plugin couldn’t be loaded with Perl and Python clients when … options, all secondary key definitions would be lost. Bug fixed #989253 (Alexey Kopytov). Warning about…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…_system#” \G *************************** 1. row *************************** USER: #mysql_system# TOTAL_CONNECTIONS: 1 CONCURRENT_CONNECTIONS: 0 CONNECTED_TIME: 446 BUSY_TIME: 74 CPU_TIME: 0 BYTES… DENIED_CONNECTIONS: 1 LOST_CONNECTIONS: 0 ACCESS_DENIED: 0 EMPTY_QUERIES: 0 1 row in set (0.00 sec) In this case CONNECTED_TIME… least 3 during the peak load and 5 during the normal load. This applies to normal operational load – if you push heavy ALTER…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
… will have to deal with very large files on high loaded servers. general_log variable is dynamic so a solution could… TOTAL_SSL_CONNECTIONS: 0 Here we can see that root has done 25 total connections. Two denied connections (bad password) and 16 lost connections (not closed properly). Apart from that information we get the connection time, bytes…
Post: Checking for a live database connection considered harmful
May 5, 2010 By 38 Comments
…’s total query time. Eliminating the useless connection checks could have nearly halved the load on this database server. That’s not unusual! When the application’s queries are long, the extra query is lost…_devices That’s right, 73% of the server’s load is consumed by checking to see if the connection is still alive 
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… I am getting: mysql> check table test; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> check table test; +———–+——-+———-+———-+ | Table… later. Another alternative is to dump table with MySQLDump and load it back. It is all pretty much the same stuff…
Post: MySQL Connection Timeouts
April 19, 2011 By 4 Comments
… of connection attempts to time out… when as the load growths it may become a lot more frequent. If you time the connect you will often see connection times are… thread stalls somewhere longer than, some SYN packets may be lost. I would suggest sizing your tcp_max_syn_backlog and…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
… using persistent connection technique to avoid creating new connections for every request so it just recycle old connections. The application starts to load data into the database with “LOAD DATA…:35 .. drwx—— 2 root root 16K ago 2 12:36 lost+found Nothing. No files on the partition but it is…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… need to answer a question how much load a given system can handle when load is low and we might not be… from User Statistics *************************** 1. row *************************** USER:user TOTAL_CONNECTIONS: 1 CONCURRENT_CONNECTIONS: 0 CONNECTED_TIME: 800 BUSY_TIME: 775 CPU_TIME: 49 BYTES… OTHER_COMMANDS: 0 COMMIT_TRANSACTIONS: 181243 ROLLBACK_TRANSACTIONS: 0 DENIED_CONNECTIONS: 0 LOST_CONNECTIONS: 0 ACCESS_DENIED: 0 EMPTY_QUERIES: 13099 In this…
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 8 Comments
… SAN to another, something went wrong and they lost the ibdata1 file, where all the table meta-…to get a decent disk space and good internet connectivity, I fired up an Ubuntu 10.04 EC2 instance… credentials to upload their files. Then, I proceed. Loading the schema root@domU:/mnt/tables# perl -p -i…
