I wrote about MySQL Error Messages before and as you might guess I’m not very happy with quality for error messages it… ask is what is error 17 ? Do to this you can run external utility perror: [pz@test ~]$ perror 17 OS error code 17: File exists It would be already a lot handy if one would walk through all error messages where error code is…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
… Query thread_id=3 exec_time=0 error_code=0 use test/*!*/; SET TIMESTAMP=1323814581/*!*/; insert … with an error. Example: mysql> CREATE FUNCTION this_year() RETURNS INT DETERMINISTIC RETURN YEAR(CURDATE()); mysql> insert …is fixed only in Percona server 5.5.17-22.1. AUTO INCREMENTAL VALUES In order …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql 3172 3137 78 Nov19 ? 1-11:17:30 /usr/libexec/mysqld –defaults…, and if the query fails, then you know from the error code that the server is dead. So a successful Ping is… errors about this.) There are a bunch of other things I’ll look at, including checking for default users in the mysql…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
…more recent MySQL and Percona Server versions. We now build against: MySQL 5.1.59, MySQL 5.5.17, …that MySQL datadir was empty before –copy-back was run. With this bug fix, innobackupex will now error…save-info. This bug fix simplifies the connection code so that such problems are harder to create…
Post: STOP: DELETE IGNORE on Tables with Foreign Keys Can Break Replication
February 2, 2012 By 1 Comment
… and 5.5, MySQL will stop deleting rows if it encounters constraint errors. To demonstrate on 5.5.17: I delete…master [localhost] {msandbox} (test) > SHOW WARNINGS \G *************************** 1. row *************************** Level: Error Code: 1451 Message: Cannot delete or update a parent row: …
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
… salaries on time!). mysql> delete from salaries where emp_no = 10001; Query OK, 17 rows affected (0.15 sec) mysql> drop table salaries; — Ooops! Query OK, 0 rows affected (0.49 sec) mysql> alter table…_log_pos 336797275 Query thread_id=47 exec_time=1 error_code=0 SET TIMESTAMP=1329980395/*!*/; DROP TABLE `salaries` /* generated by server…
Post: Maatkit Now Supports Memcached
July 24, 2009 By 9 Comments
… to that which would be displayed for MySQL queries. Commands are fingerprinted so that similar …4.71k # key print 1 TEST_KEY # 17% (114) Memc_error # 100% (657) Memc_get # Query_time distribution # …, or consider a different –report option In code: wget http://maatkit.googlecode.com/svn/trunk/…
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
… InfiniDB Operating Mode (infinidb_vtable_mode). mysql> show warnings; +——-+——+————————————————————+ | Level | Code | Message | +——-+——+————————————————————+ | Error | 9999 | Subselect in From clause is…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…requires some knowledge of source code – you only get file names…next section is about deadlock errors: ———————— LATEST DETECTED DEADLOCK ———————— 060717 4:16:48… InnoDB 442 mysql tables in use 1, locked 0 MySQL thread id… has 4091 buffer(s) 2208.17 hash searches/s, 175….
