Skip to main content
Share Your Experience: Take the 2024 Developer Survey
8 votes

mysql55 spontaneous malfunction

Did you see this in the log file? 160930 3:05:54 InnoDB: Fatal error: cannot allocate memory for the buffer pool You do not have enough memory available on your host. Either decrease the amount of ...
Philᵀᴹ's user avatar
  • 31.8k
7 votes
Accepted

How can I check the path of my.ini, through the command line?

mysqld.exe does not report the location of the my.ini it is using. I learned over the years that the my.ini file is supposed to be in the parent folder of the data and bin directories: Feb 06, 2012 : ...
RolandoMySQLDBA's user avatar
4 votes

Unable to start mysqld service after enabling log_bin

According to the manual entry for the mysqld option log-bin: If you specify this option without also specifying a --server-id, the server is not allowed to start. So it seems you need something ...
3 votes

Something in MySQL is causing progressively high load which consumes almost all memory

table_open_cache=1501,open_files_limit=3003 (as suggested by Vasiliki) should be fine. Note: When open_files_limit is more than ulimit -n, the former is lowered during startup. So, do SHOW ...
Rick James's user avatar
  • 78.4k
3 votes
Accepted

MySQL 5.7.15 turn off strict mode

On Aug 05, 2015, I answered the post Set sql_mode “blank” after upgrading to MySQL 5.6 In my answer, I explained how Oracle created an additional my.cnf called /usr/my/cnf. It has this (keep in mind ...
RolandoMySQLDBA's user avatar
2 votes

mysql55 spontaneous malfunction

As Phil already wrote - You don't have enough memory on Your database server. Search syslog for Out of memory error and search what processes were running, before OOM killer stopped MySQL. This way ...
Marcin S.'s user avatar
  • 723
2 votes

Mariadb configuration is not loaded from my.cnf

I am having the same problem in ~/.my.cnf file (MySQL 5.5.5-10.2.6-MariaDB installed via Homebrew). Apparently it is a recorded bug in both MySQL and MariaDB: Bug #84172 The pid-file value is ...
osman's user avatar
  • 121
2 votes

Can't start mysqld after crash

The error message at the end of the logs you posted, points to a possible mismatch of ibdata file name mismatch. Have a look at the old data files that you have (/var/lib/mysql is the default ...
thatsaru's user avatar
  • 688
2 votes

MySQL fails to start after editing my.cnf

This is too big for a comment. For comparison I'll paste the contents of my custom "my.cnf file". The command to generate this was grep -v "#" mysqld.cnf executed in /etc/mysql/mysql.conf.d My file ...
knb's user avatar
  • 151
2 votes
Accepted

After Update Mysql 8.0.13 to 8.0.15 MySql Server Fails with error code = 1265

I found the solution myself. On the old mysql 8.0.13 server I corrected the field SQL_MODE of one of the procedures, what happened to be too long. SELECT * FROM INFORMATION_SCHEMA.ROUTINES; I found ...
bitranox's user avatar
  • 121
2 votes
Accepted

Something in MySQL is causing progressively high load which consumes almost all memory

With performance issues, it's never one thing that is causing the problem. I will write all the tweaking I did and hopefully this will help others too. Everyone's comments were soooo helpful, you all ...
Vasiliki's user avatar
  • 181
1 vote

mysqld process performance

Lowering this (or turning off the QC) may help performance: query_cache_size = 50M The slowlog is where we can find the villain. See http://mysql.rjweb.org/doc.php/mysql_analysis#...
Rick James's user avatar
  • 78.4k
1 vote

Mysqld process not showing all options on command line in CentOs 7

SHOW GLOBAL VARIABLES; works on all versions of MySQL on all operating systems. When run from the commandline 'mysql' tool, the output is a few hundred lines something like: +------------------------...
Rick James's user avatar
  • 78.4k
1 vote

Mysqld process not showing all options on command line in CentOs 7

You shouldn't be relying on the OS processlist to display mysqld options in the events other versions of the OS do not display them (as your questions points out) What other methods can you use that ...
RolandoMySQLDBA's user avatar
1 vote

Mariadb configuration is not loaded from my.cnf

Not sure if this is some default behaviour of Mariadb or lack of our knowledge to figure how Mariadb picks its my.cnf. I have worked to resolve similar issue and made mysqld_safe to point to the my....
Mannoj's user avatar
  • 1,561
1 vote

How do correct mysqld.log error messages on start up?

It looks like this may have been upgraded at some point and mysql_upgrade was not run afterwards as it should have been. Have a look at the documentation for this and see if you can run it in your ...
Phil Sumner's user avatar
  • 1,877
1 vote

Different services using different port pointing to same datadir folder

NO! Do not attempt to have the same files accessed by different instances of MySQL. The code has now way of coordinating access between them. (If it did, it would slow MySQL down to a crawl.)
Rick James's user avatar
  • 78.4k
1 vote

mysqld is terminated because the system is low on memory; what to do?

In 1GB of RAM, you may be able to set innodb_buffer_pool_size to 50M, maybe 100M. But definitely not 800M. The 80% advice is predicated on having at least 4GB of RAM, and 80% is too high even for ...
Rick James's user avatar
  • 78.4k
1 vote

Cant initialize MySQL. "mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended"

Check permissions of /var/lib/mysql /var/run/mariadb Those folders have to be owned by mysql user /tmp/ has to be global writable +t chmod 777 /tmp/ chmod +t /tmp/ chown root:root /tmp/ $ ls -...
rubo77's user avatar
  • 816
1 vote

Cant initialize MySQL. "mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended"

[ERROR] mysqld: File '/var/lib/mysql/aria_log_control' not found (Errcode: 13 "Permission denied") [ERROR] InnoDB: ./ibdata1 can't be opened in read-write mode [ERROR] InnoDB: The system tablespace ...
Josh Bonello's user avatar
1 vote

Cant initialize MySQL. "mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended"

The error says: The system tablespace must be writable Please check the permission of the data directory of MySQL
Geetanjali's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible