vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   database error many messages,needed help. (realy need help) (https://vborg.vbsupport.ru/showthread.php?t=182628)

Dismounted 06-20-2008 10:14 AM

Please stop posting the same error over and over again - WE GET THE POINT. Furthermore, please read replies posted.

geevest.com 06-20-2008 03:24 PM

im very sorry bout this sir,but i dont know what should i do to make my forum normal again.
until now my host support never solved my problem.im stressfull about this.

Videx 06-21-2008 12:49 AM

It sounds like your host is offering a lot of help, but the problem appears to be in your software. Maybe a corrupt modification.

You can try disabling all your mods and adding them back one by one.

But, like Dismounted just said, there's no point in asking for help here if you're going to ignore the replies. You've been given three suggestions now and you need to try all of them and report back.

If you're not familiar with vbulletin I believe paid help is available somewhere around here.

geevest.com 06-21-2008 04:55 AM

okay no problem,i can pay for this but it must make my vbulletin normal again and not have an issue like this.
but my support host say i must upgrade the RAM.
before this my ram is 2GB.i take dedicated server.

--------------- Added [DATE]1214028670[/DATE] at [TIME]1214028670[/TIME] ---------------

in my plugin/product i just install simple mod :
Cyb - Advanced Forum Statistics
Cyb - Login To User Account
elmati - ADS inside postbit
Enhanced Image Captcha
Force Users to Read a Thread : Disable
Full Quick Reply
Invitation System
Members Who Registered Today
nCode Image Resizer
Personal Notepad
Post Thank You Hack
Quick Register
Tag Cloud - Forum Home
Usergroup Legend - J2Gaming.com
vB Ad Management
vB Ad Management English language
vB.Sponsors
vbBux / vbPlaza : Disable
vBCode table
Watermark Attachments
Welcome Headers

Dismounted 06-21-2008 06:02 AM

Again, please read replies and run the top command.

geevest.com 06-21-2008 07:31 AM

okay,my support say :

Quote:

Well the reason I ask is because there is a set number of mysql connections
that can happen at once, when it hits this limit it can appear that the mysql
server is down because you can not make a connection to mysql.

Dismounted 06-21-2008 09:02 AM

Please post my.cnf from /etc.

geevest.com 06-21-2008 07:31 PM

Okay this is my.cnf :

[mysqld]
max_connections = 650
safe-show-database
skip-locking
key_buffer = 128M
max_allowed_packet = 1M
table_cache = 256
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 64M
thread_concurrency = 8
wait_timeout = 30

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

log-slow-queries = /var/log/mysql-slow.log
long_query_time = 3

Dismounted 06-22-2008 06:55 AM

Try increasing max_connections.

geevest.com 06-22-2008 07:22 AM

how i can set for max_connection?
do u have suggestion sir?

--------------- Added [DATE]1214151094[/DATE] at [TIME]1214151094[/TIME] ---------------

btw my support say :

Quote:

Hello,

The settings you set it back to (650 for max_connections) will need at the
least 4 gigs of ram, you have 2 currently. If you insist on these settings you
will need to upgrade
Quote:

I am confused, I actually lowered max_connections yesterday, so far everything
looks stable still. If this is set to high it will when it gets busy go beyond
what is possible. This is when your site goes down, over and over again. Since
I made these changes have you had problems?
now im using dedicated server for 2GB ram.
but my host told me to upgrade my ram in to 4GB ram.
but the problem is that my members was online each day it is just for 5k uniq visitors.
is 2gb is not enough?


All times are GMT. The time now is 04: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.01623 seconds
  • Memory Usage 1,740KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete