…query as Q{FLIGHT_NUMBER}.{QUERY_NUMBER}. In general, each flight examines different time periods or different regions. The flights represent the type… datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock …stats_persistent innodb_stats_auto_update=off [mysqld_safe] log-…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…query_cache_type=OFF performance_schema=0 warmup To warmup server and load data and indices to the buffer pool we use following queries…–mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql….index-updates=0 –oltp-non-index-updates=0 run POINT_SELECT + UPDATE…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… which should produce updates in-place (I will use INSERT .. ON DUPLICATE KEY UPDATE statements for…Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for SSD innodb_flush_…= 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 #default_table_type = InnoDB thread…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… of the view are updated. The two methods are complete refresh and incremental refresh. Â The view type/refresh method are interchangeable… for querying: mysql> call flexviews.enable( -> flexviews.get_id(‘demo’,'dashboard_customer_sales’)); Query OK, 0 rows affected (41 min 52.04 sec) Data…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
…query-digest is a great way to deal with it. Note you need not only to check the types and frequencies of queries… be in the data which is being accessed by the queries or query execution plans…. which queries mysql. I’ve seen monitoring updates which would add excessively expensive and frequent query…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
…MySQL 5.0 to MySQL 5.5 should be rather safe from data standpoint. There are still possibilities for sorting order and data type…you’re storing multi language data. Q: What to do if Query Execution Plan changes … to former execution plan either by updating statistics (ANALYZE TABLE) or disabling some …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…type_conversionsblogpercona.commanual Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow_query…updatable…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…queries to use the most aggregated data possible to save work. Avoid operations that update huge chunks of aggregated data…your aggregate tables to avoid joins. Watch Data Types Does your ad ID look like “…box than MySQL is, especially for more complex queries. Percona is not tied to MySQL, although …
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…query, and if you can form a SELECT query that returns the “new” data (for example, WHERE updated_at …type that supports direct row-by-row updates. But you would still have to update the RT index as data… the Windows partition, and one for the MySQL data partition. I performed all the tests on this…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… but until recently this type of software was not available for MySQL. Change Data Capture can be used…MySQL slave which has log_slave_updates=1 and binlog_format=row to process SBR changes from a MySQL…: 0 And delete data in a second transaction: mysql> delete from test.demo where c1=1; Query OK, …
