MRatWork Forum by Mustafa Ramadhan - Problem MariaDB dan Innodb

Sponsor:
Server and Web Integrator
Link:
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:

MRatWork Forum | Please login or register. | 2017-11-07, 23:13:54

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- Problem MariaDB dan Innodb

« previous next »

- Print

Pages: 1 [2] Go Down

### Author Topic: Problem MariaDB dan Innodb (Read 3795 times)

0 Members and 1 Guest are viewing this topic.

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: Problem MariaDB dan Innodb

« Reply #15 on: 2015-08-04, 09:20:37 »
Infokan 'cat /etc/my.cnf'.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### redpages

- Senior Member
- Posts: 316
- Karma: +0/-0

##### Re: Problem MariaDB dan Innodb

« Reply #16 on: 2015-08-04, 09:33:49 »
berikut:
Quote

> [mysqld]
> ## General
> datadir = /var/lib/mysql
> tmpdir = /var/lib/mysqltmp
> socket = /var/lib/mysql/mysql.sock
> skip-name-resolve
> sql-mode = NO_ENGINE_SUBSTITUTION
> #event-scheduler = 1
> ## Cache
> thread-cache-size = 16
> table-open-cache = 4096
> table-definition-cache = 2048
> query-cache-size = 32M
> query-cache-limit = 1M
> ## Per-thread Buffers
> sort-buffer-size = 1M
> read-buffer-size = 1M
> read-rnd-buffer-size = 1M
> join-buffer-size = 1M
> ## Temp Tables
> tmp-table-size = 32M
> max-heap-table-size = 64M
> ## Networking
> back-log = 100
> #max-connections = 200
> max-connect-errors = 10000
> max-allowed-packet = 16M
> interactive-timeout = 3600
> wait-timeout = 600
> ### Storage Engines
> #default-storage-engine = InnoDB
> innodb = FORCE
> ## MyISAM
> key-buffer-size = 64M
> myisam-sort-buffer-size = 128M
> ## InnoDB
> #innodb-buffer-pool-size = 128M
> #innodb-log-file-size = 100M
> #innodb-log-buffer-size = 8M
> #innodb-file-per-table = 1
> #innodb-open-files = 300
> ## Replication
> server-id = 1
> #log-bin = /var/log/mysql/bin-log
> #relay-log = /var/log/mysql/relay-log
> relay-log-space-limit = 16G
> expire-logs-days = 7
> #read-only = 1
> #sync-binlog = 1
> #log-slave-updates = 1
> #binlog-format = STATEMENT
> #auto-increment-offset = 1
> #auto-increment-increment = 2
> ## Logging
> #log-output = FILE
> #slow-query-log = 1
> #slow-query-log-file = /var/log/mysql/slow-log
> #log-slow-slave-statements
> #long-query-time = 2
> [mysqld_safe]
> log-error = /var/log/mysqld.log
> open-files-limit = 65535
> [mysql]
> no-auto-rehash

Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: Problem MariaDB dan Innodb

« Reply #17 on: 2015-08-04, 09:42:45 »
Coba jalankan 'sh /script/disable-mysql-aio' jika pakai OpenVZ VPS.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### redpages

- Senior Member
- Posts: 316
- Karma: +0/-0

##### Re: Problem MariaDB dan Innodb

« Reply #18 on: 2015-08-04, 09:50:01 »
sudah.
setelah reboot dan start mysqld hasilnya masih failed.
Berikut sysinfonya juga:
Last login: Tue Aug 4 03:51:02 2015 from 202.67.46.18
Quote

