… PhP/MySQL/Apache/InnoDB. Do you think you can show a program where row-locks are used by one user to lock records for…
Comment: InnoDB's gap locks
May 7, 2012 By 14 Comments
…, 0 rows affected (0.00 sec) root@localhost:test 14:35:54>insert into t values(29); ERROR 1205 (HY000): Lock wait… came out my insert still be blocked. The SHOW ENGINE INNODB STATUS information as follow: —TRANSACTION 0 27638, ACTIVE 1207 sec… inserting mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1216, 1 row lock(s) MySQL thread id 31929…
Comment: SHOW INNODB STATUS walk through
May 15, 2012 By 40 Comments
… monitores working – i created the different tables for the innodb (Standard, Lock,Tablespace,Table) and the server doesn’t report the data… described every 15 seconds instead it doesn’t create any row at all. How can that be, what have i overlooked…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
One of the most important features of InnoDB is the row level locking. This feature provides better concurrency under heavy write load but… those gap locks using SHOW ENGINE INNODB STATUS: —TRANSACTION 72C, ACTIVE 755 sec 4 lock struct(s), heap size 1248, 3 row lock(s), undo log entries 1 MySQL thread id 3, OS thread handle 0x7f84a78ba700, query id 163 localhost msandbox TABLE LOCK table…
Comment: InnoDB's gap locks
April 6, 2012 By 14 Comments
… over on DBA StackExchange: http://dba.stackexchange.com/questions/15854/innodb-row-locking-how-to-implement/15864#15864. I haven’t tested it…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… | +——-+——+———–+———-+———+——+————————-+—————————–+———–+—————+———–+ 3 rows in set (0.00 sec) As you can see FLUSH TABLES WITH READ LOCK … another. If you’re just using Innodb tables and you’re not actively …
Comment: Avoiding auto-increment holes on InnoDB with INSERT IGNORE
March 11, 2012 By 7 Comments
…/5.1/en/innodb-auto-increment-handling.html I have the same problem. 1. You have to add one row to your my.ini file. # =0 is traditional lock mode == > funcionality of auto_increment like… default value – consecutive lock mode # =2 is interleaved lock mode , i don’t investigate what it do innodb_autoinc_lock_mode=0 2. restart…
Comment: Should you move from MyISAM to Innodb ?
March 9, 2012 By 53 Comments
… on innodb though mainly because of row locking and no overhead as compare to MyIsam. I change 90% of my tables to innodb and… i use Innodb. Big table ie. users? comments? etc… i just compared MyIsam to Innodb while loading users from 145000 rows and found quite a significant speed gain from MyIsam. Will this be better once i tuned InnoDb settings? and…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… 1. row *************************** SESSION_ID: 7234 TABLE_SCHEMA: test TABLE_NAME: my ENGINE: InnoDB NAME: #sql516_1c42_2 TABLE_ROWS: 0 AVG_ROW_LENGTH: … cache 512619219 (509995888 + 2623331) File system 294352 (82672 + 211680) Lock system 318875832 (318747272 + 128560) Recovery system 0 (0 + 0) …
Post: Best kept MySQLDump Secret
March 23, 2012 By 11 Comments
… tables; +——————–+ | Tables_in_dumptest | +——————–+ | A | | B | | C | +——————–+ 3 rows in set (0.00 sec) mysql> select count…ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; — – Dumping data for table `C` — LOCK…
