=)
Here we go:
Variable_name Value
innodb_adaptive_hash_index ON
innodb_additional_mem_pool_size 1048576
innodb_autoextend_increment 8
innodb_autoinc_lock_mode 1
innodb_buffer_pool_size 536870912
innodb_checksums ON
innodb_commit_concurrency 0
innodb_concurrency_tickets 500
innodb_data_file_path ibdata1:10M:autoextend
innodb_data_home_dir
innodb_doublewrite ON
innodb_fast_shutdown 1
innodb_file_io_threads 4
innodb_file_per_table OFF
innodb_flush_log_at_trx_commit 2
innodb_flush_method O_DIRECT
innodb_force_recovery 0
innodb_lock_wait_timeout 50
innodb_locks_unsafe_for_binlog OFF
innodb_log_buffer_size 4194304
innodb_log_file_size 5242880
innodb_log_files_in_group 2
innodb_log_group_home_dir ./
innodb_max_dirty_pages_pct 90
innodb_max_purge_lag 0
innodb_mirrored_log_groups 1
innodb_open_files 300
innodb_rollback_on_timeout OFF
innodb_stats_method nulls_equal
innodb_stats_on_metadata ON
innodb_support_xa ON
innodb_sync_spin_loops 20
innodb_table_locks ON
innodb_thread_concurrency 8
innodb_thread_sleep_delay 10000
innodb_use_legacy_cardinality_algorithm ON
I did some tuning for the mysql configuration. Now it looks like the file below. There is perhaps some benefit, but to be honest benchmarking this is a pain since results vary greatly and precision is unexistent with manually monitoring query time.
query_cache_size=32M
query_cache_limit=2M
join_buffer_size=256K
thread_cache_size=4
table_cache=4096
innodb_buffer_pool_size=512M
innodb_log_buffer_size=4M
innodb_flush_log_at_trx_commit=2
innodb_thread_concurrency=8
innodb_flush_method=O_DIRECT
key_buffer_size=10M
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
skip-name-resolve
Ill see what some additiona memory will do. Our service provider however is very expensive, 12€/gb/mo is quite expensive in my opinion. Well, ill give it a try and see how 2 or 4 gb will work.
The problem with setting up an other machine is that i dont really have an other machine to experiment with, unless we talk about a completely different windows based desktop at home. I guess ill consult my more *nix oriented friends for some help in testing this. Inside out would be ideal, as that is how the query is actually thought out when it was written.