> [root@server100 ~]# service mysqld start
> MySQL Daemon failed to start.
> Starting mysqld: [FAILED]
> [root@server100 ~]# sh /script/sysinfo
> A. Kloxo-MR: 7.0.0.b-2015073001
> - Web: hiawatha-9.14.0-f.6.mr.el6.i386
> - PHP: php54s-5.4.43-1.ius.el6 (cgi mode)
> B. Plateform:
> - OS: CentOS release 6.6 (Final) i686
> - Hostname: server100.xbackbone.com
> C. Services:
> 1. MySQL: mysql55-5.5.44-2.ius.el6.i686
> 2. PHP:
> - Branch: php54-cli-5.4.43-1.ius.el6.i686
> - Used: --Use PHP Branch--
> 3. Httpd: httpd-2.2.31-1.mr.el6.i386
> - PHP Type: [unknown]
> 4. Lighttpd: --uninstalled--
> 5. Hiawatha: --unused--
> 6. Nginx: --uninstalled--
> 7. Cache: --uninstalled--
> 8. Dns: bind-9.9.7-1.mr.el6.i386
> 9. Qmail: qmail-toaster-1.03-1.3.55.mr.el6.i386
> - with: courier-imap-toaster-4.1.2-1.3.18.mr.el6.i386
> D. Memory:
> total used free shared buffers cached
> Mem: 1024 165 858 3 0 109
> -/+ buffers/cache: 56 967
> Swap: 0 0 0
> E. Disk Space:
> Filesystem Size Used Avail Use% Mounted on
> /dev/simfs 30G 1.5G 29G 5% /

Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: Problem MariaDB dan Innodb

« Reply #19 on: 2015-08-04, 09:59:49 »
Coba ganti 'relay-log-space-limit = 16G' ke 'relay-log-space-limit = 1G'
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### redpages

- Senior Member
- Posts: 316
- Karma: +0/-0

##### Re: Problem MariaDB dan Innodb

« Reply #20 on: 2015-08-04, 10:22:14 »
uda reboot dan start mysqld masih failed.
Quote

> ..
> [root@server100 ~]# service mysqld status
> mysqld is stopped
> [root@server100 ~]# service mysqld start
> MySQL Daemon failed to start.
> Starting mysqld: [FAILED]

my.cnf
Quote

> ..
> ..
> server-id = 1
> #log-bin = /var/log/mysql/bin-log
> #relay-log = /var/log/mysql/relay-log
> relay-log-space-limit = 1G
> expire-logs-days = 7
> #read-only = 1
> ..
> ..

Logged

#### MRatWork

- Administrator
- The Elite
- Posts: 15,381
- Karma: +112/-9
- Gender:

##### Re: Problem MariaDB dan Innodb

« Reply #21 on: 2015-08-04, 10:32:18 »
Coba baca kloxo-mr-technical-helpsurgent-help-i-can27t-login-error-not_admin_cannot_modify_generalmsg41070.html terkait my-medium.cnf atau my-large.cnf.
Logged
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

#### redpages

- Senior Member
- Posts: 316
- Karma: +0/-0

##### Re: Problem MariaDB dan Innodb

« Reply #22 on: 2015-08-04, 11:19:20 »
alhamdulillah sudah jalan. Menggunakan "cp -f /usr/share/mysql/my-large.cnf /etc/my.cnf" sebagaimana referensi tersebut.
Selanjutnya, karena ingin menggunakan innodb, maka dibagian skip-innodb saya kasih comment. Semoga asumsi saya benar.
Note: VPS menggunakan OpenVS
Quote

> # The MySQL server
> [mysqld]
> ..
> ..
> performance-schema=on
> default-storage-engine=myisam
> #skip-innodb
> #OpenVZ AIO bug fix
> innodb-use-native-aio=0

Logged

- Print

Pages: 1 [2] Go Up
« previous next »

- MRatWork Forum by Mustafa Ramadhan »
- Language Specific Discussions »
- Indonesia Users »
- Problem MariaDB dan Innodb

Top 10 Social Networking: Facebook Twitter LinkedIn Pinterest Google Plus Tumblr Instagram VK Flickr Vine

- Design By SMFSimple.com
- SMF 2.0.14 | SMF © 2017, Simple Machines

Page created in 0.05 seconds with 17 queries.

Mirror created by MasterkinG32.CoM