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.