… VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program where row-locks are used by one user to…
Comment: Learning about MySQL Table Fragmentation
May 18, 2012 By 19 Comments
… set files_per_table variable. i executed the following query to know the fragmentation SELECT TABLE_SCHEMA, TABLE_NAME, CONCAT(ROUND…_free / ( 1024 * 1024 ), 2), ‘MB’)FREE from information_schema.TABLES where TABLE_SCHEMA=’xyz’ and table_name=’abc’ and Data_free…_free / ( 1024 * 1024 ), 2), ‘MB’)FREE from information_schema.TABLES where TABLE_SCHEMA=’xyz’ and table_name=’abc’ and Data_free…
Comment: Testing Fusion-io ioDrive - now with driver 3.1
May 18, 2012 By 2 Comments
… more complex than that? I’m new to Fusion-IO and I am going to do some testing with a couple of…
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: Testing Fusion-io ioDrive2 Duo
May 12, 2012 By 12 Comments
Joseph, I do not have OCZ Z-Drive R4 on my hands, and I am not going to buy it myself, I am not interested in. I am going to wait on Intel 910.
Comment: InnoDB's gap locks
May 7, 2012 By 14 Comments
… Miguel ， I’ve tried your example “the affect gap locks to SELECT … FOR UPDATE ” on my server ,and my results are… sec) root@localhost:test 14:35:22>delete from t where i=25; Query OK, 1 row affected (0.00 sec…): Lock wait timeout exceeded; try restarting transaction Here I tried to insert a value out of [21,30],but it came…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
…. If you however need system to serve other users too you typically need to reduce concurrency to where it does not overload the system… would not use more than 4 parallel processes heavily writing to database. Introduce Throttling Sometimes even single process overloads system too… helps with monopolizing replication thread. For example if I need to delete old data instead of DELETE FROM TBL WHERE ts
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… works on my site on a Debian Squeeze system where I have to edit: /etc/mysql/my.cnf Also make sure that… sure what the MySQLDB performance cracks like Baron recommend you to be on the safe / perfect side. innodb_log_file_size… them). The end result was: I could only use mysqldump to import all the data into a clean/fresh innodb system…
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
May 1, 2012 By 10 Comments
… release, and noticed the configuration, but i did not understand where did all of the configuration go for example default_storage… in this field and being a startup company cannot afford to get paid support from percona, but at-least you can answer this one or provide a link to sample configuration. Your tool do not provide config for xtradb…
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.
