XF 1.2 Xenforo 1.2 problem

[Princ3]

I installed the 1.2 version on my server. Since then when I get almost 4.000 visitors online, I cannot access my sites anymore. Everything on the server is ok, I don't get any errors but somehow I can't access my websites. After 20 hours or more, they came back and when I get almost 4.000 visitors online, the same thing happens. My community software was from www.mybb.com but when I changed to xenforo those things started to happen. I dont know what to do. I really like the new software.

 

[shawn]

Did you have a previous version of xenforo installed, then upgraded to 1.2? Or did you migrate straight from mybb to xenforo 1.2?

Are you using innodb tables? Is your database server configured to use innodb tables?

 

[Jeremy]

Moved this from bugs. When you say you can't access your site, do you have any issues (ie, could not connect to database) or does it just never load?

 

[Princ3]

Did you have a previous version of xenforo installed, then upgraded to 1.2? Or did you migrate straight from mybb to xenforo 1.2?

Straight

Are you using innodb tables? Is your database server configured to use innodb tables?

Yes, I am. I don't know exactly. How could I check this but if that was the problem I should be able to access other websites in the same server.

Moved this from bugs. When you say you can't access your site, do you have any issues (ie, could not connect to database) or does it just never load?

Just never load... I can't even see what is the problem. It has something to do with too much connections I guess because when I get too much visitors this thing happens.

 

[Jeremy]

Is it happening now? What is your URL?

 

[Princ3]

Right now, it is ok. www.forumpiece.com

 

[shawn]

Yes, I am. I don't know exactly. How could I check this but if that was the problem I should be able to access other websites in the same server.

Not necessarily. If mysql is hung, it won't respond to queries from any of your other sites, either.

All I can tell you for certain is that our my.cnf file changed almost entirely when we moved from vb to xf to account for the change from primarily myisam tables to innodb, and I'm not doing anywhere near 4k concurrent users.

 

[MattW]

Is it a dedicated server, VPS or shared hosting?

 

[Princ3]

Not necessarily. If mysql is hung, it won't respond to queries from any of your other sites, either.

All I can tell you for certain is that our my.cnf file changed almost entirely when we moved from vb to xf to account for the change from primarily myisam tables to innodb, and I'm not doing anywhere near 4k concurrent users.

Humm it was myisam and I also changed to innodb. Can you help me sending me an example of your my.cnf? I would really appreciate!

Is it a dedicated server, VPS or shared hosting?

Dedicated server

 

[MattW]

and you can't access the server either?

 

[Princ3]

yes I can

 

[MattW]

So what does the server load look like when you have 4,000 visitors?

 

[Princ3]

humm i dont know how to see it on xenforo. I use directadmin and I dont know how to see it there either! I used to check it on Mybb admin cp
I will do it next time.
Weeks ago I change this /etc/httpd/conf/extra/httpd-mpm.conf and my server started to have less server load.

 

[Jeremy]

If you are running a UNIX based server you can SSH in and run top which shows you a lot of information.

 

[Princ3]

again, sites off

 

[Jeremy]

If you can access your server, what does running top return?

If you can access FTP, try globally turning off add-ons to see if you can access this (which would imply its an add-on issue).

 

[Princ3]

top - http://oi42.tinypic.com/a2vu3b.jpg
just added this on config.php:

$config['enableListeners'] = false;

nothing happened

 

[MattW]

if you have 4,000 people on your site, with a load of 0.00, nothing is happening. Is Apache still running?

can you run:

ps -ef | grep -i apache

I just get website not available when I try to visit your site.

 

[Princ3]

I don't know! That is the problem. Nobody is able to visit my site... I did what you told me to do and nothing happened!

 

[shawn]

I don't know! That is the problem. Nobody is able to visit my site... I did what you told me to do and nothing happened!

What do you mean "nothing" happened? If nothing else, it should return the "grep -i apache" process. What operating system are you running? Apache might be called httpd.

Try these:

service httpd status
service apache status
service mysqld status

ps ax | grep apache
ps ax | grep httpd
ps ax | grep mysqld

Etc... if you're not running apache and mysql, it would be helpful to know that, too.