MYSQL Is Crashing

ful2fun.com · 2012-04-12 19:48:50

Hello Everybody,

My MYSQL Is 170Mb And It Is Crashing Every Minute. I Noticed That My Site Have No User Visits I Thought Its Ok Its Normal Some Time But When I Checked My Site Not Working Because Of Crashing Of Video MYSQL And Then I Repaired IT Crashed Again With Video History.What Should I To Stop Happening This And Loose My Money And Visitors.

ful2fun.com
livesexpirates.com

THS · 2012-04-12 20:30:15

Mine was a ram issue. My DB is over 400 MB and the box has 3GB ram. I have had over 100 users at one time without issue.

ionut · 2012-04-12 21:09:11

can you be more specific like posting the .err log from mysql? a crash is a crash, a corruption is a corruption. we need to know exactly

Last edited by ionut (2012-04-12 21:09:51)

symtab · 2012-04-13 05:50:34

The mysql database size can be reduced stubstantially if you dont want statistics. In 1.0 you have the option to keep statistics (for video views, photo views, adv clicks...) or not.

ful2fun.com · 2012-04-18 06:22:39

symtab wrote:

The mysql database size can be reduced stubstantially if you dont want statistics. In 1.0 you have the option to keep statistics (for video views, photo views, adv clicks...) or not.

Site Stats Does Not matter For Me But It Should Show Views To Users And Its Not Crashed Like That Way. It Showing That Table Is In Use But Actually It Got Crashed. So What The Reason It Crashed Basically i Want To Know It Showing That Time This Table Is In Use But Site Was Not Accessible Due To Database Error.

ful2fun.com
livesexpirates.com

symtab · 2012-04-18 06:28:48

There can be many reasons for a database table to become corrupt. From database design to hard drive problems to network problems.

ful2fun.com · 2012-04-18 07:33:04

I Tried To See It When I Optimized Through Phpmyadmin It Shows It Got Corrupted And In Use And Then I Repair It It Get Corrected Again. So We Should Find Why Its Happening We Do not get Any Error Msg Also through VPS Also So Its Something With Script And We Should Try to Add Some Function Which Can Inform us That Our Site Is Down Due To Some Reason And So We Can Check It What Is The Problem.

ful2fun.com
livesexpirates.com

symtab · 2012-04-18 09:01:36

It is not easy to find why the database is crashing, there are servers where the database tables never crash and there are servers where it crashes. Usually the video_history table crashes, because this table is very used and a lot of dynamic data is stored, however this is reduced in 1.0 so this shouldnt happen anymore.

ful2fun.com · 2012-04-18 09:14:43

Ok Then I Wait for It And Till then I Repair If It happens Again........

ful2fun.com
livesexpirates.com

mmpo · 2012-10-12 03:22:05

i have the same problem

DuttyRock · 2012-10-12 04:39:23

Mines crash when visitors reach close to 245... the site stop loading but i can access root so i reboot. Why does it crash when it's only 245 user online? i have 8GB memory.

symtab · 2012-10-12 06:20:34

Disable Views statistics in Admin -> Video -> Config -> Advanced.

DuttyRock · 2012-10-12 06:50:04

symtab wrote:

Disable Views statistics in Admin -> Video -> Config -> Advanced.

Track views was already set to "no".

symtab · 2012-10-12 10:04:43

Then no idea. It works for people with 500-1000 visitors online at the same time. Maybe some setting is not correct on your server.

DuttyRock · 2012-10-12 17:35:20

Yeah, ima have to look around for a pro to optimize my server.

symtab · 2012-10-12 17:46:51

Yes. Its the right decission. Hire someone that knows what he's doing.

Mitomind · 2012-10-12 18:26:50

Make sure you create a my.cnf file for mysql. In the my.cnf file you can increase / decrease various options for mysql. The default values for mysql are low - my opinion. You might be running into the max number of connections for mysql. So, you might need to increase that number.

In the php.ini you might want to set mysql.allow_persistent = on.

I posted a thread on adding a my.cnf in one of these forums.

Though, I've had to stop developing ASP for the moment, to work on another script I'm developing, I've switched over to all INNODB. I'm using the newest version of mysql 5.6.7 rc1 and everything is running great.

One important item I would like to note: Those of you running cPanel - make sure you are using Host Access Control. I had a hacker into my server in about a month. If you aren't securing your server then there might be other processes going on that will stop the server when it's under a heavy load.

If anyone needs help optimizing their server, just let me know and I can take a look.

symtab · 2012-10-12 21:32:24

I've also played with InnoDB, however there is no MATCH AGAINST. Do you know any solutions for that (we use sphinx, but not everyone can use sphinx (on shared hosting for example)).

Mitomind · 2012-10-12 21:34:14

symtab wrote:

I've also played with InnoDB, however there is no MATCH AGAINST. Do you know any solutions for that (we use sphinx, but not everyone can use sphinx (on shared hosting for example)).

FULLTEXT is available in INNODB as of 5.6... I'm using it in my script. Using mysql 5.6.7 rc-1 => not a single problem.

DuttyRock · 2012-10-13 01:10:53

I sent you an e-mail.

Last edited by DuttyRock (2012-10-13 01:17:57)

symtab · 2012-10-13 06:46:47

We might switch then also, although a combination of both InnoDB and MyISM would be ideal. I'll have to do some more research and testing.

Mitomind · 2012-10-13 15:52:02

symtab wrote:

We might switch then also, although a combination of both InnoDB and MyISM would be ideal. I'll have to do some more research and testing.

You have some time. 5.6 hasn't been released yet, but you can download it and install it to test things out.

Adult Script Pro Community Forums

#1 2012-04-12 19:48:50

MYSQL Is Crashing

#2 2012-04-12 20:30:15

Re: MYSQL Is Crashing

#3 2012-04-12 21:09:11

Re: MYSQL Is Crashing

#4 2012-04-13 05:50:34

Re: MYSQL Is Crashing

#5 2012-04-18 06:22:39

Re: MYSQL Is Crashing

#6 2012-04-18 06:28:48

Re: MYSQL Is Crashing

#7 2012-04-18 07:33:04

Re: MYSQL Is Crashing

#8 2012-04-18 09:01:36

Re: MYSQL Is Crashing

#9 2012-04-18 09:14:43

Re: MYSQL Is Crashing

#10 2012-10-12 03:22:05

Re: MYSQL Is Crashing

#11 2012-10-12 04:39:23

Re: MYSQL Is Crashing

#12 2012-10-12 06:20:34

Re: MYSQL Is Crashing

#13 2012-10-12 06:50:04

Re: MYSQL Is Crashing

#14 2012-10-12 10:04:43

Re: MYSQL Is Crashing

#15 2012-10-12 17:35:20

Re: MYSQL Is Crashing

#16 2012-10-12 17:46:51

Re: MYSQL Is Crashing

#17 2012-10-12 18:26:50

Re: MYSQL Is Crashing

#18 2012-10-12 21:32:24

Re: MYSQL Is Crashing

#19 2012-10-12 21:34:14

Re: MYSQL Is Crashing

#20 2012-10-13 01:10:53

Re: MYSQL Is Crashing

#21 2012-10-13 06:46:47

Re: MYSQL Is Crashing

#22 2012-10-13 15:52:02

Re: MYSQL Is Crashing

Board footer