Решено Долгий ответ на запрос от бд

В общем, стоял Iconomy, при посылке запроса типа: снять денюшку выдать предмет. Была задержка прмерно 2-5 секунд и сильно понижался тпс.
Думал это изза Iconomy, сменил на Fe, ситуация чуть улучшилась, но не особо поменялась. Теперь оно варнит в консоли про долгий ответ, бла бла.
Отрывок из мультикрафта прилепляю.

Код:

8.11 01:01:31 [Server] INFO Lag Notice - Slow Economy Response - Request took over 447.517ms!
08.11 01:01:31 [Server] INFO §a§csyllik§r §aпродал customnpcs_npcsatchel за §a$10 §a(10 предметов за $1 каждый).
08.11 01:01:31 [Multicraft] Skipped 23 lines due to rate limit (30/s)
08.11 01:01:28 [Server] WARN at com.earth2me.essentials.commands.Commandsell.sellItem(Commandsell.java:106)
08.11 01:01:28 [Server] WARN at com.earth2me.essentials.User.giveMoney(User.java:141)
08.11 01:01:28 [Server] WARN at com.earth2me.essentials.User.giveMoney(User.java:151)
08.11 01:01:28 [Server] WARN at com.earth2me.essentials.User.getMoney(User.java:398)
08.11 01:01:28 [Server] WARN at com.earth2me.essentials.User._getMoney(User.java:422)
08.11 01:01:28 [Server] WARN at com.earth2me.essentials.register.payment.methods.VaultEco.hasAccount(VaultEco.java:82)
08.11 01:01:28 [Server] WARN at org.melonbrew.fe.Economy_Fe.hasAccount(Economy_Fe.java:194)
08.11 01:01:28 [Server] WARN at org.melonbrew.fe.API.accountExists(API.java:81)
08.11 01:01:28 [Server] WARN at org.melonbrew.fe.database.Database.accountExists(Database.java:70)
08.11 01:01:28 [Server] WARN at org.melonbrew.fe.database.Database.getAccount(Database.java:44)
08.11 01:01:28 [Server] WARN at org.melonbrew.fe.database.databases.SQLDB.loadAccountMoney(SQLDB.java:161)
08.11 01:01:28 [Server] WARN at com.niccholaspage.nSQL.query.SelectQuery.execute(SelectQuery.java:55)
08.11 01:01:28 [Server] WARN at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2273)
08.11 01:01:28 [Server] WARN at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
08.11 01:01:28 [Server] WARN at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
08.11 01:01:28 [Server] WARN at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
08.11 01:01:28 [Server] WARN at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
08.11 01:01:28 [Server] WARN at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3516)
08.11 01:01:28 [Server] WARN at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2968)
08.11 01:01:28 [Server] WARN at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3082)
08.11 01:01:28 [Server] WARN at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
08.11 01:01:28 [Server] WARN at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
08.11 01:01:28 [Server] WARN at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
08.11 01:01:28 [Server] WARN at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
08.11 01:01:28 [Server] WARN at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
08.11 01:01:28 [Server] WARN at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
08.11 01:01:28 [Server] INFO The last packet successfully received from the server was 168,972 milliseconds ago.  The last packet sent successfully to the server was 1 milliseconds ago.
08.11 01:01:28 [Server] WARN com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
08.11 01:01:03 [Server] INFO Overlord: syllik
08.11 01:01:03 [Server] INFO default: Iepapx
08.11 01:01:03 [Server] INFO Сейчас 2 из 100 игроков на сервере.
08.11 01:00:00 [Server] INFO CONSOLE: Save complete.
08.11 01:00:00 [Server] INFO CONSOLE: Forcing save..
08.11 01:00:00 [Multicraft] Server ran command Сохранить мир
08.11 00:59:33 [Server] INFO Overlord: syllik
08.11 00:59:33 [Server] INFO default: Iepapx
08.11 00:59:33 [Server] INFO Сейчас 2 из 100 игроков на сервере.
08.11 00:59:32 [Server] INFO syllik : ошибками срет падл
08.11 00:59:27 [Server] INFO syllik : ghf
08.11 00:59:03 [Server] INFO Bukkit permissions enabled
08.11 00:58:39 [Multicraft] Skipped 50 lines due to rate limit (30/s)
08.11 00:58:35 [Server] WARN at java.lang.reflect.Method.invoke(Method.java:606)
08.11 00:58:35 [Server] WARN at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
08.11 00:58:35 [Server] WARN at sun.reflect.GeneratedMethodAccessor39.invoke(Unknown Source)
08.11 00:58:35 [Server] WARN at de.czymm.serversigns.Listeners.PlayerListener.playerInteractCheck(PlayerListener.java:79)
08.11 00:58:35 [Server] WARN at de.czymm.serversigns.Listeners.PlayerListener.executeSignFull(PlayerListener.java:113)
08.11 00:58:35 [Server] WARN at de.czymm.serversigns.Listeners.PlayerListener.hasEnoughMoney(PlayerListener.java:366)
08.11 00:58:35 [Server] WARN at org.melonbrew.fe.Economy_Fe.has(Economy_Fe.java:139)
08.11 00:58:35 [Server] WARN at org.melonbrew.fe.Economy_Fe.getBalance(Economy_Fe.java:92)
08.11 00:58:35 [Server] WARN at org.melonbrew.fe.API.accountExists(API.java:81)
08.11 00:58:35 [Server] WARN at org.melonbrew.fe.database.Database.accountExists(Database.java:70)
08.11 00:58:35 [Server] WARN at org.melonbrew.fe.database.Database.getAccount(Database.java:44)
08.11 00:58:35 [Server] WARN at org.melonbrew.fe.database.databases.SQLDB.loadAccountMoney(SQLDB.java:161)
08.11 00:58:35 [Server] WARN at com.niccholaspage.nSQL.query.SelectQuery.execute(SelectQuery.java:55)
08.11 00:58:35 [Server] WARN at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2273)
08.11 00:58:35 [Server] WARN at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
08.11 00:58:35 [Server] WARN at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
08.11 00:58:35 [Server] WARN at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
08.11 00:58:35 [Server] WARN at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
08.11 00:58:35 [Server] WARN at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3516)
08.11 00:58:35 [Server] WARN at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2968)
08.11 00:58:35 [Server] WARN at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3082)
08.11 00:58:35 [Server] WARN at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)
08.11 00:58:35 [Server] WARN at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
08.11 00:58:35 [Server] WARN at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
08.11 00:58:35 [Server] WARN at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
08.11 00:58:35 [Server] WARN at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
08.11 00:58:35 [Server] WARN at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
08.11 00:58:35 [Server] INFO The last packet successfully received from the server was 152,047 milliseconds ago.  The last packet sent successfully to the server was 0 milliseconds ago.
08.11 00:58:35 [Server] WARN com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
08.11 00:58:02 [Server] INFO Overlord: syllik
08.11 00:58:02 [Server] INFO default: Iepapx
08.11 00:58:02 [Server] INFO Сейчас 2 из 100 игроков на сервере.
08.11 00:56:31 [Server] INFO Overlord: syllik
08.11 00:56:31 [Server] INFO default: Iepapx
08.11 00:56:31 [Server] INFO Сейчас 2 из 100 игроков на сервере.
08.11 00:56:03 [Server] INFO §aIepapx §aпродал customnpcs_npcsatchel за §a$50 §a(50 предметов за $1 каждый).
08.11 00:56:01 [Server] INFO Lag Notice - Slow Economy Response - Request took over 447.261ms!
08.11 00:56:00 [Server] INFO ... 15 more
08.11 00:56:00 [Server] INFO at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:334) ~[JavaPluginLoader$1.class:git-Cauldron-MCPC-Plus-1.7.2-1.1147.04.196]
08.11 00:56:00 [Server] INFO at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_67]
08.11 00:56:00 [Server] INFO at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.7.0_67]
08.11 00:56:00 [Server] INFO at sun.reflect.GeneratedMethodAccessor46.invoke(Unknown Source) ~[?:?]
08.11 00:56:00 [Server] INFO at com.abcalvin.BanItem.PlayerListener.onInteractEvent(PlayerListener.java:39) ~[?:?]
08.11 00:56:00 [Server] INFO Caused by: java.lang.NoSuchFieldError: all
08.11 00:56:00 [Server] INFO at java.lang.Thread.run(Thread.java:745) [?:1.7.0_67]

 

А где ж бд то стоит? Если удалённо, то поздравляю.

 

Бд не вместе с сервером стоит, это столь важно?

 

Важно. Сервер и БД должны стоять на одной машине. Запрос идёт дольше от одной машине к другой. И ты уже знаешь, что при этом происходит.

 

Ясно, спасибо. Может посоветуете заодно хороший vds/vps до 400 р?

 

С таким бюджетом разве что только "тазик" можно взять.

 

Да хоть тазик, главное чтобы работал, мне только для теста нужно, а при открытии я естессна больше возьму.

 

NetBreeze.net. Если не нравится то иди на poiskvps.ru