… that FTWRL hasn’t closed a open table yet, hence it must wait until all other threads have closed the table in question…
Post: Percona Live MySQL Conference & Expo Was A Great Event
April 17, 2012 By 2 Comments
… call for papers for Percona Live New York is now open and you can submit your proposal by visiting the website… been invited to post their slides!] I’d like to close with a final thanks to everyone who attended and/or…
Comment: InnoDB's gap locks
April 13, 2012 By 15 Comments
… can modify it (READ COMMITED). I open a new transaction again on the session 2 without closing the first one: session2> select…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… to keep open file descriptor when table is open – open table is purely logical state and appropriate .ibd file may be open or closed. Furthermore… open files was, which is not surprising as logical operation of opening file is rather fast on local file system – one can open/close file hundreds of thousands times per second. To verify this I tried doing “open table” test for only…
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
…(32, “”…, 10) = 10 <0.000011> [pid 19876] close(32) = 0 <0.000012> [pid 19876] open(“./db/t2.frm”, O_RDONLY) = 32 <0...(32, ""..., 10) = 10 <0.000012> [pid 19876] close(32) = 0 <0.000012> [pid 19876] open(“./db/t3.frm”, O_RDONLY) = 32 <0...(32, ""..., 10) = 10 <0.000011> [pid 19876] close(32) = 0 <0.000011> [pid 19876] open(“./db/t4.frm”, O_RDONLY) = 32 <0…
Post: Opening Tables scalability
November 21, 2006 By 27 Comments
… has global table cache mutex (LOCK_open) which is held for all open table operation so table opens are serialized. Do not think… also take few IO operations to open and could take quite a while to close if there were unflushed key blocks and we have no idea what other storage engines may do to perform table open…
Post: Open Development vs Making a Big Splash
May 21, 2009 By 28 Comments
… of true community Open Source development – you’ve got to give up on making a big splash. Traditional close source company often… let community play with it and complain. This is true Open Source development and it takes guts. I should praise Drizzle…. Though I think Google do not position themselves as doing Open Source development but rather being kind enough to publicly share…
Post: Friday challange: linking with GPL code
May 8, 2009 By 20 Comments
… open / closed source storage engines MySQL world. So problem is: Let’s keep MySQL aside for simplicity and imagine we have fully open… all fine. Now imagine one provides library libquickcompress, which is closed sourced, available only in binary formats .so and .la, but…
Comment: Opening Tables scalability
December 11, 2011 By 27 Comments
… WP multisite with about 200k tables and as tables in open_table cache increase the execution time of the query increase… is always 400 querys running and most of them in opening/closing state. If I restart the process it works like a…
Post: Percona Live MySQL Conference and Expo opens Call for Papers
September 15, 2011 By 1 Comment
… for the Percona Live MySQL Conference and Expo is finally open! We had a little delay while we set up the… consideration the short delay we are going to extend the close date to December 5th, 2011. Simply go to our website…
