raywjohnson
04-19-2007, 02:51 AM
Please disregard, I found the correct place to post this question: http://www.vbulletin.com/forum/forumdisplay.php?f=14
Greetings!
For some months I have been trying to get a server (only running vBulletin) to stop crashing and it is almost under control (fixing many settings in my.cnf and httpd.conf as well as installing Sphinx Search sure helped!). After many weeks of "research" on Apache and MySQL I am down to this last anomaly:
clipped from: mysqladmin variables
| max_allowed_packet | 8387584
| max_binlog_cache_size | 18446744073709551615
| max_binlog_size | 1073741824
| max_connect_errors | 32
| max_connections | 1024
| max_delayed_threads | 20
| max_error_count | 64
| max_heap_table_size | 268434432
| max_insert_delayed_threads | 20
| max_join_size | 18446744073709551615
| max_length_for_sort_data | 1024
| max_prepared_stmt_count | 16382
| max_relay_log_size | 0
| max_seeks_for_key | 18446744073709551615
| max_sort_length | 1024
| max_tmp_tables | 32
| max_user_connections | 1024
| max_write_lock_count | 18446744073709551615
| myisam_data_pointer_size | 4
| myisam_max_extra_sort_file_size | 2147483648
| myisam_max_sort_file_size | 9223372036854775807
| myisam_recover_options | OFF
| myisam_repair_threads | 1
| myisam_sort_buffer_size | 67108864
The numbers seem WAY to large. Even with 4GB of RAM I am sure these numbers are not right.
The MySQL site states that the default for max_binlog_cache_size is 4GB. Should I be setting these directly in my.cnf? :confused:
Any insight is greatly appreciated.
--RayJ
Please disregard, I found the correct place to post this question: http://www.vbulletin.com/forum/forumdisplay.php?f=14
Greetings!
For some months I have been trying to get a server (only running vBulletin) to stop crashing and it is almost under control (fixing many settings in my.cnf and httpd.conf as well as installing Sphinx Search sure helped!). After many weeks of "research" on Apache and MySQL I am down to this last anomaly:
clipped from: mysqladmin variables
| max_allowed_packet | 8387584
| max_binlog_cache_size | 18446744073709551615
| max_binlog_size | 1073741824
| max_connect_errors | 32
| max_connections | 1024
| max_delayed_threads | 20
| max_error_count | 64
| max_heap_table_size | 268434432
| max_insert_delayed_threads | 20
| max_join_size | 18446744073709551615
| max_length_for_sort_data | 1024
| max_prepared_stmt_count | 16382
| max_relay_log_size | 0
| max_seeks_for_key | 18446744073709551615
| max_sort_length | 1024
| max_tmp_tables | 32
| max_user_connections | 1024
| max_write_lock_count | 18446744073709551615
| myisam_data_pointer_size | 4
| myisam_max_extra_sort_file_size | 2147483648
| myisam_max_sort_file_size | 9223372036854775807
| myisam_recover_options | OFF
| myisam_repair_threads | 1
| myisam_sort_buffer_size | 67108864
The numbers seem WAY to large. Even with 4GB of RAM I am sure these numbers are not right.
The MySQL site states that the default for max_binlog_cache_size is 4GB. Should I be setting these directly in my.cnf? :confused:
Any insight is greatly appreciated.
--RayJ
Please disregard, I found the correct place to post this question: http://www.vbulletin.com/forum/forumdisplay.php?f=14