I am sick of tired..

[crazy]

Sorry for the title but the thing is it is true. I am sick of tired from errors and my ultra very slow forum

I am on a dedicated and I am alone (!)

I did all the innodb tuning settings , I am using cache , I tried litespeed nothing changed.

Please look the picture

Are you seeing the error times? in the same minute there are hundred errors and can u see the page size? 5290 thousand page error(!)

105.796 thousand errors(!)

I am really about the sell my forum because of this. Since I moved xenforo I cant get rid of this errors.

All of my users are getting these things and they are telling me everyday hundred times. We put litespeed we tried everything but my forum is ultra slow.

Can someone save me?

 

[crazy]

Can you get a copy of your my.cnf and post (make sure no passwords are in it).

Thanks for your answer
Sure,

 

[CTXMedia]

innodb_buffer_pool_size=12G

How much RAM have you got in your server?

 

[crazy]

innodb_buffer_pool_size=12G

How much RAM have you got in your server?

8GB ram and 8 core

 

[Deebs]

Can you also run the following SQL statements:

show global variables like 'tmp_table_size';

show global variables like 'max_heap_table_size';

 

[Deebs]

8GB ram and 8 core

In that case you have tried to allocate more ram than you physically have. Reduce innodb_buffer_pool_size down to 4g to start.

 

[crazy]

Can you also run the following SQL statements:

There u go,

Variable_name​

Value​

tmp_table_size
16777216​

​

Variable_name​

Value​

max_heap_table_size 16777216
​

 

[Deebs]

See the post above about reducing the buffer pool.

Those values are set to default which is fine. Can you run the following (before restarting the server to change the buffer pool size):

show global status like 'Created_tmp_tables';

show global status like 'Created_tmp_disk_tables';

show global status like 'uptime';

 

[crazy]

See the post above about reducing the buffer pool.

Those values are set to default which is fine. Can you run the following (before restarting the server to change the buffer pool size):

There is the values, I changed the buffer pool size

​

Variable_name​

Value​

Created_tmp_tables 1496975
​

Variable_nameValueCreated_tmp_tables 1496865
Variable_nameValueUptime333840

 

[crazy]

Try disabling that add-on, whatever it is.

If it's from the site I think it is, I would think twice about using an add-on from a site that uses nulled software.

I think the problem was that add-on since I removed it my website is very very fast.

 

[Digital Doctor]

I think the problem was that add-on since I removed it my website is very very fast.

What addon ?

 

[crazy]

What addon ?

******AdvStats

This add-on cause everything. It was a mistake for me to install this.

 

[Deebs]

There is the values, I changed the buffer pool size

​

Variable_name​

Value​

Created_tmp_tables 1496975​

​

Variable_nameValueCreated_tmp_tables 1496865
Variable_nameValueUptime333840

Wow, that is a lot of temporary tables, I suspect that the reason is that you had NO server memory left due to over subscribing with the buffer pool value so every temporary table was being created on disk. It is a real shame you didn't run the SQL below as that would have confirmed my thoughts.

show global status like 'Created_tmp_disk_tables';

 

[Deebs]

Can you login to a shell and run free -m and paste the output here. Be interesting to see your memory usage now that you have reduced the buffer pool.

 

[crazy]

Wow, that is a lot of temporary tables, I suspect that the reason is that you had NO server memory left due to over subscribing with the buffer pool value so every temporary table was being created on disk. It is a real shame you didn't run the SQL below as that would have confirmed my thoughts.

show global status like 'Created_tmp_disk_tables';

I did that query it is in my post?

Can you login to a shell and run free -m and paste the output here. Be interesting to see your memory usage now that you have reduced the buffer pool.

root@server [~]# free -m
total used free shared buffers cached
Mem: 8036 7583 452 0 226 6551
-/+ buffers/cache: 805 7230
Swap: 5471 0 5471

 

[Deebs]

I did that query it is in my post?



root@server [~]# free -m
total used free shared buffers cached
Mem: 8036 7583 452 0 226 6551
-/+ buffers/cache: 805 7230
Swap: 5471 0 5471

That is much better. Unfortunately you only ran this: show global status like 'Created_tmp_tables';

 

[crazy]

That is much better. Unfortunately you only ran this: show global status like 'Created_tmp_tables';

Im sorry I think I copied that 2 times

there you go

Created_tmp_disk_tables 328730​

 

[Deebs]

Im sorry I think I copied that 2 times

there you go

Created_tmp_disk_tables 328730​

No problem, I wanted to see the value before you changed the server memory but it doesn't matter. Glad your forum is now running fast for you.

 

[Floris]

First mistake, installing an add-on that has viet in it ..

 

[Paul B]

******AdvStats

Try disabling that add-on, whatever it is.

If it's from the site I think it is, I would think twice about using an add-on from a site that uses nulled software.

Exactly what I said yesterday, with good reason.