I am considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program where row-locks are used by one user to lock records for edit/update, so the transaction is not… do this for us. I am sure there are many in this situation.
Comment: Testing Fusion-io ioDrive - now with driver 3.1
May 18, 2012 By 2 Comments
… new to Fusion-IO and I am going to do some testing with a couple of MySQL servers with ioDrive2 cards (two in…
Comment: Learning about MySQL Table Fragmentation
May 18, 2012 By 19 Comments
… innodb tables in my production database and i have set files_per_table variable. i executed the following query to know the… table could not be defragmented. is there any other way to defragment innodb tables? thanks Kuldeep
Comment: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
May 18, 2012 By 21 Comments
Is there any option to save the result of show slave status in a table like insert into temp show slave status;
Comment: Benchmarking single-row insert performance on Amazon EC2
May 17, 2012 By 11 Comments
Aaron, No particular reasons, it doesn’t matter if you have 4 1G or 2 2GB log files, as they are all concatenated together by InnoDB and written to in a circular fashion.
Comment: Percona Server 5.5.23-25.3 released!
May 17, 2012 By 2 Comments
@ James Ubuntu Precise (12.04 LTS) will be officially supported with the next Percona Server releases. Percona Server 5.5.24-26.0 is currently scheduled for release in the first week of June.
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
… 0.6 ms ( for Intel 520 – 0.69 ms). To better understand patterns in the read synchronous case, let me unfold results and show them in timeline (from 0 to 1800 sec): I am not sure how to… individuals patterns and different handling of write and read IO cases. Follow @VadimTk !…
Comment: Moving Subtrees in Closure Table Hierarchies
May 2, 2012 By 7 Comments
… using the closure table hierarchy to store regions in a database using MySQL and I’m wondering how can I create a unordered… and can be more or less in the future. How can reordered the receive data correctly to do so ? I saw the article… any exemple in one of them) so maybe a query to reorder datas and then put it in an array or structure to loop over…
Comment: What to tune in MySQL Server after installation
April 28, 2012 By 116 Comments
…queries with while loop in my application. I request to all please help me to resolve the issue. I shall be thankful to you. ….connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:579) at java.sql.DriverManager.getConnection(DriverManager.java:243) …
Comment: Load management Techniques for MySQL
May 10, 2012 By 2 Comments
… using a dedicated slave is to write all batch jobs to use Gearman MySQL UDF interface to apply update transactions to the master (but having… batch job processing and use Gearman Workers to apply updates to this dedicated master, using pacing in the Gearman Workers based on load statistics of the other dbs in the cluster. Maybe…
