… @ 2.10GHz, 48GB of RAM and SATA SSD: Kingston HyperX 3K 240 GB. Workload…2, command line to run: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table…= 10 table_open_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_…
Post: Finding out largest tables on MySQL Server
February 4, 2008 By 27 Comments
…tables on MySQL instance is no brainier in MySQL 5.0+ ….79G | 0.17 | +————————————-+——–+——–+——–+————+———+ 10 rows in set (2 min 29.19 sec) I… data and index size in GB so I can save on … operating system cache. I also use it to see which tables may…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…Mysql server for a client, upgrading their main database (from 16GB, 2 two-year old HT’ed XEONs to 32 GB,… while the bulk of the rest (9 GB) is used for the OS cache (yes I know, we are below… OPTIMIZE rebuilds the whole table, it may last way too long for your 150 GB table! If you have inserted in…
Comment: Multiple column index vs multiple indexes
August 25, 2008 By 13 Comments
…. On the other hand, I’ve got consistent results from 2 index table, surprisingly, much faster than your results. This is why… a 8 GB RAM computer dual core CPU. Tables are less than 1 GB in size. The index cache was set at 4 GB. Mysql version 5.0.67 ( i was doing testing for bug 29857). mysql> show index from t1000; +——-+————+———-+————–+————-+———–+————-+———-+——–+——+————+———+ | Table…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
…GB: Please let me know if we are having any wrong value or we can do some settings Here is mysql…table_cache = 3600 table_definition_cache = 4096 thread_cache_size = 16K wait_timeout = 120 connect_timeout = 60 tmp_table_size = 192M max_heap_table…
Comment: What to tune in MySQL Server after installation
October 8, 2012 By 118 Comments
… configuration: 2x Intel Xeon 2.53 GHz 64GB RAM 4x 80 GB SSD MLC CentOS 5 x 64 bits RAID-5 HW In this server is installing MySql…indexes [Cache] query_cache_type = 1 query_cache_size = 64M query_cache_limit = 64M thread_cache_size = 70 table_cache = 2048 table_open_cache = 512 …
Comment: What to tune in MySQL Server after installation
December 7, 2006 By 118 Comments
…GB ram All servers are on same gig network. All my tables are MyIsam. Following is out of mytop MySQL…table_cache = 812 sort_buffer_size = 1024M read_buffer_size = 512M myisam_sort_buffer_size = 1024M thread_cache = 16 query_cache… # Try number of CPU’s*2 for thread_concurrency thread_concurrency =…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…cache_size = 8 query_cache_size = 128M join_buffer_size = 8M long_query_time=300 key_buffer_size = 500M concurrent_insert=2…table=mysql.gsd_runs replicate-ignore-table=mysql.gsd_monitor ======== ==> max_heap_table…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
… Extra Large Instance 68.4 GB of memory 26 EC2 Compute…_flush_log_at_trx_commit = 2 innodb_flush_method = O_…innodb_file_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type …cache on write heavy workload. OK, so that was all about the configuration of the EC2 instance and MySQL…
Comment: Slow DROP TABLE
June 17, 2009 By 21 Comments
… 100% cached (both data and indexes), 16 – 20 GB in a few hundred MyISAM tables (out of 24 GB RAM …. 2) Most sorts are small or medium sized, we have max_heap_table_size=100M and tmp_table_size… dedicated to caching the db / indexes). I’d go spelunking, but have no experience with the mysql codebase …
