]]>
]]>

PBXT Benchmarks

Nothing here really ATM

Comment from Paul on PBXT tuning:

[paul@tech1 mysql]$ cat test.cnf
[mysqld]
key_buffer_size=8M
max_allowed_packet=5M
max_connections=1536
query_cache_size=0
query_cache_type=0
read_buffer_size=1M
skip-locking
sort_buffer_size=2M
table_cache=4096
thread_cache=1024
transaction_isolation=REPEATABLE-READ
default_storage_engine=myisam

pbxt_index_cache_size=500MB
pbxt_record_cache_size=1GB
pbxt_checkpoint_frequency=1GB
pbxt_log_file_threshold=256MB
pbxt_data_file_grow_size=16MB
pbxt_row_file_grow_size=2MB
pbxt_log_buffer_size=256K
pbxt_log_cache_size=128MB
pbxt_transaction_buffer_size=1MB

pbxt_index_cache_size and pbxt_record_cache_size should be given all the available cache memory. Setting index cache to about 1/3 of record cache is a good starting point.

Adjusting this to 50% or higher can make sense when memory is low. The advantage of this is that it favors caching of the index which provide the largest speed boost.
 
benchmark/pbxt/start.txt · Last modified: 2011/07/17 21:05 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license:CC Attribution-Noncommercial-Share Alike 3.0 Unported
Contact Us 24 Hours A Day
SupportContact us 24×7
Emergency? Contact us for help now!
Sales North America(888) 316-9775 or
(208) 473-2904
Sales
Europe
+44-208-133-0309 (UK)
0-800-051-8984 (UK)
0-800-181-0665 (GER)
Training(855) 55TRAIN or
(925) 271-5054

 

Share This
]]> ]]>