InnoDB and large post table

[Skipy7]

Centos 6. What was the issue?

​the systemctl commands to start, stop and enable on boot don't work says its missing a service file but the 5.5 packages from the centos repo work.

[AutoItScript]

I had a problem after installing where I couldn't start the service because mysql_safe couldn't be found. It might be the same thing. Bascially on my Centos install the mysqld binaries where located in /var/lib/mysql but after the MariaDB install they were in /usr/bin. To fix that I needed to change my my.cnf file to set the /usr basedir:

[mysqld]
datadir=/var/lib/mysql

[mysql.server]
basedir=/usr

Maybe it's related to your issue too.

Edit: I used the MariaDB repo for the install.

[RevengeFNF]

​What OS version you running MariaDB 10 on as I could not get it to run on my CentOS 7 install.

​Im using Centos 6.6.

Centos 7 comes with MariaDB in their repos.

I never done that in Centos 7, but i think you just need to follow this steps:
 

https://www.vultr.com/docs/install-mariadb-on-centos-7

 

[Skipy7]

​Im using Centos 6.6.

Centos 7 comes with MariaDB in their repos.

I never done that in Centos 7, but i think you just need to follow this steps:
 

https://www.vultr.com/docs/install-mariadb-on-centos-7

 

Yeah there repos comes with MariaDB 5.5 

Done alot of research not much info on it, looks like its to do with systemd and the MariaDB mirror for 10.0 and 10.1 beta does not have the systemd scripts.

[AutoItScript]

​innodb_buffer_pool_dump_at_shutdown = 1
innodb_buffer_pool_load_at_startup = 1
 

I didn't have those two options. Wow, what a difference it makes to being fast straight after a service restart  

 

[Machsterdaemon]

Yeah there repos comes with MariaDB 5.5 

Done alot of research not much info on it, looks like its to do with systemd and the MariaDB mirror for 10.0 and 10.1 beta does not have the systemd scripts.

​Did you try using systemctl command using the mysql name instead of mariadb?

It should work on CentOS 7.1 using the MariaDB 10 mirror.

There is a topic on similar issue on the CentOS forum that might be helpful. Confusing with systemctl for mariadb