… to PhP/MySQL/Apache/InnoDB. Do you think you can show a program where row-locks are used by one user to lock…
Comment: SHOW INNODB STATUS walk through
May 15, 2012 By 40 Comments
… Peter, I have trouble getting the monitores working – i created the different tables for the innodb (Standard, Lock,Tablespace,Table) and the…
Comment: Load management Techniques for MySQL
May 11, 2012 By 3 Comments
… about select sorted results from a big mysql tabble, myISAM, with about 2 Milion registers , so , what i can do , to get…
Post: New distribution of random generator for sysbench - Zipf
May 9, 2012 By 3 Comments
… simple: for a table with 1 mln rows, each row gets equal amount of hits. This barely reflects real system, it…^1.1) = 39 times. Obviously with θ=0 we are getting uniform distribution – each row is accessed equal times ( for row… times. There are histograms on how many times each row selected for different θ: 0.5, 0.9, 1.1: The…
Comment: InnoDB's gap locks
May 7, 2012 By 15 Comments
Hi Miguel ， I’ve tried your example “the affect gap locks to SELECT … FOR UPDATE ” on my server ,and my results are… affected (0.00 sec) root@localhost:test 14:35:29>select * from t; +——+ | i | +——+ | 21 | | 30 | | 26 | +——+ 3 rows in set… mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1216, 1 row lock(s) MySQL thread id 31929…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times. Investigating them we find out what the cause is some batch jobs, reports and other non response time critical activities are overloading the system causing user experience to …
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
… deck, is now available. You can watch the recording and get the slides here. I got a lot of questions, and… all the locks required in the beginning to prevent dead locks? So you would get a lock wait instead of a dead lock. No, that…
Comment: Moving Subtrees in Closure Table Hierarchies
May 2, 2012 By 7 Comments
… because you’re “walking the path”. I’m using MySQL, PHP or Coldfusion (I have to do it in both languages… and then put it in an array or structure to loop over… Thanks, Annie.
Comment: What to tune in MySQL Server after installation
April 28, 2012 By 116 Comments
… application of attendance system in Java and MySQL. When I get the attendance register of five employees it is working fine… is given below. Because there are several queries with while loop in my application. I request to all please help me….myStringGet(jdbcConnection.java:258) at biopayroll.rep_emp_attendance_register.get_gh_holiday(rep_emp_attendance_register.java:693) at biopayroll…
Comment: Learning about MySQL Table Fragmentation
May 18, 2012 By 19 Comments
… variable. i executed the following query to know the fragmentation SELECT TABLE_SCHEMA, TABLE_NAME, CONCAT(ROUND(data_length / ( 1024 * 1024… I executed alter table abc engine=innodb and re-executed SELECT TABLE_SCHEMA, TABLE_NAME, CONCAT(ROUND(data_length / ( 1024 * 1024…
