similar to: mariadb server memory usage

On 11/04/2017 10:05 AM, hw wrote: > > Hi, > > is this ok for a database server, or do I need to turn the memory > allowance > down?? The machine has 48GB and mariadb is allowed about 40. The > machine is a dedicated database server. > > Mysql seems to go up to what top says is virtually allocated under some > circumstances; I don?t know what mariadb does.? I don?t

Disk cache is not recommended for databases servers. it'll slow down the performance. More ram equals more performance. This link help me understand memory usage on linux. https://www.linuxatemyram.com/ Basically you need yo worry about free memory is close to 0 used memory is close to total available memory (or "free + buffers/cache") has enough room (let's say, 20%+ of

marcos valentine wrote: > Disk cache is not recommended for databases servers. > > it'll slow down the performance. More ram equals more performance. > > This link help me understand memory usage on linux. > > https://www.linuxatemyram.com/ > > Basically you need yo worry about > > free memory is close to 0 > used memory is close to total Almost 3GB

Hi there, I know this is off-topic or semi off-topic but I really need some help since I am stucked. I'm trying to redirect MariaDB logs to `/var/log/mysql/*.log` files as shown below on the `/etc/my.cnf.d/server.cnf` file: # # 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

Hey all, I just unstalled MariaDB version 10 from the mariadb repositories under a CentOS 7 host. The install went fine! [root at nfsdb1 ~]# rpm -qa | grep -i mariadb MariaDB-common-10.0.19-1.el7.centos.x86_64 MariaDB-server-10.0.19-1.el7.centos.x86_64 MariaDB-client-10.0.19-1.el7.centos.x86_64 MariaDB-shared-10.0.19-1.el7.centos.x86_64 However, when I go to start up the service, I'm

My C7 system has mariadb 5.5.37, installed from the Centos repository. The latest version (with a security update is 5.5.39). Mariadb.org has its own repositories, but they don't list Centos 7 as an option. Is anyone using the repository for Centos 6 with Centos 7? See

Hi Earl, >I think I found your problem, you do not have the correct package installed >[root at c7-db1 ~]# rpm -qa | grep maria >mariadb-libs-5.5.41-2.el7_0.x86_64 >mariadb-server-5.5.41-2.el7_0.x86_64 >mariadb-5.5.41-2.el7_0.x86_64 >[root at c7-db1 ~]# >Install the mariadb-x package and you should be able to start the service Thanks. While I could go with mariadb 5, the

I've looked high and low and I cannot a package that has the mariadb driver to go with bind-sdb-9.9.4-14.el7_0.1.x86_64. Everything I'm finding is how to build from source, which for this project will not be maintainable. Is there a yum repo with this driver anywhere? Thanks much, Jim

Folks I'm having problems installing Mariadb in Centos 7. Here's what I did: 0) Become root 1) Make sure that mariadb and mysql are NOT installed. 2) Delete residual libs rm -rf /var/lib/mysq* 3) yum install -y mariadb-server installed mariadb-5.5.50-1.el7_2.x86_64 from the Centos 'updates' repository 4) systemctl start mariadb 5) systemctl status mariadb

Todor Petkov wrote: >> I'm running CentOS-7, but I left some MySQL databases >> on my old CentOS-6.5 partition which I'd like to retrieve. >> I assume they are contained in the file /var/lib/mysql/ibdata1 ? >> >> Could I just copy this file to /var/lib/mysql in CentOS-7? >> Or is there some way Mariadb or phpMyAdmin can import mysql databases >>

On Mon, Nov 30, 2015 at 5:50 PM, Wes James <comptekki at me.com> wrote: > Does this help: > > > http://dba.stackexchange.com/questions/98732/how-to-enable-queries-logs-in-mariadb > < > http://dba.stackexchange.com/questions/98732/how-to-enable-queries-logs-in-mariadb > > > > did search online - maybe you need to change mysql log location that might >

On 5/10/2015 1:04 PM, Earl A Ramirez wrote: > Did a little Googling [0] and I saw that they recommend starting it as > follows: > > /etc/init.d/mysql start which is old school sysVinit style. my guess is, you'll need to fix up a systemd service description file, like /usr/lib/systemd/system/mariadb.service -- john r pierce, recycling bits in santa cruz

Dear list, we're actually using # lsb_release -a LSB Version: :core-4.1-amd64:core-4.1-noarch Distributor ID: CentOS Description: CentOS Linux release 7.2.1511 (Core) Release: 7.2.1511 Codename: Core on our database server using # yum info mariadb-server Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * EPEL_7: ftp.pbone.net * base: centosmirror.netcup.net *

I'm running CentOS-7, but I left some MySQL databases on my old CentOS-6.5 partition which I'd like to retrieve. I assume they are contained in the file /var/lib/mysql/ibdata1 ? Could I just copy this file to /var/lib/mysql in CentOS-7? Or is there some way Mariadb or phpMyAdmin can import mysql databases from a server that is no longer running? -- Timothy Murphy gayleard /at/

Hi, somehow phpmyadmin messed things up when I was trying to modify a table. The table disappeared, and now it's impossible to re-create it: MariaDB [time]> create table etikettend_metainfo (userID integer(6) unsigned, stationsnummer integer(4) unsigned, primary key (userID)); ERROR 1005 (HY000): Can't create table `time`.`etikettend_metainfo` (errno: 150 "Foreign key

Hello! I've found it out, how you can solve/work around the problem: Nextcloud needs MariaDB. It won't work (so it seems) with MySQL. So mariadb- server needs to be installed. This replaces MySQL (mysql-server-core-5.7 and mysql-client-core-5.7) with MariaDB. The problem is that after that, Akonadi won't start any longer. "aconadictl start" outputs a lot of messages.

Hey all, I just got around to trying out CentOS 7. And for some reason when I attempt to install mysql-server, instead I'm offered mariadb? I'm using epel and remi as my repos. [root at web1:/etc/yum.repos.d] #cat /etc/redhat-release Red Hat Enterprise Linux Server release 7.0 (Maipo) [root at web1:/etc/yum.repos.d] #yum repolist Loaded plugins: amazon-id, rhui-lb repo id

Greetings, All! I've got an email server set up with Postfix and Dovecot, but Dovecot can't find any users.? I'd ilke to use the database I set up in MariaDB for users (referenced by Postfix), but I'm just not sure how to do it.? There's a line in dovecot.conf specifying /etc/dovecot/passwd.db, but obviously that's not the one I set up in MariaDB.? Is what I want even

At 09:36 AM 9/23/2016, you wrote: >On 2016-09-22 18:07, david wrote: > > Folks > > > > I'm having problems installing Mariadb in Centos 7. > > > > > > Here's what I did: > > > > 0) Become root > > 1) Make sure that mariadb and mysql are NOT installed. > > 2) Delete residual libs > > rm -rf /var/lib/mysq* >

Hi, I am configuring master-slave replication in a MariaDB 10.X over Centos 7.1 and I am having some troubles. When I configure the slave I use the following directies in my.cnf: ... master-host = 192.168.122.2 master-user = slave_user master-password = qwerty master-connect-retry = 60 ... But is seems that the daemon doesn't like them and it refuses to