diff options
| author | Jesusaves <cpntb1@ymail.com> | 2024-02-24 15:57:21 -0300 |
|---|---|---|
| committer | Jesusaves <cpntb1@ymail.com> | 2024-02-24 15:57:21 -0300 |
| commit | 075afe457c551d6725c358651e2a9059b8b1896d (patch) | |
| tree | 4ceb5176ebeef4c1cfd9e32f3781957e802319f7 /npc/003-3 | |
| parent | 39c9cc7755bb063d61a6bc802beb13f5814ae1cf (diff) | |
| download | serverdata-075afe457c551d6725c358651e2a9059b8b1896d.tar.gz serverdata-075afe457c551d6725c358651e2a9059b8b1896d.tar.bz2 serverdata-075afe457c551d6725c358651e2a9059b8b1896d.tar.xz serverdata-075afe457c551d6725c358651e2a9059b8b1896d.zip | |
picklog overhead takes ~42 seconds from mysql... Don't do it on query_sql.
Diffstat (limited to 'npc/003-3')
| -rw-r--r-- | npc/003-3/malindou.txt | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/npc/003-3/malindou.txt b/npc/003-3/malindou.txt index 2115bd3f8..18ecd3302 100644 --- a/npc/003-3/malindou.txt +++ b/npc/003-3/malindou.txt @@ -1044,8 +1044,10 @@ OnClock0500: } // TODO: Have crontab make monthly .gz backup? // Remove overhead from picklog - if (gettime(GETTIME_DAYOFMONTH) == 14) - query_sql("OPTIMIZE TABLE `picklog`"); + if (gettime(GETTIME_DAYOFMONTH) == 14) { + apiasync("SQL", "OPTIMIZE TABLE `picklog`"); + apiasync("SQLRUN", ""); + } end; // This is for HUB |