…by highly trained mysql certified dba’s. So what’s changed in the new version of the Configuration… the account and profile features. Now you get a homepage with your configuration files, so …tools that people have requested or suggested: a SQL formatter, a visual EXPLAIN tool, a configuration advisor…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… are used on SQL layer and apply to all storage engines. Lets start with a bit of history. When MySQL was just… disk tables and HEAP for in memory tables. So first MySQL versions did not bother naming variables with storage engines prefix. This…. Some SQL level items as Query Cache also could use this feature. low_priority_updates If enabled selects will get higher priority…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… transactions which require a lot of complications and performance overhead. MySQL has to do several fsync() calls per transaction commit to… lets think what we could have if we have a version of MySQL Server which drops everything but Innodb Storage engine (it… tune Optimizer to handle Innodb specifics well. We could get rid of SQL level table locks and using Innodb internal data dictionary…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
… of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in previous versions… quite handy I also should tell log table implementation in MySQL is well though of in regards to avoiding trouble. For… placeholders as this would allow to aggregate log entirely in SQL finding most frequent slow query types or queries which load…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…MySQL 5.0.45, 5.0.51a, 5.0.54a and 5.0.56. I assume you have some MySQL version…sql/sql_cache.cc patching file sql/sql_class.cc patching file sql/sql_class.h patching file sql/sql_parse.cc patching file sql/sql_select.cc patching file sql/sql… This parameter allows you to get the full sessions logged …
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…. mysql> select flexviews.get_sql( -> flexviews.get_id(‘demo’,'dashboard_customer_sales’)) -> as ‘SQL‘ \G *************************** 1. row *************************** SQL: …incrementally refreshable version does not take long to refresh: mysql> call flexviews.refresh( -> flexviews.get_id(‘demo’, ->…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** 1. row *************************** Name: ontime_fact Engine: InnoDB Version:…< queries.sql | tee raw |./pivot_results & [1] 12359 $ tail -f ./raw — Q1 … At the end, you will get a result…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
… result set but MySQL has no way to identify which one of them would so it gets rid of all…set query_cache_type to “DEMAND” and use only SQL_CACHE hint for queries which you want to have…often too bad. With other caches you may implement version based or timeout based invalidation which can offer much…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… you know, MySQL doesn’t do intra-query parallelization, so ETL jobs written to rely on SQL tend to get really bogged down… we’re doing here starts to look like a hillbilly version of Infobright, which I’ll talk about later. Alternately, you… know you’ll get there, it can change the lifecycle of your application in advance. What about partitioning in MySQL 5.1…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
…systems here – typically you get charged more for Advanced features but with MySQL everything is free out …much all of MySQL features in version 4.0 becomes a book shelf for new MySQL versions. I can’t… do not think we need yet another SQL database because SQL language itself is way to complicated and…
