… end causes “field list” operation to be blocked too, which among other tools used by mysql client, so you might get a feel you can’t connect to the database at all (use mysql -A in this case, to prevent it from getting field…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 31, 2012 By 20 Comments
hi, Peter i don’t know what the `mysql -A` it real meaning? what is the “getting field list from all tables”? can you explain it more detailed ?
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… MySQL server development: there is support for it in the MySQL Test Framework, DBQP, and the server source is properly annotated to get… (mysqld.cc:4504) This one shows that accesses to the fields of buf_pool->stat are unprotected. These are buffer pool… using MySQL 5.5 atomic operation primitives with proper memory barriers, so that there is no need for workarounds in mutex_get…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… MySQL 5.1 with no problems in most cases. When storage type changes, such as DECIMAL field got whole another meaning in MySQL 5.0 MySQL generally supports legacy storage format for a… id=5 you can probably go to the earliest MySQL version and still get same result. The more exotic or complicated functionality…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
…MySQL version in the Ubuntu repository by doing: root@hamysql:~# apt-get install mysql-server-5.1 The package install MySQL…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 27 Comments
… can see a huge tables with varchar/char fields, with small sets of possible values. These are “state… Two important notes about this table before we get to results – this is rather small table … while join performance degraded dramatically. Here is why: mysql> explain select SQL_NO_CACHE c.city from…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 3 Comments
…-physical-record.html You can also get the table row format from the Information Schema: mysql (information_schema) > SELECT ROW_FORMAT from… in our database: mysql (employees) > LOAD DATA INFILE ‘/root/recovery-tool/data/salaries.recovery’ REPLACE INTO TABLE `salaries` FIELDS TERMINATED BY ‘\t…
Post: Beware the Innodb Table Monitor
November 29, 2011 By 2 Comments
… the contents of the Data dictionary to the mysql error log, which looks something like this: =========================================== 090420 …FIELDS: REF_NAME ID ————————————– Basically you can see every table, every column, and every index in that table. Once you get…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… Â I am still getting a really solid # of hits in memcached, but the # of writes in MySQL coupled with the still… up a row in another table based on a text field ( called email address ). Seems simple enough right? My two tables… helpful. I am still getting a really solid # of hits in memcached, but the # of writes in MySQL coupled with the still…
Post: Why audit logging with triggers in MySQL is bad for replication
September 29, 2008 By 10 Comments
… set Value=6 Where Field_Id = 51; Commit; Transaction 1 commits last. Commit; Now when these statements get run on the slave…: *************************** 1. row *************************** Foo_History_Id: 1 Name: maxlength Value: 7 Field_Id: 51 *************************** 2. row *************************** Foo_History_Id: 2 Name: maxlength…
