|
#1
|
|||
|
|||
Announce.php high load in mysqld on 1500 peers
Announce.php high load in mysqld on 1500 peers
anyone can help me to use announce from tbdev |
#2
|
|||
|
|||
Quote:
You have to add aditional indexes to your database tables peers, sntached , usergroups and users. The index of your tables will grow up, but you will earn speed! Add to user table: PHP Code:
PHP Code:
PHP Code:
PHP Code:
Dont forget to increase your key buffer size for mysql engine :D Please tell how helpfull this was! Last edited by benjaminbih; 2nd January 2010 at 16:22. |
#3
|
|||
|
|||
re
this commands helps me now mysqld stay on 20-60% not in 100-150 %
how much to insrase key buffer size? |
#4
|
|||
|
|||
Go to phpmyadmin and look how big all your indexes together are.
Let us say your indexes are 100MB big, then set it to +50% = 150MB and look from time to time if you need to increase key buffer again. You can add more indexes if you need. You have to look over each mysql_query($string) that is often loaded. And if the query search on a not indexed column then add index to it. Example1: PHP Code:
Example2: PHP Code:
Or if the where statment search over 3 or 4 columns you have to add an index over 3 or 4 columns. You have to try which are the best indexes for you. |
#5
|
|||
|
|||
how to remove anti-cheat mod this high load
|
#6
|
|||
|
|||
Before you try to remove the mod, try this change to DB:
PHP Code:
|
#7
|
|||
|
|||
thx
Is verry helpfully for me thx much
If you know something ticks tell me Thanks a lot |
#8
|
|||
|
|||
tell us please how much your server load decrease in this case?
|
#9
|
|||
|
|||
25836 mysql 20 0 234m 49m 6220 S 14 2.5 7:33.31 mysqld
and not jump after 50 % Bump: now jumping cpu after 100% please help to full indexing the database Bump: any one can say me somme indexing triks ? |
Tags |
1500 , announcephp , high , load , mysqld , peers |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
warning in server load | toontigger | Torrent Strike | 3 | 4th February 2010 23:33 |
announce.php cauzing high load on hosting servers | Syn | Template Shares | 8 | 29th June 2009 22:26 |
high quality designer available | Zepp | Sell & Buy | 1 | 31st May 2009 12:37 |
Plaease help Server Load problem!!! | dmtr123 | Torrent Trader | 2 | 19th October 2008 20:18 |
[REQ] Server load mod | scener | Template Shares | 1 | 23rd July 2008 04:54 |