… for MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable… has been improved. (Laurynas Biveinis) Bugs Fixed: Due to parse error in the percona-server.spec Percona Server rpm packages couldn… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… for MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable… has been improved. (Laurynas Biveinis) Bugs Fixed: Due to parse error in the percona-server.spec Percona Server rpm packages couldn… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…
Post: MySQL Error control changes
February 19, 2007 By 4 Comments
In MySQL 5.0 mainly error control was improved, such as strict mode was added to change famous MySQL behavior of cutting too large… often monitors MySQL is up and running and will not query all tables are accessible not catching such errors. If MySQL is started with Innodb tables disabled accesses to Innodb tables will simply result in errors. The other…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
… an example: Enable the log: general_log_file = /var/log/mysql/mysql.log general_log = 1 User correctly authenticated: 121227 8:31… value greater than 1: log_warnings = 2 Then check the error log: 121227 8:44:21 [Warning] Access denied for user… can be very useful if MySQL is running on a multi-tenant environment or we need to control how resources are used…
Post: How to check MySQL Config files
February 12, 2008 By 7 Comments
… sometime had a situation when they would do changes in MySQL config file without restarting server (may be matching SET GLOBAL… restart or recovering from MySQL Server crash. In any case it is quite nasty. Unlike Apache MySQL service control script does not have “configtest” option so there is no straight way to check MySQL config file for errors. However…
Post: MySQL Session variables and Hints
December 28, 2006 By 2 Comments
… ways to find tune execution of particular query. First is MySQL Hints, such as SQL_BIG_RESULT, STRAIGHT_JOIN, FORCE INDEX… created dynamically some complex way) – adding extra MySQL calls with possibly their own error control is more complicated. Many people even dislike doing…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… contact with one another and then both try to take control of shared resources or provide simultaneously the cluster service. On…’); ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction percona1 mysql> insert into percona values (0,’percona1′,’peter’); ERROR…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… ############################# sda | [deadline] 128 # RAID Controller ############################################ Controller | LSI Logic MegaRAID …PhysiclDev Type State Errors Vendor Model Size ========== ==== ======= ====== ======= ============…MySQL configurations, I didn’t try out different MySQL…
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
… they will! Replication checksums on replicas Checksums on slaves are controlled by the slave_sql_verify_checksum variable. Let’s …checksum option of mysqlbinlog: # mysqlbinlog –verify-binlog-checksum mysql_sandbox18676-relay-bin.000002 [...] ERROR: Error in Log_event::read_log_event(): ‘Event crc…
Post: Add an option to Fail on Innodb Initialize failure, Please ?
October 11, 2007 By 9 Comments
… experience. It is worth to note MySQL 5.0 introduces STRICT option which will makes error control more strict, what is often expected… unless you look in MySQL server Error Logs but the error message accessing Innodb tables is also very obfuscated: error : Incorrect information in file…
