… could track versions for tables (increment each time table is updated) and check whenever version matches for …speed for 1Gb networks. Plus if we can get MySQL protocol to support such light compression in …can do it automatically, preventing some queries with SQL_CACHE_TTL from expiring as well as …
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… of goodies does Helgrind find on MySQL server. Let’s take a recent 5.1 bzr version (pre-5.1.61) and…*, TABLE_LIST*, Item*) (sql_show.cc:5522) ==9090== by 0x74E4DF: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:6238…_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5179) ==9090== by 0x6435EA: mysql_execute_command(THD*) (sql_parse.cc:2309) ==9090== by 0x782C6D…
Post: MySQL Configuration Wizard Updated
January 26, 2012 By 5 Comments
…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 Leave a 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 12 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 69 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…
