Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Big Board Discussions
mysqladmin variables HUGE numbers Details »»
mysqladmin variables HUGE numbers
Version: , by raywjohnson raywjohnson is offline
Developer Last Online: Jul 2023 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 04-19-2007 Last Update: Never Installs: 0
 
No support by the author.

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?

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

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 04:02 PM.


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.06467 seconds
  • Memory Usage 2,182KB
  • Queries Executed 14 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete