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 |
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! |
re
this commands helps me now mysqld stay on 20-60% not in 100-150 %
how much to insrase key buffer size? |
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. |
how to remove anti-cheat mod this high load
|
Before you try to remove the mod, try this change to DB:
PHP Code:
|
thx
Is verry helpfully for me thx much
If you know something ticks tell me Thanks a lot |
tell us please how much your server load decrease in this case?
|
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 ? |
All times are GMT +2. The time now is 05:39. |
Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.