…would read in MySQL manual as far as I understand it: From http://dev.mysql.com/doc/refman/5.0/en/memory…1.2358, 2007-01-03 14:45:26+03:00, ted@ted.mysql.internal +7 -0 BUG #4291: max_heap_…books and articles on the web – you will have users expecting old behavior for years. The size restriction of…
Post: PBXT in tpcc-like benchmark
June 2, 2010 By 10 Comments
Finally I was able to run PBXT 1.0.11 pre-GA in tpcc-like workload, apparently there was … server), and compared 1 and 16 users in MySQL-5.1.46/PBXT and Percona Server / XtraDB – 5.1.45-rel10.2. As workload is… there are graphs for 1 user: and 16 users: Interesting to see that in case with 1 user the maximal throughput in PBXT…
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 13 Comments
…MySQL / InnoDB performs here. For benchmark I took MySQL 5.1.42 with built-in InnoDB, InnoDB-plugin 1.0.6, and XtraDB 1.0…CPU usage and disk utilization. Disk throughput: CPU (user) usage: Even with improvements, XtraDB performs less… FusionIO can do much more) and with 45-50% of idle CPU. I assume we…
Post: Recovery after DROP & CREATE
August 22, 2012 By 1 Comment
… them with -D option. When a user immediately creates the same table InnoDB …mysql> CREATE TABLE actor ( -> actor_id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, -> first_name VARCHAR(45) NOT NULL, -> last_name VARCHAR(45… ulint, 1-5 bytes) field data We know that sakila/actor is field #0, its …
Post: How to know if you're updating Slave you should not ?
April 11, 2010 By 8 Comments
…but it is not set always and also users with SUPER privilege bypass it. Looking into …directly we can do: [root@centos data]# mysqlbinlog mysql-bin.000002 | grep “server id 101″ | grep Query …0 error_code=0 #100411 19:24:45 server id 101 end_log_pos 1007 Query thread_id=5 exec_time=0 error_code=0…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… takes 0.5 seconds…user and system if you want) and when there come various wait times – mysql…0.53530183347988 | | 05 | 3720 | 13.025273085185 | 0.61126549080115 | | 06 | 1606 | 60.624889697559 | 0.89123114911947 | | 07 | 2699 | 38.821067012253 | 0.90885394709571 | | 08 | 2419 | 45.388828675971 | 0…
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
…user requests, you are usually interested in queries that are consuming most MySQL…45 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0…
Post: Trying Archive Storage Engine
November 12, 2006 By 7 Comments
…45 Check_time: NULL Collation: utf8_general_ci Checksum: NULL Create_options: Comment: 1 row in set (0… 1 mysql mysql 19 Nov 12 11:31 requests_061111.ARM -rw-rw—- 1 mysql mysql … is heavily redundant (urls, referers, user agents etc) To check if … on the table changed from 5 min to about 4 minutes, …
Comment: ORDER BY ... LIMIT Performance Optimization
February 17, 2011 By 100 Comments
… my head around this whole MySQL optimization stuff. Anyways, I get the… `state` = 45 AND `city` = 35859 AND `visible` = 1 ORDER BY `price` ASC LIMIT 0, 10 Now…bathrooms` = 3, etc. And who knows what the user is going to enter in. Then…price` DESC, it can take 4-5 seconds, maybe more… I guess …
