Перейти к содержанию
Авторизация  
Подписчики 0
URSA

Сбой связи mysql (debian 7)

Автор URSA, в База данных

Рекомендуемые сообщения

URSA    3

URSA
Опубликовано

При заходе на аккаунт персонажей не видно, только после создания нового появляются.

 

[15.10.15 04:27:13] Loaded 708 Filter Words.


[15.10.15 04:27:13] Checking folders: preparations
[15.10.15 04:27:13] Checking folders: all folders checked.
[15.10.15 04:27:13] Loaded 1416 Filter Words.
[15.10.15 04:27:13] L2DatabaseFactory: Connected to database server
[15.10.15 11:27:14] ..................................................
[15.10.15 11:27:14] System Time: 15-10-2015 11:27:14 AM
[15.10.15 11:27:14] ..................................................
[15.10.15 11:27:14] OS: Linux Build: 2.6.32-042stab108.5
[15.10.15 11:27:14] OS Arch: amd64
[15.10.15 11:27:14] ..................................................
[15.10.15 11:27:14] ..................................................
[15.10.15 11:27:14] Avaible CPU(s): 2
[15.10.15 11:27:14] Processor(s) Identifier: null
[15.10.15 11:27:14] ..................................................
[15.10.15 11:27:14] ..................................................
[15.10.15 11:27:14] Runtime Information
[15.10.15 11:27:14] Current Free Heap Size: 1402 mb
[15.10.15 11:27:14] Current Heap Size: 1450 mb
[15.10.15 11:27:14] Maximum Heap Size: 2986 mb
[15.10.15 11:27:14] ..................................................
[15.10.15 11:27:14] ..................................................
[15.10.15 11:27:14] Java Platform Information
[15.10.15 11:27:14] Java Runtime Name: OpenJDK Runtime Environment
[15.10.15 11:27:14] Java Version: 1.7.0_79
[15.10.15 11:27:14] Java Class Version: 51.0
[15.10.15 11:27:14] ..................................................
[15.10.15 11:27:14] ..................................................
[15.10.15 11:27:14] Virtual Machine Information (JVM)
[15.10.15 11:27:14] JVM Name: OpenJDK 64-Bit Server VM
[15.10.15 11:27:14] JVM installation directory: /usr/lib/jvm/java-7-openjdk-amd64/jre
[15.10.15 11:27:14] JVM version: 24.79-b02
[15.10.15 11:27:14] JVM Vendor: Oracle Corporation
[15.10.15 11:27:14] JVM Info: mixed mode
[15.10.15 11:27:14] ..................................................
[15.10.15 11:27:14] ..................................................
[15.10.15 11:27:14] Initializing Script Engine Manager.
[15.10.15 11:27:15] Script Engine: jython 2.2.1 - Language: python - Language Version: 2.2.1
[15.10.15 11:27:15] Script Engine: java 1.6 - Language: java - Language Version: 1.6
[15.10.15 11:27:15] Script Engine: Rhino Rhino 1.7 release 3 2012 02 13 - Language: ECMAScript - Language Version: 1.7
[15.10.15 11:27:16] ThreadPoolManager: Initializing.
[15.10.15 11:27:16] General threads: ..... 18.
[15.10.15 11:27:16] Effect threads: ...... 24.
[15.10.15 11:27:16] AI threads: .......... 24.
[15.10.15 11:27:16] Packet threads: ...... 16.
[15.10.15 11:27:16] Total threads: ....... 82.
[15.10.15 11:27:16] L2World: Setting up World Regions
[15.10.15 11:27:17] L2World: (136 by 136) World Region Grid set up.
[15.10.15 11:27:17] DeadlockDetector: Initializing
[15.10.15 11:27:18] IdFactory: Cleaned 0 elements
[15.10.15 11:27:18] IdFactory: Cleanup items
[15.10.15 11:27:18] IdFactory: Cleanup clans
[15.10.15 11:27:18] IdFactory: Cleanup items on ground
[15.10.15 11:27:18] IDFactory: 205824 id's avaliable.
[15.10.15 11:27:18] MapRegionManager: Loaded 38 restartpoint(s).
[15.10.15 11:27:18] MapRegionManager: Loaded 23 restartareas with 145 arearegion(s).
[15.10.15 11:27:18] MapRegionManager: Loaded 235 zoneregion(s).
[15.10.15 11:27:18] MapRegionManager: Loaded 4 race depending redirects.
[15.10.15 11:27:18] AnnounceManager: Loaded 7 announce
[15.10.15 11:27:18] AnnounceManager: Loaded 0 auto announce
[15.10.15 11:27:18] IdFactory: Free ObjectID's remaining: 1879046699
[15.10.15 11:27:18] ExtensionManager: Loaded 0 extension(s)
[15.10.15 11:27:18] Static Objects: Loaded 29 object(s)
[15.10.15 11:27:18] GameTimeController: Initialized.
[15.10.15 11:27:18] Initializing BoatManager
[15.10.15 11:27:18] Initializing InstanceManager
[15.10.15 11:27:18] Multiverse Instance created
[15.10.15 11:27:18] Universe Instance created
[15.10.15 11:27:18] AttackStanceTaskManager: Initialized.
[15.10.15 11:27:18] DecayTaskManager: Initialized.
[15.10.15 11:27:18] KnownListUpdateTaskManager: Initialized.
[15.10.15 11:27:18] LeakTaskManager: Initialized.
[15.10.15 11:27:18] SQLQueue: started
[15.10.15 11:27:19] TeleportTable: Loaded 982 location
[15.10.15 11:27:20] SkillTreeTable: Loaded 36069 skills.
[15.10.15 11:27:21] FishingSkillTreeTable: Loaded 109 general skills.
[15.10.15 11:27:21] FishingSkillTreeTable: Loaded 8 dwarven skills.
[15.10.15 11:27:21] EnchantSkillTreeTable: Loaded 14520 enchant skills.
[15.10.15 11:27:21] PledgeSkillTreeTable: Loaded 64 pledge skills.
[15.10.15 11:27:33] SkillTable: Loaded 31162 skill templates from XML files.
[15.10.15 11:27:33] SkillTable: Occupying arrays for 74928.
[15.10.15 11:27:33] ExtraSkillTable: Loaded 55 skills.
[15.10.15 11:27:33] ResidentialSkillTable: Loaded 0 skills.
[15.10.15 11:27:34] PetSkillsTable: Loaded 1594 skills.
[15.10.15 11:27:34] NobleSkillTable: Initialized.
[15.10.15 11:27:34] HeroSkillTable: Initialized.
[15.10.15 11:27:34] Items: Cleanup items table
[15.10.15 11:27:35] ItemTable: Loaded 6899/6899 Items.
[15.10.15 11:27:35] ItemTable: Loaded 1014/1014 Armors.
[15.10.15 11:27:37] ItemTable: Loaded 1313/1313 Weapons.
[15.10.15 11:27:37] ArmorSetsTable: Loaded 51 armor sets.
[15.10.15 11:27:37] ArmorSetsTable: Loaded 51 armor sets.
[15.10.15 11:27:37] AugmentationData: Loaded: 52 augmentation stats.
[15.10.15 11:27:37] AugmentationData: Loaded: 1780 weapons skills.
[15.10.15 11:27:37] SkillSpellbookTable: Loaded 334 Spellbooks.
[15.10.15 11:27:37] SummonItemsData: Loaded 39 Summon Items from summon_items.xml
[15.10.15 11:27:37] Extractable items data: Loaded 344 extractable items!
[15.10.15 11:27:37] FishTable: Loaded 270 Fishes.
[15.10.15 11:27:37] ItemsAutoDestroy: initialized
[15.10.15 11:27:38] CharNameTable: Loaded 17 character names.
[15.10.15 11:27:38] CharTemplateTable: Loaded 89 Character Templates.
[15.10.15 11:27:38] LevelUpData: Loaded 103 Character Level Up Templates.
[15.10.15 11:27:38] Helper Buff Table: Loaded 25 Templates.
[15.10.15 11:27:38] HennaTable: Loaded 180 Templates.
[15.10.15 11:27:38] HennaTreeTable: Loaded 7128 Henna Tree Templates.
[15.10.15 11:27:38] CoupleManager: loaded 1 couples(s)
[15.10.15 11:27:38] ClanTable: restored 2 clans from the database.
[15.10.15 11:27:38] Cache[Crest]: 0,000MB on 1 files loaded.
[15.10.15 11:27:38] Cache[Crest]: (Forget Time: 300s , Capacity: 50)
[15.10.15 11:27:38] HeroSystem: Loaded 0 Heroes.
[15.10.15 11:27:38] HeroSystem: Loaded 0 all time Heroes.
[15.10.15 11:27:38] BlockListManager: Loaded 0 character block(s).
[15.10.15 11:27:41] NpcTable: Loaded 7058 Npc Templates.
[15.10.15 11:27:41] NpcTable: Loaded 8 Custom Npc Templates.
[15.10.15 11:27:42] NpcTable: Loaded 447 Minions.
[15.10.15 11:27:42] NpcLikePc :Loaded 1 template(s)
[15.10.15 11:27:42] PetDataTable: loaded 12 pets.
[15.10.15 11:27:42] AutoChatHandler: Loaded 32 handlers in total.
[15.10.15 11:27:42] AutoSpawnHandler: Loaded 129 spawn group(s) from the database.
[15.10.15 11:27:42] SevenSigns: Currently in the Competition (Quest Event) period!
[15.10.15 11:27:42] SevenSigns: The Seal of Avarice remains unclaimed.
[15.10.15 11:27:42] SevenSigns: The Seal of Gnosis remains unclaimed.
[15.10.15 11:27:42] SevenSigns: The Seal of Strife remains unclaimed.
[15.10.15 11:27:42] SevenSigns: The competition, if the current trend continues, will end in a tie this week.
[15.10.15 11:27:42] SevenSigns: Next period begins in 4 days, 6 hours and 32 mins.
[15.10.15 11:27:42] SevenSignsFestival: first Festival of Darkness cycle begins in 2 minutes.
[15.10.15 11:27:42] CrownManager: Initialized.
[15.10.15 11:27:42] ClanHallManager: loaded 0 clan halls
[15.10.15 11:27:42] ClanHallManager: loaded 44 free clan halls
[15.10.15 11:27:42] ClanHallManager: 4 halls in Gludio
[15.10.15 11:27:42] ClanHallManager: 5 halls in Gludin
[15.10.15 11:27:42] ClanHallManager: 4 halls in Dion
[15.10.15 11:27:42] ClanHallManager: 5 halls in Giran
[15.10.15 11:27:42] ClanHallManager: 7 halls in Aden
[15.10.15 11:27:42] ClanHallManager: 5 halls in Goddard
[15.10.15 11:27:42] ClanHallManager: 9 halls in Rune
[15.10.15 11:27:42] ClanHallManager: 4 halls in Schuttgart
[15.10.15 11:27:42] RegenTaskManager: Initialized.
[15.10.15 11:27:42] DoorTable: Loaded 223 Door Templates.
[15.10.15 11:27:42] Loaded: 9 castles
[15.10.15 11:27:42] SiegeManager: Loaded 0 registred siege(s)
[15.10.15 11:27:42] Initializing FortManager
[15.10.15 11:27:45] AttackableAiTaskManager: Initialized.
[15.10.15 11:27:45] GuardReturnHomeManager: Initialized.
[15.10.15 11:27:52] DayNightSpawnManager: Day/Night handler initialized
[15.10.15 11:27:53] SpawnTable: Loaded 37478 Npc Spawn Locations.
[15.10.15 11:27:53] SpawnTable: 0 Npc Not Spawned.
[15.10.15 11:27:53] Loaded: 21 fortress
[15.10.15 11:27:54] FortSiegeManager: Loaded 21 siege(s)
[15.10.15 11:27:54] ZoneManager: arena.xml loaded with 8 zones
[15.10.15 11:27:55] ZoneManager: peace.xml loaded with 42 zones
[15.10.15 11:27:55] ZoneManager: pagan.xml loaded with 1 zones
[15.10.15 11:27:55] ZoneManager: fishing.xml loaded with 40 zones
[15.10.15 11:27:55] ZoneManager: mothertree.xml loaded with 5 zones
[15.10.15 11:27:56] ZoneManager: monstertrack.xml loaded with 2 zones
[15.10.15 11:27:56] Siege of Gludio: Sat Oct 17 19:00:00 GMT+03:00 2015
[15.10.15 11:27:56] Siege of Dion: Sat Oct 17 19:00:00 GMT+03:00 2015
[15.10.15 11:27:56] Siege of Giran: Sun Oct 18 15:00:00 GMT+03:00 2015
[15.10.15 11:27:56] Siege of Oren: Sun Oct 18 15:00:00 GMT+03:00 2015
[15.10.15 11:27:56] Siege of Aden: Sat Oct 17 19:00:00 GMT+03:00 2015
[15.10.15 11:27:56] Siege of Innadril: Sun Oct 18 15:00:00 GMT+03:00 2015
[15.10.15 11:27:56] Siege of Goddard: Sun Oct 18 15:00:00 GMT+03:00 2015
[15.10.15 11:27:56] Siege of Rune: Sat Oct 17 19:00:00 GMT+03:00 2015
[15.10.15 11:27:56] Siege of Schuttgart: Sun Oct 18 15:00:00 GMT+03:00 2015
[15.10.15 11:27:57] ZoneManager: castle.xml loaded with 48 zones
[15.10.15 11:27:57] ZoneManager: water.xml loaded with 86 zones
[15.10.15 11:27:57] ZoneManager: custom.xml loaded with 0 zones
[15.10.15 11:27:58] Initializing QuestManager
[15.10.15 11:27:58] ZoneManager: boss.xml loaded with 16 zones
[15.10.15 11:27:58] ZoneManager: misc.xml loaded with 20 zones
[15.10.15 11:27:58] ZoneManager: stadia.xml loaded with 22 zones
[15.10.15 11:27:58] ZoneManager: forts.xml loaded with 42 zones
[15.10.15 11:27:59] ZoneManager: foursepulchers.xml loaded with 8 zones
[15.10.15 11:27:59] ZoneManager: clanhall.xml loaded with 44 zones
[15.10.15 11:27:59] MercTicketManager: loaded 0 Mercenary Tickets
[15.10.15 11:27:59] SiegeManager of Fortress Of Resistence
[15.10.15 11:27:59] SiegeManager of Bandits Stronghold
[15.10.15 11:27:59] SiegeManager of Devastated Castle
[15.10.15 11:27:59] SiegeManager of Fortres Of Dead
[15.10.15 11:27:59] SiegeManager of Wild Beasts Farm
[15.10.15 11:27:59] SiegeManager of Rainbow Springs Chateau
[15.10.15 11:28:01] Script Engine Manager: loaded 48 script(s) form corequests.jar
[15.10.15 11:28:06] Spawn Events Managers
[15.10.15 11:28:06] Spawn Game event manager
[15.10.15 11:28:06] NpcBufferSkillIdsTable: Loaded 1 buffers and 141 skills.
[15.10.15 11:28:06] Loaded: 422 quests
[15.10.15 11:28:06] HtmCache: Loaded 27552 HTM file(s) for 2 language(s)
[15.10.15 11:28:07] Despawned 601 creature(s), spawned 232
[15.10.15 11:28:07] RaidBossReturnHomeManager: Initialized.
[15.10.15 11:28:07] RaidBossSpawnManager: Loaded 190 Instances
[15.10.15 11:28:07] RaidBossSpawnManager: Scheduled 0 Instances
[15.10.15 11:28:07] CursedWeaponsManager: loaded 2 cursed weapon(s).
[15.10.15 11:28:08] FollowTaskManager: Initialized.
[15.10.15 11:28:08] AttackFollowTaskManager: Initialized.
[15.10.15 11:28:08] TradeListTable: Loaded 634 Buylists.
[15.10.15 11:28:08] ManorSystem: Manor period approve updated
[15.10.15 11:28:08] ManorSystem: Schedule for period approve @ Fri Oct 16 06:00:08 GMT+03:00 2015
[15.10.15 11:28:08] ManorManager: Loaded 256 seeds
[15.10.15 11:28:08] AuctionManager: loaded 38 auction(s)
[15.10.15 11:28:08] TimedItems: loaded 0 items
[15.10.15 11:28:08] Olympiad System: Loading Olympiad System....
[15.10.15 11:28:08] Olympiad System: Currently in Olympiad Period
[15.10.15 11:28:08] Olympiad System: 3632 minutes until period ends
[15.10.15 11:28:08] Olympiad System: Next weekly change is in 8582 minutes
[15.10.15 11:28:08] Olympiad System: Loaded 0 Nobles
[15.10.15 11:28:08] Olympiad System: Competition Period Starts in 0 days, 6 hours and 31 mins.
[15.10.15 11:28:08] Olympiad System: Event starts/started : Thu Oct 15 18:00:08 GMT+03:00 2015
[15.10.15 11:28:08] DimensionalRiftManager: Loaded 7 room types with 56 rooms.
[15.10.15 11:28:08] DimensionalRiftManager: Loaded 462 dimensional rift spawns, 0 errors.
[15.10.15 11:28:08] FourSepulchersManager: Loaded 4 mausoleum(s)
[15.10.15 11:28:08] FourSepulchersManager: Four Sepulchers will open at Thu Oct 15 11:55:00 GMT+03:00 2015
[15.10.15 11:28:08] GrandBossReturnHomeManager: Initialized.
[15.10.15 11:28:08] QueenAntManager: State of Queen Ant is ALIVE
[15.10.15 11:28:08] ZakenManager: State of Zaken is ALIVE
[15.10.15 11:28:08] CoreManager: State of Core is ALIVE
[15.10.15 11:28:08] OrfenManager: State of Orfen is ALIVE
[15.10.15 11:28:08] SailrenManager: State of Sailren is NOTSPAWN.
[15.10.15 11:28:08] VanHalterManager : State of High Priestess van Halter is ALIVE.
[15.10.15 11:28:08] AntharasManager: State of Antharas is NOTSPAWN.
[15.10.15 11:28:08] BaiumManager : State of Baium is NOTSPAWN.
[15.10.15 11:28:08] ValakasManager: State of Valakas is NOTSPAWN.
[15.10.15 11:28:08] ValakasManager: Next spawn date Wed Sep 02 11:50:57 GMT+03:00 2015.
[15.10.15 11:28:08] LastImperialTombManager: Init The Last Imperial Tomb.
[15.10.15 11:28:08] FrintezzaManager: State of Frintezza NOTSPAWN
[15.10.15 11:28:08] Faction Manager: disabled.
[15.10.15 11:28:08] RecipeController: Loaded 878 recipes.
[15.10.15 11:28:08] ItemHandler: Loaded 2090 handlers.
[15.10.15 11:28:08] SkillHandler: Loaded 90 handlers.
[15.10.15 11:28:09] ChatHandler: Loaded 16 handlers.
[15.10.15 11:28:09] ObjectRestrictions: loading...
[15.10.15 11:28:09] ObjectRestrictions: loaded 0 restrictions.
[15.10.15 11:28:09] SiegeStatus: loading...
[15.10.15 11:28:09] TaskManager: initalized.
[15.10.15 11:28:09] TaskManager: Registered: 6 Tasks.
[15.10.15 11:28:09] PetitionManager: initalized.
[15.10.15 11:28:09] Fishing Championship Manager : started
[15.10.15 11:28:09] Offline Manager: initialize...
[15.10.15 11:28:09] Offline Manager: load players from database.
[15.10.15 11:28:09] Offline Manager: 0 trader(s) loaded.
[15.10.15 11:28:09] Offline Manager: 0 trader(s) deleted.
[15.10.15 11:28:10] Connecting to login on 127.0.0.1:9014
[15.10.15 11:28:11] Registered on login as Server 1 : Bartz
[15.10.15 11:28:11] IOFloodManager: initialized.
[15.10.15 11:28:11] SuperDeamon: registred 1 handler(s)
[15.10.15 11:28:11] SuperDeamon: staring with poll interval 10 minute(s)
[15.10.15 11:28:11] GameEventManager: Event TeamVsTeam scheduled at 12:58:11
[15.10.15 11:28:11] GameEventManager: Event CTF scheduled at 11:58:11
[15.10.15 11:28:11] GameEventManager: Loaded 2 events.
[15.10.15 11:28:11] Cristmas event status: Off.
[15.10.15 11:28:11] Medals event status: Off.
[15.10.15 11:28:11] StarlightFestival event status: Off.
[15.10.15 11:28:11] L2Day event status: Off.
[15.10.15 11:28:11] BigSquash event status: Off.
[15.10.15 11:28:11] GmController: Loaded 302 handlers.
[15.10.15 11:28:11] GmController: Loaded 5 admin players.
[15.10.15 11:28:12] TaskManager: Loaded: 4 Tasks From Database.
[15.10.15 11:28:13] Build version: Private
[15.10.15 11:28:13] Free memory: 2649 Mb of 2986 Mb
[15.10.15 11:28:13] Ready on IP: 156.185.0.87:7777.
[15.10.15 11:28:13] Max players: 1000
[15.10.15 11:28:13] Load time: 60 Seconds.
[15.10.15 11:28:20] ArrivedCharacterManager: Initialized.
[15.10.15 11:28:21] L2Top: 0 processed
[15.10.15 11:30:22] Could not restore char info
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 134 467 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
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:1129)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3720)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3609)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4160)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2313)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at ru.catssoftware.gameserver.network.serverpackets.CharSelectionInfo.loadCharacterSelectInfo(Unknown Source)
at ru.catssoftware.gameserver.network.serverpackets.CharSelectionInfo.(Unknown Source)
at ru.catssoftware.gameserver.LoginServerThread.run(Unknown Source)
Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3166)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3620)
... 12 more
[15.10.15 11:30:32] TradeController: Could not update Timer save in Buylist

 

 

