Фризы Из-За Бд

[Reliable 119]

Ребят проблема в следующем когда убивают РБ или моба с которого много дропа у игроков идет фриз, я думаю это из-за записи в БД итемов, как это поправить Linux Debian.

И еще когда сайт завязан с БД долго грузит сайт.

Изменено 9 октября, 2013 пользователем Reliable

[k0ss11 302]

сборка,сервер что-то пишет?

[Reliable 119]

[19:54:22] ERROR Error while updating item : 1463 Soulshot: D-grade (2592)[268526049]

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

 

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

at sun.reflect.GeneratedConstructorAccessor178.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:526)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117)

at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:350)

at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2393)

at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2430)

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2215)

at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:813)

at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)

at sun.reflect.GeneratedConstructorAccessor179.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:526)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:334)

at java.sql.DriverManager.getConnection(DriverManager.java:571)

at java.sql.DriverManager.getConnection(DriverManager.java:187)

at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:78)

at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)

at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1181)

at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)

at l2ft.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:76)

at l2ft.gameserver.database.DatabaseFactory.getConnection(DatabaseFactory.java:25)

at l2ft.gameserver.dao.ItemsDAO.update0(ItemsDAO.java:242)

at l2ft.gameserver.dao.ItemsDAO.update(ItemsDAO.java:343)

at l2ft.gameserver.model.items.ItemInstance.update(ItemInstance.java:1137)

at l2ft.gameserver.model.items.Inventory.onModifyItem(Inventory.java:172)

at l2ft.gameserver.model.items.ItemContainer.destroyItem(ItemContainer.java:507)

at handler.items.SoulShots.useItem(SoulShots.java:124)

at l2ft.gameserver.model.Player.autoShot(Player.java:6219)

at l2ft.gameserver.model.Player.unChargeShots(Player.java:6192)

at l2ft.gameserver.model.Creature.onHitTimer(Creature.java:3003)

at l2ft.gameserver.model.GameObjectTasks$HitTask.runImpl(GameObjectTasks.java:318)

at l2ft.commons.threading.RunnableImpl.run(RunnableImpl.java:21)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

at java.util.concurrent.FutureTask.run(FutureTask.java:262)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at java.lang.Thread.run(Thread.java:724)

Caused by: java.net.ConnectException: Connection refused

at java.net.PlainSocketImpl.socketConnect(Native Method)

at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)

at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)

at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)

at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)

at java.net.Socket.connect(Socket.java:579)

at java.net.Socket.connect(Socket.java:528)

at java.net.Socket.<init>(Socket.java:425)

at java.net.Socket.<init>(Socket.java:241)

at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:257)

at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300)

... 37 more

Изменено 9 октября, 2013 пользователем Reliable

[WesteroS 132]

да, это бд, есть оптимизированный конфиг, проверенный на 2к народа, если железка не фуфло то будет все хоккей, хочу 500р. Контакты в профиле

Изменено 9 октября, 2013 пользователем WesteroS

[Reliable 119]

дорого, нету щас денег(