vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   MySQL Server crashing more and more often as site grows (https://vborg.vbsupport.ru/showthread.php?t=313707)

findingpeace 08-14-2014 08:56 PM
MySQL Server crashing more and more often as site grows
 
On pretty much a biweekly basis now, our vB4 site is crashing and I get a million "vBulletin Database Error!" emails. Most of the time, the database gets corrupted and needs to be repaired. I'm providing my server & forum stats below, in hopes that someone can recommend some tweaks for me to stop all of this downtime?


FORUM INFO
vBulletin Version: 4.2.2 PL1
Total Size: Threads 17,291 Posts 247,138 Members 7,945
Posts per day: 800
Google Analytics Daily Visitors: 5,000
Google Analytics Daily Page Views: 30,000
Resource Intensive Mods: DBTech vBNotifications (15 second refresh)


SERVER INFO
KnownHost VPS SSD-3
3584MB Guaranteed RAM
50GB RAID10 SSD Storage
3x Priority 24 CPU Cores
4500GB Premium Bandwidth

MySQL conf file:
Code:
thread_cache_size=4
table_cache=512
local-infile=0
innodb_file_per_table=1
query_cache_limit=1M
max_connections=500
key_buffer_size=16M
join_buffer_size=1M
query_cache_type=1
query_cache_size=32M
max_tmp_tables=1
default-storage-engine=MyISAM
open_files_limit=4974
max_allowed_packet=268435456
innodb_use_native_aio=0
innodb=on
innodb_buffer_pool_size=134217728

People automatically say "raise the refresh rate of vBNotifications!" but this really should not be a problem. Our site, even at peak hours, runs at only 1-4 CPU load average (10-20% total), and 1GB memory free.

The site just randomly craps out and crashes. Nothing to do with unusually high load.

Any thoughts?
Thanks!

ForceHSS 08-14-2014 08:58 PM
Have you talked to your host yet about this as they might be able to fix the problem

findingpeace 08-14-2014 09:00 PM
Quote:
Originally Posted by ForceHSS (Post 2511319)
Have you talked to your host yet about this as they might be able to fix the problem
Yep, they blamed it on the site :D

ForceHSS 08-14-2014 09:05 PM
Do you have any server error logs from your host and did your host even tell you what was causing it as many hosts always blame it on the software not themselves

findingpeace 08-14-2014 09:13 PM
Quote:
Originally Posted by ForceHSS (Post 2511322)
Do you have any server error logs from your host and did your host even tell you what was causing it as many hosts always blame it on the software not themselves
They said it was due to a spike in memory usage. Not totally sure what most of this means:

The first OOM occurrence today was at 'Aug 14 10:26:18'

--
Aug 14 10:26:18 host kernel: [8070457.454566] Out of memory in UB 11679: OOM killed process 5283 (mysqld) score 0 vm:522564kB, rss:269476kB, swap:0kB

The first occurrence of the database being corrupt was at '140814 14:47:39'

--
140814 14:47:39 [ERROR] /usr/sbin/mysqld: Incorrect key file for table './mysite/vbhumanverify.MYI'; try to repair it

The daily process log in WHM -> Server Status -> Daily Process Log, shows apache (the webserver) which runs as the user 'nobody' using the most RAM (44.45%).

This further points to the servers web activity which is the most likely source of the memory being consumed.

If you continue to experience out of memory issues, I would recommend upgrading your VPS package to allow for the RAM your processes require.

ForceHSS 08-14-2014 09:20 PM
You will need to get your host to fix these problems and get them to give you more memory. I am sure there are others on here that can give you more detail info on these problems

Zachery 08-14-2014 09:21 PM
Should really go post on .com for a server optimization.


All times are GMT. The time now is 06:08 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.01013 seconds
  • Memory Usage 1,727KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)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