my.cnf's questions - English 1answer

121 my.cnf questions.

I've just installed a Percona instance of Mysql on an Amazon server and can not find the my.cnf file anywhere. I found auto.cnf in /var/lib/mysql but there is nothing in that file like what I have ...

I am trying to optimize memory usage (eating up more than 500MB by default) of MySQL using my.cnf, but I am having some trouble. The service is not starting after placing my custom my.cnf. It goes ...

I have a Joomla app that takes my MySQL instance down all the time. It uses too much CPU and performs too many queries without using indexes, queries very large tables and is using non-optimized ...

The variable I am trying to change is innodb_buffer_pool_size. As you can see below the settings is 512M. But SELECT @@innodb_buffer_pool_size; returns 134217728. When I execute: /usr/libexec/mysqld -...

I am new Database engineer. I am having trouble in my server which is using too much CPU on database query(simple count statement). I have googled about it, so i found out it depends on system ...

I am using mariadb and I to investigate some issue I wanted to check the logs. To my surprise, log file is not generated for mariadb. I suspect this cannot be the case so I am doubting my search ...

Do wait_timeout session clear all running session or only sessions which are in SLEEP mode for specified seconds ?

I am working in a Vagrant box (for development) and I have a provisioner script written in Bash. The script does install MySQL and setup a few things: basically it does what mysql_secure_installation ...

Using MariaDB 10.2.15 (Linux Debian Stretch) I have created a ~/.my.cnf config file in my home directory in order to set a default database at connection time for all local client tools: [client] ...

I'm trying to make the mysql client connect to a mysql server without requiring the password to be given interactively. Steps taken: 1) First create a mylogin.cnf file $ mysql_config_editor set --...

I need suggestions for my.cnf optimization. Currently I have a server with 256GB Ram and 40(CPUs) along with website hosted on this server. My Wordpress database size is around 1GB and using myISAM ...

I need to set some mysql server specific options. Question is .. where do i put them. My first option was to setup a specific my.cnf under /etc/mysql .. just to find that this is replaced whenever i ...

I'm trying to increase to 9000 but MariaDB sets it at 4895 automatically. Here is my simple config https://pastebin.com/raw/4eFiuFSv MySQLTuner output: Control warning line(s) into /var/lib/mysql/...

