Hi! I come from Viet Nam. Now i want to check capacity (free space & used space) of datafile on InnoDB (MySQL). How to command? I just research for MySQL, hope you help me. Big thanks!
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
…:16 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database… exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait… InnoDB: The….sock’ port: 3306 Source distribution Also, I don’t see how MySQL could be using any other conf file other than…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… why I decided to test it. For tests I use sysbench fileio, 16KiB block size (to match workload from InnoDB, as this is primary usage for me), and recently I switched to use async IO… I gather metrics every 10 sec to see how stable the performance is, and it really helps to observe some artifacts, as you…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
…, 16KiB block size (to match workload from InnoDB, as this is primary usage for me), and recently I switched to use async IO mode. There are two reasons for that. First, MySQL/InnoDB uses async writes, so… I gather metrics every 10 sec to see how stable the performance is, and it really helps to observe some artifacts, as you…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
… > 1000 FOR UPDATE twice, you expect to get the same value twice. To accomplish that, InnoDB locks all index records found by the… insertion of data to other sessions. How to troubleshoot gap locks? Is possible to detect those gap locks using SHOW ENGINE INNODB STATUS: —TRANSACTION 72C… a transaction, so there is no need to create locks to prevent that from happening. 2- innodb_locks_unsafe_for_binlog = 1. Disables…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
…hours for this statement to complete. Here is example how it can look: mysql> show processlist; …to let backup to proceed, but resolving server gridlock one way or another. If you’re just using Innodb…
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
… InnoDB patches have been merged Since Drizzle 7.0 (which was released last year), there have been over 3,500 commits to… Drizzle Launchpad download area. Please see the Drizzle manual on how to install Drizzle 7.1.33-stable from source tar package… how to install from the PPA are in the Drizzle manual. CentOS 6 packages are available from download.drizzle.org. Instructions on how to…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 26, 2012 By 20 Comments
… the innodb data from the backup where Innodb fails to recover should be passed to your support provider for investigation. It might be related to Innodb itself or how XFS plays…
Comment: InnoDB's gap locks
April 6, 2012 By 14 Comments
Miguel – Not to speak for Miguel, but I believe that what he means … converted to READ COMMITTED. I wrote up a demo of this over on DBA StackExchange: http://dba.stackexchange.com/questions/15854/innodb-row-locking-how-to-implement/15864#15864. I haven’t tested it with…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
March 29, 2012 By 28 Comments
… helpful article! It is just what I needed to convert a 330GB MyISAM database to InnoDB with reasonable effort. I have tested your… seems it doesn’t handle binary data correctly, you need to add these lines: if (length($line) > 1) { while (substr($line…), I added –show-warnings to the command line, because otherwise things may go wrong unnoticed (that’s how I discovered the mistake…
