Connection timeout

[ASTRAPI]

Hello

My forum is very slow and i did a check for d0s and locking tables on the sql but nothing all are normal also not many questions on the db and i think maybe i didn't configure correctly the Apache as i get also connection timeout :(

It seems that is trying to compress everything and then display them and that delay a lot... :(

As after a few seconds of a blank page and loading all are coming ready.

I use from acp the gzip option.

Any ideas?

Thank you

[ASTRAPI]

I notice that on my firefox when is loading it says down on the left connectig to mydomain.com for many seconds and then starts to load all text and images if that helps...

[Gary.]

Going from your previous thread, You said you had 2000 connections so if your MySql is set to 250 connections or so them you will get time outs here and there, Its just the matter of fine tuning and nothing major but can be a headache for the non experienced.

To be honest with you here its probably something or nothing, It can be easily fixed within a hour or two, say 30 mins just checking logs and see whats actually going on, Once this has been done then its just the matter of optimizing the server based on its current connections / scripts and memory usuage.

Mysql is not really a problem, Very easy to do but what most people do is search for my.cnf and then copy it, This will not do your server any good in any way, Wrong patchs and wrong limits can easily slow your mysql down or even due to bad limits may cause it to consume more than its actually capable of.

[ASTRAPI]

Sql slow log sample (i was change the db name and user for security reasons) :

DELETE FROM ibf_sessions WHERE member_id=97120;
# User@Host: amorem_uaseytr[amorem_uaseytr] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 129 Rows_examined: 129
SELECT typed,image,clickable,emo_set FROM ibf_emoticons;
# User@Host: amorem_uaseytr[amorem_uaseytr] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 11 Rows_examined: 11
SELECT * FROM ibf_custom_bbcode;
# User@Host: amorem_uaseytr[amorem_uaseytr] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 7 Rows_examined: 12
SELECT * FROM ibf_daffiliates_list WHERE approved='1' AND visible='1' ORDER BY affid ASC LIMIT 0,8;
# User@Host: amorem_uaseytr[amorem_uaseytr] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
DELETE FROM ibf_sessions WHERE member_id=97933;
# User@Host: amorem_uaseytr[amorem_uaseytr] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
DELETE FROM ibf_sessions WHERE ip_address='79.166.111.253';
# User@Host: amorem_uaseytr[amorem_uaseytr] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 4
SELECT * FROM ibf_login_methods WHERE login_enabled=1;
# User@Host: amorem_uaseytr[amorem_uaseytr] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
DELETE FROM ibf_sessions WHERE id='9a8e25696fe1a122cbacb69d792c71fb' OR ip_address='xx.xx.xxx.xxx';
# User@Host: amorem_uaseytr[amorem_uaseytr] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
DELETE FROM ibf_sessions WHERE member_id=38044;
# User@Host: amorem_uaseytr[amorem_uaseytr] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0


Any ideas?

[Gary.]

Issue was resolved huh ? :whistle: