…: if it is not up-to-date, data may be lost or replication may be broken. Scenario #3: The master has…. Conclusion Reconfiguring replication when using GTIDs is usually straightforward: just connect the slave to the correct master with master_auto_position…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
….2 — New Features: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for… upstream bug #62578 which caused MySQL client to abort the connections on terminal resize. Bug fixed #925343 (Sergei Glushchenko). Percona Server… and –no-data options, all secondary key definitions would be lost. Bug fixed #989253 (Alexey Kopytov). Warning about the Percona Toolkit…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… Launchpad. New Features: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for… and –no-data options, all secondary key definitions would be lost. Bug fixed #989253 (Alexey Kopytov). Warning about the Percona Toolkit…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
… 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: Google's user_statistics V2 port and changes
September 12, 2008 By 9 Comments
… DENIED_CONNECTIONS: 0 LOST_CONNECTIONS: 0 ACCESS_DENIED: 0 EMPTY_QUERIES: 506 *************************** 2. row *************************** CLIENT: 192.168.10.161 TOTAL_CONNECTIONS: 41539 CONCURRENT_CONNECTIONS: 0 CONNECTED… OTHER_COMMANDS: 124497 COMMIT_TRANSACTIONS: 0 ROLLBACK_TRANSACTIONS: 0 DENIED_CONNECTIONS: 0 LOST_CONNECTIONS: 0 ACCESS_DENIED: 0 EMPTY_QUERIES: 70748 and INDEX…
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… test2 select * from test where id>250; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> insert ignore into test2…
Post: MySQL Connection Timeouts
April 19, 2011 By 4 Comments
… packet is lost and will send the new one anyway. There is something else. If you’re creating 1000 of connections a… and tearing down connections. Consider using persistent connections or connection pool at least for applications which are responsible for most of connections being created.
Post: Checking for a live database connection considered harmful
May 5, 2010 By 38 Comments
… pseudo-code: function query_database(connection, sql) if !connection.is_alive() and !connection.reconnect() then throw exception end return connection.execute(sql) end Many… the application’s queries are long, the extra query is lost in the noise. But high-traffic apps put tremendous effort…
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…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
… application connects to the database using persistent connection technique to avoid creating new connections for every request so it just recycle old connections. The…:35 .. drwx—— 2 root root 16K ago 2 12:36 lost+found Nothing. No files on the partition but it is… with the name ML*. Here is the problem. Until the connection is closed those files won’t disappear, even after committing…
