vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Big Board Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=172)
-   -   mysqladmin variables HUGE numbers (https://vborg.vbsupport.ru/showthread.php?t=145228)

raywjohnson 04-19-2007 02:51 AM
mysqladmin variables HUGE numbers
 
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:

Code:
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


All times are GMT. The time now is 02:39 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00992 seconds
  • Memory Usage 1,711KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (1)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete