Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
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:
Click Here
Please login or register. 2024-04-28, 01:44:36

Author Topic: innoDB  (Read 4284 times)

0 Members and 1 Guest are viewing this topic.

Offline Amney

  • Senior Member
  • *
  • Posts: 208
  • Karma: +0/-0
  • ????????.
    • View Profile
    • ????????? ??????
innoDB
« on: 2015-12-17, 14:46:58 »
hello!
how to include innoDB?

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: innoDB
« Reply #1 on: 2015-12-17, 16:01:39 »
Change 'skip-innodb' to '#skip-innodb' in /etc/my.cnf or /etc/my.cnf.d/server.cnf. And restart with 'sh /script/restart-mysql -y'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline Amney

  • Senior Member
  • *
  • Posts: 208
  • Karma: +0/-0
  • ????????.
    • View Profile
    • ????????? ??????
Re: innoDB
« Reply #2 on: 2015-12-17, 16:18:34 »

mistake after the
Code: [Select]
sh/script/restart-mysql team - y

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: innoDB
« Reply #3 on: 2015-12-17, 16:33:12 »
Inform here 'cat /etc/my.cnf.d/server.cnf'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline Amney

  • Senior Member
  • *
  • Posts: 208
  • Karma: +0/-0
  • ????????.
    • View Profile
    • ????????? ??????
Re: innoDB
« Reply #4 on: 2015-12-17, 17:12:56 »
Inform here 'cat /etc/my.cnf.d/server.cnf'.
Code: [Select]
#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#

# this is read by the standalone daemon and embedded servers
[server]

# this is only for the mysqld standalone daemon
[mysqld]
default-storage-engine=innodb
skip-innodb
performance_schema=on
#OpenVZ AIO bug fix
innodb_use_native_aio=0

# this is only for embedded server
[embedded]

# This group is only read by MariaDB servers, not by MySQL.
# If you use the same .cnf file for MySQL and MariaDB,
# you can put MariaDB-only options here
[mariadb]

# This group is only read by MariaDB-10.0 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don't understand
[mariadb-10.0]


Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: innoDB
« Reply #5 on: 2015-12-17, 17:26:44 »
Why still 'skip-innodb' instead '#skip-innodb' inside /etc/my.cnf.d/server.cnf?.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline Amney

  • Senior Member
  • *
  • Posts: 208
  • Karma: +0/-0
  • ????????.
    • View Profile
    • ????????? ??????
Re: innoDB
« Reply #6 on: 2015-12-17, 17:33:02 »
Why still 'skip-innodb' instead '#skip-innodb' inside /etc/my.cnf.d/server.cnf?.
I apologize.
Now everything works.

 


MRatWork Affiliates:    BIGRAF(R) Inc.    House of LMAR    EFARgrafix
Click Here

Page created in 0.059 seconds with 18 queries.

web stats analysis