Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #16  
Old 09 Oct 2013, 02:54
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Aug 2009
Real name: Chris
What are the specs on your server? Does this load slow down the site, or stop it from running?
__________________
You can get access to my 180 mods for vB 3.6 - 4.x at The Admin Zone as well as the professional support you are used to. New vBulletin Spider Definitions, vBulletin Spiders List Hits 1000 Spiders! ​ OzzModz down. Site has had a data breach, checking how the intrusion happened. Change your PW if you use the same one on my site and others.
Reply With Quote
  #17  
Old 09 Oct 2013, 03:19
abdobasha2004's Avatar
abdobasha2004 abdobasha2004 is offline
 
Join Date: Aug 2008
2x4 core
32g RAM
500 Giga hard disk space
The load first makes site slow down then stops running completely, then server auto restart and the cycle repeated
Reply With Quote
  #18  
Old 09 Oct 2013, 04:13
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
As that dive is 500GB & most likely SATA, its disk i/o is going to kill SQL.

What CPU is it running?

cat /proc/cpuinfo

RAM is fine, but your disk & cpu is lacking for the amount of users & size of DB.
Reply With Quote
  #19  
Old 09 Oct 2013, 04:43
abdobasha2004's Avatar
abdobasha2004 abdobasha2004 is offline
 
Join Date: Aug 2008
Originally Posted by snakes1100 View Post
As that dive is 500GB & most likely SATA, its disk i/o is going to kill SQL.

What CPU is it running?

cat /proc/cpuinfo

RAM is fine, but your disk & cpu is lacking for the amount of users & size of DB.
my host says : The server is running e3 1240v2
we could upgrade you to a SAS or SSD or even a SAS raid or SSD raid server.

what do you recommend?
Reply With Quote
  #20  
Old 09 Oct 2013, 07:28
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
Can you take a snapshot of "top" running when its under heavy load?

Hit 1 after top starts so we can see all the core's.
Reply With Quote
  #21  
Old 09 Oct 2013, 17:35
abdobasha2004's Avatar
abdobasha2004 abdobasha2004 is offline
 
Join Date: Aug 2008
Originally Posted by snakes1100 View Post
Can you take a snapshot of "top" running when its under heavy load?

Hit 1 after top starts so we can see all the core's.
now load is 40

the cause of this load is mysql

[mysqld]
query_cache_size=256M
table_cache=80000
max_connections=5000
open_files_limit=5400
log-slow-queries="/var/lib/mysql/slow.log"
innodb_file_per_table=1
thread_cache_size=4
interactive_timeout=60
wait_timeout=60
default-storage-engine=MyISAM
max_heap_table_size = 32M
local-infile=0
max_allowed_packet = 16MB


for my.cnf

and this is what mysql tuner says.

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.32-cll
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 1G (Tables: 333)
[--] Data in InnoDB tables: 224K (Tables: 14)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[--] Data in MEMORY tables: 16M (Tables: 111)
[!!] Total fragmented tables: 19

-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------
[--] Up for: 20h 0m 46s (32M q [447.256 qps], 2M conn, TX: 1387B, RX: 9B)
[--] Reads / Writes: 63% / 37%
[--] Total buffers: 424.0M global + 2.8M per thread (5000 max threads)
[OK] Maximum possible memory usage: 13.8G (59% of installed RAM)
[OK] Slow queries: 0% (979/32M)
[OK] Highest usage of available connections: 33% (1686/5000)
[OK] Key buffer size / total MyISAM indexes: 8.0M/1.1G
[OK] Key buffer hit rate: 99.0% (1B cached / 9M reads)
[OK] Query cache efficiency: 79.3% (16M cached / 21M selects)
[!!] Query cache prunes per day: 11559
[OK] Sorts requiring temporary tables: 0% (279 temp sorts / 1M sorts)
[OK] Temporary tables created on disk: 1% (3K on disk / 217K total)
[OK] Thread cache hit rate: 93% (182K created / 2M connections)
[OK] Table cache hit rate: 92% (15K open / 16K opened)
[OK] Open file limit used: 9% (15K/165K)
[OK] Table locks acquired immediately: 99% (16M immediate / 16M locks)
[OK] InnoDB data size / buffer pool: 224.0K/128.0M

-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Increasing the query_cache size over 128M may reduce performance
Variables to adjust:
query_cache_size (> 256M) [see warning above]

Reply With Quote
  #22  
Old 09 Oct 2013, 17:48
Simon Lloyd's Avatar
Simon Lloyd Simon Lloyd is offline
 
