Results 1 to 12 of 12
Thread: Mysql Load Problem
-
09-18-2010, 08:57 AM #1Newbie
- 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.....
-
09-18-2010, 10:23 AM #2WHT 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
-
09-18-2010, 03:41 PM #3Web Hosting Guru
- Join Date
- Aug 2005
- Posts
- 281
Try use APC cache or memcache, it will increase server performance.
-
09-18-2010, 08:11 PM #4Newbie
- 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
-
09-18-2010, 08:14 PM #5Newbie
- Join Date
- Jun 2008
- Posts
- 10
-
09-19-2010, 06:52 PM #6Web Hosting Evangelist
- Join Date
- Jul 2005
- Posts
- 489
Try google search.
http://www.google.co.in/#hl=en&sourc...5c7405d4a7e2c8
-
09-19-2010, 07:01 PM #7Newbie
- Join Date
- Jun 2010
- Posts
- 10
-
09-19-2010, 07:40 PM #8Aspiring Evangelist
- Join Date
- Aug 2007
- Posts
- 352
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.
-
09-20-2010, 07:09 PM #9Newbie
- Join Date
- Jun 2008
- Posts
- 10
THANKS Guyz, i am very great full , i will update you on results
-
09-22-2010, 09:56 AM #10WHT Addict
- Join Date
- Oct 2006
- Location
- USA
- Posts
- 172
also for search you could use : sphinix ( going to improve IO/disk )
-
09-22-2010, 07:02 PM #11Web Hosting Master
- Join Date
- Mar 2009
- Posts
- 569
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.
-
09-23-2010, 10:57 AM #12Newbie
- Join Date
- Jun 2008
- Posts
- 10
Similar Threads
-
cpanel problem: cannot load mysql extension
By phyto in forum Dedicated ServerReplies: 0Last Post: 12-25-2004, 01:43 PM -
Mysql load data infile problem
By awsolutions in forum Programming DiscussionReplies: 7Last Post: 06-23-2004, 10:49 AM -
MySQL Load Problem (not enought)
By Studio64 in forum Hosting Security and TechnologyReplies: 1Last Post: 05-25-2004, 06:53 AM -
mysql problem ... server load 20-50 help!
By swijaya0101 in forum Dedicated ServerReplies: 9Last Post: 05-09-2004, 08:32 PM -
Load Data Infile Problem (MySQL)
By shaky21 in forum Hosting Security and TechnologyReplies: 1Last Post: 03-26-2004, 06:46 PM