hosted by liquidweb


Go Back   Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : Mysql Load Problem
Reply

Forum Jump

Mysql Load Problem

Reply Post New Thread In Programming Discussion Subscription
 
Send news tip View All Posts Thread Tools Search this Thread Display Modes
  #1  
Old 09-18-2010, 08:57 AM
SHAN9211 SHAN9211 is offline
Newbie
 
Join Date: Jun 2008
Posts: 10

Mysql Load Problem


Hello Sirs!

I am having problem in my mysql, last year i shifted my server and by mistake i dumped database 2 times, that time i didn't care much but now when i am having more then 70000 members , database crashes very often, and every time i have to restart server then repair database.... site works fine for 3 to 4 hours then suddenly mysql load goes to 20 , 40 and then site stops responding ,i did a top and it showed me that its that is causing the load but as being newbie i don't know how to check which table is causing and how to resolve, please help me,and i have vbulletin 3.8.5 installed with xbt tracker....

sorry for my bad English.....



Sponsored Links
  #2  
Old 09-18-2010, 10:23 AM
helpyoulinux helpyoulinux is offline
WHT Addict
 
Join Date: May 2008
Location: Sweden
Posts: 152
In the top, you will get the process id of the the mysql. From process id you can see the details of the db.

__________________
Linux, C, Perl, Bash, PHP
MySQL, PostgreSQL
Postfix, Qmail
Bind

  #3  
Old 09-18-2010, 03:41 PM
cedced cedced is offline
Web Hosting Guru
 
Join Date: Aug 2005
Posts: 280
Try use APC cache or memcache, it will increase server performance.

__________________
╠══ Cool Wallpapers ══╡
║►►► Optimize your website


Sponsored Links
  #4  
Old 09-18-2010, 08:11 PM
SHAN9211 SHAN9211 is offline
Newbie
 
Join Date: Jun 2008
Posts: 10
sir i am completely newbie for this can u please pass me any guide to install or to setup

APC cache or memcache

  #5  
Old 09-18-2010, 08:14 PM
SHAN9211 SHAN9211 is offline
Newbie
 
Join Date: Jun 2008
Posts: 10
Quote:
Originally Posted by helpyoulinux View Post
In the top, you will get the process id of the the mysql. From process id you can see the details of the db.
i do get the id of mysql but i dont know how to get to that table or coloumn with that id in order to delete that table or column can you please guide me?

and pass me ur email id....please

  #6  
Old 09-19-2010, 06:52 PM
LnxtecH LnxtecH is offline
Web Hosting Evangelist
 
Join Date: Jul 2005
Posts: 482
Quote:
Originally Posted by SHAN9211 View Post
sir i am completely newbie for this can u please pass me any guide to install or to setup

APC cache or memcache
Try google search.
http://www.google.co.in/#hl=en&sourc...5c7405d4a7e2c8

  #7  
Old 09-19-2010, 07:01 PM
c10k_Consulting c10k_Consulting is offline
Newbie
 
Join Date: Jun 2010
Posts: 10
Quote:
Originally Posted by SHAN9211 View Post
i do get the id of mysql but i dont know how to get to that table or coloumn with that id in order to delete that table or column can you please guide me?

and pass me ur email id....please
Type
Code:
SHOW FULL PROCESSLIST
When your having isues, it will give you a starting point.

  #8  
Old 09-19-2010, 07:40 PM
pubcrawler pubcrawler is offline
Aspiring Evangelist
 
Join Date: Aug 2007
Posts: 351
You need to turn on SLOW QUERY Logging and logging of queries not using indexes in my.cnf config file.

You likely need to optimize your queries and use query cache in MySQL. Proper indexes need put in place.

Test slow queries by prepending:
EXPLAIN (the query)

That will show you useful information on the query - which indexes (if any) are being used and help you to isolate some problems.

As for the restarts and corruption, I believe you are using MyISAM. Convert your tables to InnoDB and the corruption *SHOULD* go away.

When doing the repairs to tables you need to take down all front ends so you app isn't connecting to the database, otherwise this will create a big dogpile and cause more issues.

  #9  
Old 09-20-2010, 07:09 PM
SHAN9211 SHAN9211 is offline
Newbie
 
Join Date: Jun 2008
Posts: 10
THANKS Guyz, i am very great full , i will update you on results

  #10  
Old 09-22-2010, 09:56 AM
voidSecurity voidSecurity is offline
WHT Addict
 
Join Date: Oct 2006
Location: arizona/romania
Posts: 169
also for search you could use : sphinix ( going to improve IO/disk )

  #11  
Old 09-22-2010, 07:02 PM
Gary4gar Gary4gar is offline
Web Hosting Master
 
Join Date: Mar 2009
Posts: 568
If you are total new to Server World, then I suggest to get some help. Either ask some friend to do it or hire somebody to do it for you.

  #12  
Old 09-23-2010, 10:57 AM
SHAN9211 SHAN9211 is offline
Newbie
 
Join Date: Jun 2008
Posts: 10
Quote:
Originally Posted by Gary4gar View Post
If you are total new to Server World, then I suggest to get some help. Either ask some friend to do it or hire somebody to do it for you.
can anyone please pass me his online contact for help, i think i am unable to solve the problem, i would be very great full

Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
cpanel problem: cannot load mysql extension phyto Dedicated Server 0 12-25-2004 01:43 PM
Mysql load data infile problem awsolutions Programming Discussion 7 06-23-2004 10:49 AM
MySQL Load Problem (not enought) Studio64 Hosting Security and Technology 1 05-25-2004 06:53 AM
mysql problem ... server load 20-50 help! swijaya0101 Dedicated Server 9 05-09-2004 08:32 PM
Load Data Infile Problem (MySQL) shaky21 Hosting Security and Technology 1 03-26-2004 06:46 PM

Related posts from TheWhir.com
Title Type Date Posted
Google Releases Hosted Database Service Cloud SQL to General Availability Web Hosting News 2014-02-12 13:46:02
Google Cloud Provides Support For Native MySQL Connections Web Hosting News 2013-11-01 14:36:06
PHP And MySQL Scaling: Preparing A Startup For Growth Blog 2014-04-24 13:27:35
LeaseWeb Adds Load Balancing Service to Public Cloud Web Hosting News 2013-08-07 10:35:22
GoGrid Launches Dynamic Load Balancer Service Built for Cloud Web Hosting News 2013-01-29 10:07:53


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Postbit Selector

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 Off
HTML code is Off

Forum Jump
Login:
Log in with your username and password
Username:
Password:



Forgot Password?
Advertisement:
Web Hosting News:
WHT Membership
WHT Membership



 

X

Welcome to WebHostingTalk.com

Create your username to jump into the discussion!

WebHostingTalk.com is the largest, most influentual web hosting community on the Internet. Join us by filling in the form below.


(4 digit year)

Already a member?