… >= MySQL-4…memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql…mysql> insert ignore into test2 select * from test limit 300; ERROR 2013 (HY000): Lost connection to MySQL…max PK which could be recovered and try some higher values mysql> select max(id) from test2; +———+ | max…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… averages a nearly 6x (max over 10x) improvement over…memory. A SATA 7200rpm RAID10 battery backed RAID array was used as the underlying storage for the virtual machines. Baseline: The MySQL… servers). Due to ICE limitations, the data was split…, Carrier,dest.CityName ORDER BY 4 DESC; Conclusion The …
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… tables in MyISAM format in “mysql” database. Plus HEAP/MEMORY tables are used for temporary tables …_boolean_syntax, ft_max_word_len, ft_min_word_len, ft_query_expansion_limit, ft_stopword_…4-32MB to be used for temporary tables. key_cache_age_threshold, key_cache_block_size, key_cache_division_limit…
Post: Performance Schema tables stats
May 2, 2011 By 2 Comments
… mainly in memory workload and against single …0 AVG_TIMER_DELETE: 0 MAX_TIMER_DELETE: 0 *************************** 3. row…mysql> select * from file_summary_by_instance order by COUNT_READ desc limit…_OF_BYTES_WRITE: 332300288 *************************** 4. row *************************** FILE_NAME: /…
Post: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
…MySQL handles traffic and MySQL stuck. As you see stalls are very severe. There are 4 mins periods, when MySQL…adoption of MySQL 5.5 and servers with big memory configuration …usually takes 75% mark as limit for “sync” stage ( 3800M * 0.75 … the Oracle/MySQL engineers is to decrease “innodb_max_dirty_…
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
…limitations of current systems. This raises valid question how fast can MySQL…MEMORY DEFAULT CHARSET=latin1 mysql> show table status like “m4″ \G *************************** 1. row *************************** Name: m4 Engine: MEMORY…
Post: Announcing Percona Server for MySQL version 5.1.67-14.4
March 8, 2013 By Leave a Comment
…). Upstream bug #67983 was causing a memory leak on a filtered slave. Bug … line option innodb_changed_pages_limit. MySQL option handling would then shadow …renaming the innodb_changed_pages_limit option to innodb_max_changed_pages. Bug fixed #…Percona Server 5.1.67-14.4 are available in our online …
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…/mysqltest/mysql- –with-falcon mysqld startup params: Falcon: libexec/mysqld –no-defaults –user=root –falcon_min_record_memory=1G –falcon_max_record_memory=2GB –falcon_page_cache_size=1500M –max-connections=1500 –table-cache=512 –net… but with LIMIT. Again the LIMIT is bad for Falcon. InnoDB is better than MyISAM by 87% in case with 4 threads but…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
… 400% available, MPM and dual core reports 4 processors). We have 6Gb of physical memory available but since we run on 32…/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries.log max_connections=650 open_files_limit=6144 max…=/var/log/mysql innodb_log_arch_dir=/var/log/mysql innodb_table_locks=0 innodb_buffer_pool_size=1800M # USE ALL MEMORY AVAILABLE…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…=on’ join_cache_level=4 join_buffer_size=32M join_buffer_space_limit=32M Note that MariaDB includes ….40GHz. The amount of memory installed is 8G and the MySQL datadir is on a 4-disk Software RAID5 volume, … that it always uses the max values join algorithm. If join_cache_level=4 it always uses BNLH (…
