MySQL crashes

THS · 2012-03-27 12:17:45

My box is going down about every few hours due to traffic. When we get about 100 concurrent users MySQL can no longer connect. Apache is fine. The box has 2 GB of RAM. I have run far more intensive sites with less of a box without issue. I have tried every possible setting in caching. Are there any recommendations on what we can do? The interim fix was to add more RAM.

Eri · 2012-03-27 21:26:38

remove embed code and replace it with this (dose not support porhub embed only)
http://forum.adultscriptpro.com/viewtop … 7025#p7025

ful2fun.com · 2012-03-27 21:41:47

Then I cant use It As My Site Have 50% To 60% pornhub content..

ful2fun.com
livesexpirates.com

symtab · 2012-03-28 05:53:28

You cannot have 100 concurent mysql users with that amount of traffic. You could try to remove a few queries that run every time someone connects to the site. The ban query from library/framework/bootstrap.php the users online query from index.php. Also remove the query that inserts in the video_history table from modules/video/components/view.php

Removing the embed code will free up data, however its not index data, nor is the data used to search when queries are executed.

You can setup mysql slow query log and see which queries are slow. Also from the mysql console run: show processlist when you have many users.

ful2fun.com · 2012-03-28 06:08:39

I Have Seen Some Were Or Listen About it People Using Multiple MySQl For Single Site Like For Video One MYSQl And For Views For One MYSQL Like That It Is Interconnecting MYSQL. Will It BE A Good Option.

ful2fun.com
livesexpirates.com

THS · 2012-03-28 13:18:18

symtab wrote:

You cannot have 100 concurent mysql users with that amount of traffic. You could try to remove a few queries that run every time someone connects to the site. The ban query from library/framework/bootstrap.php the users online query from index.php. Also remove the query that inserts in the video_history table from modules/video/components/view.php
Removing the embed code will free up data, however its not index data, nor is the data used to search when queries are executed.
You can setup mysql slow query log and see which queries are slow. Also from the mysql console run: show processlist when you have many users.

I do not have a bootstrap.php file in that location. Could it be somewhere else or what query is it and I can search all the files?

Thanks!!

symtab · 2012-03-28 14:22:50

Ahh sorry...its libraries/framework/bootstrap.php

THS · 2012-03-28 18:09:49

I should have clarified, I do not have a bootstrap.php file at all in that folder. I did find it in the libraries folder though. Will this cause an issue or is there something wrong with my setup?

symtab · 2012-03-28 18:16:47

Erm...do you have libraries/bootstrap.php?

THS · 2012-03-28 21:10:19

I do have the file -> /libraries/bootstrap.php : but not the -> /libraries/framework/bootstrap.php. I assume you meant the first one in your posts and not that I needed the file in the framework folder. If I do, I assume I just copy it.

symtab · 2012-03-29 07:07:20

Yes. I made mistake. The correct file is libraries/bootstrap.php

Adult Script Pro Community Forums

#1 2012-03-27 12:17:45

MySQL crashes

#2 2012-03-27 21:26:38

Re: MySQL crashes

#3 2012-03-27 21:41:47

Re: MySQL crashes

#4 2012-03-28 05:53:28

Re: MySQL crashes

#5 2012-03-28 06:08:39

Re: MySQL crashes

#6 2012-03-28 13:18:18

Re: MySQL crashes

#7 2012-03-28 14:22:50

Re: MySQL crashes

#8 2012-03-28 18:09:49

Re: MySQL crashes

#9 2012-03-28 18:16:47

Re: MySQL crashes

#10 2012-03-28 21:10:19

Re: MySQL crashes

#11 2012-03-29 07:07:20

Re: MySQL crashes

Board footer