Возможно что то не так с my.cnf (не чего не менял после установки)

 

[client]
port=3306
socket=/var/run/mysqld/mysqld.sock

[mysqld_safe]
socket=/var/run/mysqld/mysqld.sock

[mysqld]
user=mysql
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/run/mysqld/mysqld.sock
port=3306
basedir=/usr
datadir=/var/lib/mysql
tmpdir=/tmp
lc-messages-dir=/usr/share/mysql
log_error=/var/log/mysql/error.log
max_connections=600
max_user_connections=30
wait_timeout=30
interactive_timeout=50
long_query_time=5
innodb_file_per_table

!includedir /etc/mysql/conf.d/

 

 

Помогите решить сию ошибку.

 

Поделиться сообщением

Ссылка на сообщение
Поделиться на другие сайты

URSA    3

URSA
Опубликовано
 

Решил сам, нужно было нормально настроить  my.cnf

Тему можно закрыть!

Поделиться сообщением

Ссылка на сообщение
Поделиться на другие сайты

MrDozoR    73

MrDozoR
Опубликовано

 

 

Решил сам, нужно было нормально настроить  my.cnf

Тему можно закрыть!

 

а можно поподробнее.... покажите что у вас было и что вы поменяли плиз))

Поделиться сообщением

Ссылка на сообщение
Поделиться на другие сайты