We have about 5-6 different internal webapps (staff use only) that we will be transferring across to a new virtual server, however I need to setup our my.cnf settings first and I am lost (I am web ...

I updated the MySQL my.conf file and and restarted my server without a problem. As soon as I tried to access a table I received the error mysql #1033 - Incorrect information in file: I reverted ...

In addition to the formal documentation (i.e. https://mariadb.com/resources/blog/installing-mariadb-10-centos-7-rhel-7, etc), there are countless tutorials on installing MariaDB, however, not one of ...

I have a my.cnf file. In it I see wait_timeout as well as connect_timeout. What's the difference between these 2?

Permissions are correct. I actually went ahead and opened the file up to everyone (I know... big no-no but it's a closed off lab) any idea why MariaDB 5.5-56 wouldn't read the my.cnf file and just ...

I have searched all over but couldn't find where service mysqld restart picks up the configuration file from: sudo find / -name "*.cnf" | grep my /usr/share/doc/mysql-community-server-5.6.33/my-...

Do you have to restart MySQL to edit changes? Or can you edit them on the fly and restart MySQL or make the changes inside MySQL? This server runs 100s of website that are active and I don't really ...

I have a mysql server with 5.5. I tried to enable the binlog using the below config file. # BINARY LOGGING # server_id = 1 log_bin = /mysql/binlog/...

I'm having a big trouble with MySQL in my server. Well lets me explain, i have a system that run some cron jobs and these cron make alot of things in database many connections, when it get about 1500 ...

I have a MySQL 5.5 instance running on a RedHat distro. I have edited my.cnf with the following setting: wait_timeout=30 However, client connections are sleeping and never getting killed. The ...

I'm aware that there are dozens of questions similar to this, but it seems none has a definitive answer to my problem, so that's why I'm posting this... I hope in the right place. The problem: I ...

I have open a question on https://serverfault.com/questions/353888/mysql-full-text-search-cause-high-usage-cpu Some user recommended asking here. We built a news site. Every day we will input tens of ...

I changed MySQL default port from 3306 to 12929 in my.cnf in both client and mysqld sections on Debian. After that I restarted MySQL service. Then I ran netstat -tln and saw that MySQL is still ...

I am not a dedicated mysql admin but my friend and I have been working hard to fix the badly configured mysql files. We have reduced our number of pools to 2 from 20 and increased pool size to 90GB ...

My mariadb configuration in my.cnf is not getting loaded for "log-error" and "pid-file". I have checked other configurations params are loaded. [root@kvm10 ~]# cat /etc/my.cnf [mysqld] !includedir /...

So I have a CentOS server that I have started to configure replication on my local machine. When I take a look at the master server with show master status;, I get the following: +------------------+...

I'm using MySQL Community Server 5.7.15-log and MySQL Connector/ODBC 5.3.6 on Windows 2012 and getting a lot of these messages: [Note] Aborted connection X to db: 'Y' user: 'Z' host: 'localhost' (...

Mysql become very slowly when it create MYD and MYI tables in /tmp directory. So I am forced to restart it. In my settings mysql I have: innodb_buffer_pool_size = 14G innodb_buffer_pool_instances = ...

I have a Master Master replication setup in RHEL for 2 Nodes.One server is acting as Master as well as slave for another Server ( which is also Master and Slave ) Let us say A server and B server I ...

How do you calculate mysql max_connections ? What do you take into consideration ?

I am not having any performance problems per se but want to improve my sites' performance if possible. Would appreciate any advice for how I can improve my.cnf. I have just one server, not ...

My issues have spawned from file permission changes leading to the popular ERROR! MySQL server PID file could not be found! error. However, I believe I've repaired them, but still cannot restart MySQL....

The following configuration in my.cnf is not being followed. Max_connections go back to 151. please help as i have 16gb of dedicated ram that i would like to use properly. [mysqld] datadir=/var/...

If I want to replicate how the MySQL/Maria client reads ~/.my.cnf, /etc/my.cnf, etc, how would I do it? The MySQL docs give a list of paths and mention "top files are read first, files read later ...

I'm trying to copy a database from a server to my local machine, I've installed Wamp 2.2, mysql 5.5.16, but during copying db I m getting "mysql server has gone" 2006, I've tried to fix it by changing ...

First time i am sorry about my English , but please help me on my.cnf . I read many post about config Mysql for best optimize but not thing to imporve. My server is Data center that contains two ...

Currently I have the following happening : And : When i run the query i get about 68 entries with most Time set at 0 show full processlist; What I'm doing wrong ? How do i free some memory ? Is it ...

So I was trying to figure out how to write an automated backup script for php on a shared webhost to execute using mysqldump, with no root access to core php.ini or mysql config on the remote database ...

Good morning, I'm currently facing a problem where CPU usage keeps going up until the server crash. I've tried multiple best practices proposed in this forum and on Percona, reinstalled the server ...

MySQL keeps crashing on start with the following message. It crashed after I was trying to batch upload data into a table and now it can't start since. This is an already existing database so it ...

We have a HAProxy which balances reads and writes to only one (of three) Galera nodes. If this balancing works fine, the parameters wsrep_log_conflicts and cert.log_conflicts should never log any ...

I migrated my eCommerce website database (Magento) from MySQL to MariaDB (10.0.25-MariaDB) and my site isn't performing as well as it did with MySQL. I've gone through my.cnf several times but to be ...

I'm trying to change the max_allowed_packet setting on mysql cluster (version 7.4.8) - i have 5 nodes 2x SQL Node 2x Data Node 1x Managament Node I have updated the my.cnf on all of the servers ->[...

With mysqld running, I expect to see that /etc/my.cnf has been used by at least one of the commands ps aux | grep mysql | grep -v grep mysqladmin variables | grep defaults-file showing the value of ...

Got error while doing mysql service restart. Googled a lot, but nothing fix my issue. [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format. 2016-04-23 11:10:38 22185 [...

I have an InnoDB database table with more than 2 million rows. I am running efficienty indexed queries to reduce server load, but site becomes slower day by day. I ran Mysqltuner.pl to identify any ...

MySQL was started with service mysql start only, but it is not showing the default path of my.cnf: [root@localhost home]# ps -ef|grep mysql root 23505 1 0 19:23 pts/4 00:00:00 /bin/sh /...

Related tags

Hot questions

Language

Popular Tags