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: 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: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 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: 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…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… lot of information on the box’s hardware, including RAID controllers, installed memory, and so on in the boot output. In… –pid-file=/var/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql 3172 3137 78 Nov19 ? 1-11:17:30… errors about this.) There are a bunch of other things I’ll look at, including checking for default users in the mysql…
Post: Worse than DDOS
August 18, 2008 By 5 Comments
…. Implement proper error control In reality it took some time to find what was the issue because there was no error reporting for… transparently for you. They however do not give you good error control and timeout management compared to curl module. Use that when… is stuck. If it is somewhere in curl module (or mysql – waiting on long query to come back) – this is our…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… parse tree inside MySQL which of course depends on query size which is controlled by max_allowed_packet. However some MySQL optimizations such… connections. This can be avoided by having high max_connect_errors variables but this will obviously disable password brute force protection…
Comment: MySQL Stored Procedures problems and use practices
September 6, 2010 By 21 Comments
… to debug code in MySQL: 1. Control execution of stored code on the server (used in dbForge Studio for MySQL ) 2. Interpretation of…. The causes may be either an error in an external interpreter (errors during processing conditionals, errors during retrieving data during reading a cursor…
Post: How InnoDB handles REDO logging
February 3, 2011 By 18 Comments
… sectors. Percona Server with XtraDB allows you to control the transaction log record size, as better performance…all, your transaction will never complete. Both the MySQL configuration and hardware will affect the speed at…and then later rolled back do to an error or a specific request, as part of …
