Monday, June 15, 2015
.::: How To Configured Transaction IsolationLevel Level READ_COMMITED! on MySQL Server :::.
1. Get Error on log NMS
2015-06-15 12:06:57,158 ERROR [BootstrapBean] (ServerService Thread Pool -- 60) The MySQL Server must be configured for Transaction IsolationLevel Level READ_COMMITED!
2015-06-15 12:06:57,167 ERROR [BootstrapBean] (ServerService Thread Pool -- 60) The StableNet® Server will now exit due to this fatal error!
2015-06-15 12:06:57,174 ERROR [BootstrapBean] (ServerService Thread Pool -- 60)
2015-06-15 12:06:57,178 ERROR [BootstrapBean] (ServerService Thread Pool -- 60)
2015-06-15 12:06:57,184 ERROR [BootstrapBean] (ServerService Thread Pool -- 60) If this problem occurs again at the same position please
2015-06-15 12:06:57,193 ERROR [BootstrapBean] (ServerService Thread Pool -- 60) contact Infosim GmbH & Co. KG, support@infosim.net, +49 931 205 92 200
2. Add "transaction-isolation = READ-COMMITTED" on my.ini MySQL
on windows
# Path to installation directory. All paths are usually resolved relative to this.
# basedir="C:/Program Files (x86)/MySQL/MySQL Server 5.6/"
# Path to the database root
datadir=C:/ProgramData/MySQL/MySQL Server 5.6/Data
transaction-isolation = READ-COMMITTED
on Linux
[mysqld]
#
# * Basic Settings
#
user = mysql
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
transaction-isolation = READ-COMMITTED
3. Restart service MySQL
on windows
net stop mysql
net start mysql
on Linux
/etc/init/mysqld restart
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Sertifikasi profesional, kadang hanya disebut dengan sertifikasi atau kualifikasi saja, adalah suatu penetapan yang diberikan oleh ...
-
SQL atau Structured Query Language) adalah sebuah bahasa yang digunakan untuk mengakses data dalam basis data relasional. Bahasa ini sec...
-
bagaimana cara mengubah hostid di Solaris The Hostid is a globally unique ID for a Sun Solaris Machine. Sometimes, you need to change t...
-
DNSPerf and ResPerf are free tools developed by Nominum that make it simple to gather accurate latency and throughput metrics for Domain ...
-
1. Check Host ID Solaris The Hostid is a globally unique ID for a Sun Solaris Machine. Sometimes, you need to change this hostid for ...
No comments:
Post a Comment