URSA    3

URSA
Опубликовано
 

Конечно можно.

Информацию о настройках смотрел тут http://web-scalability.com/2008/05/30/mysql-%D1%82%D1%8E%D0%BD%D0%B8%D0%BD%D0%B3-%D0%BD%D0%B0%D1%81%D1%82%D1%80%D0%B0%D0%B8%D0%B2%D0%B0%D0%B5%D0%BC-%D0%BF%D0%BE-%D0%B2%D0%B7%D1%80%D0%BE%D1%81%D0%BB%D0%BE%D0%BC%D1%83/

[client]


port=3306
socket=/var/run/mysqld/mysqld.sock

[mysqld_safe]
socket=/var/run/mysqld/mysqld.sock

[mysqld]
user=mysql
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/run/mysqld/mysqld.sock
port=3306
basedir=/usr
datadir=/var/lib/mysql
tmpdir=/tmp
lc-messages-dir=/usr/share/mysql
log_error=/var/log/mysql/error.log
max_connections=600
max_user_connections=30
wait_timeout=30
interactive_timeout=50
long_query_time=5
innodb_file_per_table

!includedir /etc/mysql/conf.d/

 

 

[client]
port=3306
socket=/var/run/mysqld/mysqld.sock

[mysqld_safe]
socket=/var/run/mysqld/mysqld.sock