Join Date: Aug 2008
Real name: Simon
I think you may have a corrupt table as that server right now is hardly under load.
__________________
Kind regards,
Simon Microsoft Office Help
My Mods: Find my modifications here
Please do not pm me for support unless i have invited you to!
Reply With Quote
  #23  
Old 09 Oct 2013, 19:07
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
Originally Posted by Simon Lloyd View Post
I think you may have a corrupt table as that server right now is hardly under load.
What picture are you looking at?

-----------------------------------------

As your server's CPU is using over 60% on each core & your going defunct on almost every php pid, i would start by removing suPHP & running apache/php as a DSO.

You would also need to optimize that server.

Your my.cnf settings are badly done, if your host is the one doing it, i would put a stop to that, as they dont have a clue on how to optimize a server.

This variable (thread_cache_size=4) isnt even used under the [mysqld] section & its set wrong anyways.
Reply With Quote
  #24  
Old 09 Oct 2013, 19:18
Simon Lloyd's Avatar
Simon Lloyd Simon Lloyd is offline
 
Join Date: Aug 2008
Real name: Simon
Originally Posted by snakes1100 View Post
What picture are you looking at?.
His cpu usage and memory usage are fairly low, i suspect the load shown at the top is the entire load of the shared server.

There again i'm not wearing my glasses

--------------- Added 09 Oct 2013 at 19:21 ---------------

I'm also interested to know why you have mixed tables, you have a few InnoDB tables was that by choice, by install, your hosts...etc?
__________________
Kind regards,
Simon Microsoft Office Help
My Mods: Find my modifications here
Please do not pm me for support unless i have invited you to!
Reply With Quote
  #25  
Old 09 Oct 2013, 19:21
abdobasha2004's Avatar
abdobasha2004 abdobasha2004 is offline
 
Join Date: Aug 2008
Originally Posted by snakes1100 View Post
What picture are you looking at?

-----------------------------------------

As your server's CPU is using over 60% on each core & your going defunct on almost every php pid, i would start by removing suPHP & running apache/php as a DSO.

You would also need to optimize that server.

Your my.cnf settings are badly done, if your host is the one doing it, i would put a stop to that, as they dont have a clue on how to optimize a server.

This variable (thread_cache_size=4) isnt even used under the [mysqld] section & its set wrong anyways.
Do you have a recommended configuration plz
?
Reply With Quote
  #26  
Old 09 Oct 2013, 19:27
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
Is this a shared server?

Simon, in his first post, he states dedicated.

As far as recommendations, i would start by removing suPHP & running apache/php as a dso, you really need to find out whats going on.

As far as SQL goes, its not as simple as me telling you what to use here, the stats you posted arent enough.

As to mixed tables, there is nothing wrong with that.
Reply With Quote
  #27  
Old 09 Oct 2013, 19:36
abdobasha2004's Avatar
abdobasha2004 abdobasha2004 is offline
 
Join Date: Aug 2008
It is dedicated
are these the recommended settings to start with?
Reply With Quote
  #28  
Old 09 Oct 2013, 19:41
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
Start by removing suPHP & running apache/php as a DSO.

Then you can start checking your server logs for more details as to whats going on.

There is really no way to give you recommendations, as you havent provided much to work with in terms of settings on the server, apache, php, mysql & the OS settings for things like open file limits or if your running any caching programs etc.

Tuning a server entails much more than just simple data posted in the forums, as there are many things to look at.

Besides the fact that your server is using all its RAM & states only about 200MB free

table_cache=80000 <-- Thats way to high
max_connections=5000 <-- Way to high
open_files_limit=5400 <-- Doesnt matter unless the OS allows that many
thread_cache_size=4 <-- Wrong section & set wrong

Edit to add:
If your host is setting your server details, i would fire them on the spot for poor workmanship.......

--------------- Added 09 Oct 2013 at 21:13 ---------------

Looks like you down now for server load.

Run this cmd in ssh when this happens & post the results:
netstat -plan|grep :80|awk {'print $5'}|cut -d: -f 1|sort|uniq -c|sort -nk 1

Last edited by snakes1100; 09 Oct 2013 at 21:19.
Reply With Quote
  #29  
Old 10 Oct 2013, 20:51
abdobasha2004's Avatar
abdobasha2004 abdobasha2004 is offline
 
Join Date: Aug 2008
For all thanks for your help
It was discovered that the problem was a ddos attack + flooding
We used cloudflare business and problem solved

Thanks God

Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 07:43.

Layout Options | Width: Wide Color: