… was not repeatable although transaction isolation level of REPEATABLE-READ was used. This … | | sending cached result to clien | 0.000011 | | logging slow query | 0.000002 | | cleaning up | 0.000002 …; When using MySQL 5.1 the second CREATE would just fail immediately with the error “ERROR 1050 (…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
…a lot of harm due to the “error” part of “trial-and-error.” At Percona we have become skilled …you need. Finally, make sure that the script can log into MySQL (if necessary, put a password into .my.cnf,…it just shows you a few of the highest-level summary tidbits of information, and you often really …
Post: How InnoDB handles REDO logging
February 3, 2011 By 19 Comments
…log at all, your transaction will never complete. Both the MySQL configuration and hardware will affect the speed at which InnoDB can log… at session level. This allows you to risk durability by having the logging return … change may be logged and then later rolled back do to an error or a specific…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
…equation, of course, is the one in the error log after a crash: “It is possible that mysqld…control that or calculate it at a global level. But let’s keep going! Any stored code …* 100); Query OK, 0 rows affected (2.34 sec) mysql> select get_lock(@a, 1); +—————–+ | get_lock(@a, 1) | …
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
…START TRANSACTION; transaction2 > INSERT INTO t VALUES(26); ERROR 1205 (HY000): Lock wait timeout exceeded; …1248, 3 row lock(s), undo log entries 1 MySQL thread id 3, OS thread …mysql.com/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the default isolation level…
Post: Using MySQL Sandbox with Percona Server
February 16, 2013 By 3 Comments
….5 \ –sandbox_port=5529 \ –no_ver_after_name \ –my_clause=log-error=msandbox.err … .. sandbox server started Your sandbox server was installed… different port to it, for example: root@smt2:~/sandboxes# low_level_make_sandbox –basedir=/tmp/ps5.5.29 –sandbox_directory=msb… –no_ver_aft er_name –my_clause=log-error=msandbox.err >>/tmp <<5.5>> The MySQL Sandbox, version 3.0.30 (C) 2006…
Post: On Good Instrumentation
May 31, 2010 By 1 Comment
… – for example in MySQL Query Log. What is important is however to be able to connect the data from these logs – glue them… all requests and put it in the logs with request of the lower levels. With mySQL the simple way to do it is…’d like to know if it was hit, miss or error. The way I use it may be as follows. I…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…Temperature 34C, isSOHGood= VirtualDev Size RAID Level Disks SpnDpth Stripe Status Cache ========== ========= ========== ===== ======= ====== ======= … different MySQL configurations, I didn’t try out different MySQL versions… = 3306 back_log = 50 max_connections = 2500 max_connect_errors = 10 table…
Post: STOP: DELETE IGNORE on Tables with Foreign Keys Can Break Replication
February 2, 2012 By 1 Comment
… master [localhost] {msandbox} (test) > SHOW WARNINGS \G *************************** 1. row *************************** Level: Error Code: 1451 Message: Cannot delete or update a … use ROW* based replication. When using the latter, MySQL will log separate statements for each row that is deleted – …
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…however should have been implemented outside of MySQL Storage Engine level for MySQL – reading rows in their physical …own tablespace and its own set of logs. With typical for MySQL use of Databases just as …Record has changed since last read in table ‘t’” error message. If you find Falcon or Innodb …