[mysqld]
user=mysql
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/run/mysqld/mysqld.sock
port=3306
basedir=/usr
datadir=/var/lib/mysql
tmpdir=/tmp
lc-messages-dir=/usr/share/mysql
log_error=/var/log/mysql/error.log
key_buffer=1024M
query_cache_size=0
table_cache=384
max_connections=600
max_user_connections=30
wait_timeout=30
interactive_timeout=50
long_query_time=5
innodb_additional_mem_pool_size=16M
innodb_flush_log_at_trx_commit=2
innodb_log_buffer_size=16M
innodb_buffer_pool_size=512M
innodb_thread_concurrency=50
innodb_file_per_table
memlock

!includedir /etc/mysql/conf.d/

 

 

 

  • Upvote 2

Поделиться сообщением

Ссылка на сообщение
Поделиться на другие сайты

Для публикации сообщений создайте учётную запись или авторизуйтесь

Вы должны быть пользователем, чтобы оставить комментарий

Создать учетную запись

Зарегистрируйте новую учётную запись в нашем сообществе. Это очень просто!

Регистрация нового пользователя

Войти

Уже есть аккаунт? Войти в систему.

Войти
Авторизация  
Подписчики 0
Перейти к списку тем

  • Последние посетители   0 пользователей онлайн

    Ни одного зарегистрированного пользователя не просматривает данную страницу

×
×
  • Создать...