…levers we can pull for server optimization. Schema and query optimization can give much greater improvements, for… you know the term “thin-slicing.” That describes an experienced consultant’s approach to the…virtually every query.) If it’s not possible to use a patched binary, we can use MySQL Proxy, …
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… schema and queries are described here Used hardware CentOS release…MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql…using index’ is very common optimization we use in our practice. READ_KEY_POINT_NO_DATA_LIMIT Query…
Post: Using Flexviews - part one, introduction to materialized views
March 23, 2011 By 3 Comments
…describing Flexviews. Update: This series has a part 2 and part 3. The output of any SQL query…output of a SQL statement. MySQL even includes a SQL statement… considered to be a performance optimization because: The contents of the…database Delta computation – How it uses those changes to compute the…
Post: Joining on range? Wrong!
May 17, 2010 By 10 Comments
…describe is likely to be around since the very beginning of MySQL, however unless you carefully analyse and profile your queries… A very inefficient approach! MySQL was unable to optimize those simple conditions to …const rows: 206494 Extra: Using where; Using index This query uses 7 bytes of `itm_prd…
Post: MySQL Workshops: Chicago & London this April
March 15, 2013 By Leave a Comment
…and replication. Optimize MySQL schema and indexes to support efficient queries. Instrument applications to measure performance. Use successful patterns behind MySQL applications, … counters exposed in MySQL‘s SHOW GLOBAL STATUS. Backup & restore MySQL and InnoDB data, and describe the advantages of …
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…Performance Optimization got a lot of comments …you also have MySQL needs – these include MySQL buffers – query cache, key_buffer, mysql threads, temporary…You may want to make MySQL to use Large Pages for allocating Innodb… things. P.S I only described Innodb Buffer Pool selection for dedicated…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…) 2 2-2 64 Optimal WT, RA PhysiclDev Type State Errors Vendor Model Size ========== …MySQL versions or settings. Moreover, I have been running these benchmarks for a customer so I just used…= 64M thread_cache_size = 32 query_cache_size = 0 tmp_…benchmark, I’ll just describe few less interesting numbers…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…: No PZ: Another possible area of optimization. I frequently see batch jobs killing …rows if they were not matched by query where clause when it was not… by using couple of MySQL Servers on single node. You can make them to use …. Can you describe a real-world use case where it would be useful to have …
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…query execution, normally hidden from everyone’s eyes. Currently it’s used by many DBAs and developers to help in optimizations… different ways, however I will be describing the method that is simple, non-…mysql-5.0.51a/ mysql-5.0.51a/bdb/ mysql-5.0.51a/bdb/Makefile.in mysql-5.0.51a/bdb/btree/ mysql…
Comment: MySQL Partitioning - can save you or kill you
July 2, 2012 By 45 Comments
…index use. The mysql 5.1 Manual Section 18.4 says –> This section discusses an optimization …using partition column and without it. The results were same.. Coming to the application, (I cannot describe…, using load infile. Query result ( during inserts 100 rows per sec) : Query 3 in 30 sec. Queries…
