Questions tagged [mysqld]

mysqld : Server Process for MySQL

Filter by
Sorted by
Tagged with
-2 votes
1 answer
66 views

Cannot start mysql server. Error

I'm on Ubuntu 20.4 and did some apt update/upgrade. Not sure what package was changed, but I'm unable to start my mysql server due to these error: === The manual page at http://dev.mysql.com/doc/mysql/...
user avatar
0 votes
5 answers
112 views

mysqld process performance [closed]

I'm running in problems that I can't solve by myself. Mysqld process go over 100%, sometimes over 500% in web peaks. Idk why mysql running only one process, websites works fast without any problem ...
user avatar
1 vote
0 answers
88 views

MariaDB service fails to start with InnoDB Space id error

I've been running MariaDB on a Raspberry Pi 4 (Raspbian 10 / buster) as the database server for my Webtrees and Owncloud sites. Recently, I noticed that the server wasn't looking right, and after a ...
user avatar
  • 11
0 votes
1 answer
3k views

The innodb_system data file 'ibdata1' must be writable even with full permissions set

i'm trying to change the datadir in mysql, i created a new directory with the user mysql as a owner, i know am not supposed to set the permission to 777. but even with this full permission still ...
user avatar
4 votes
3 answers
2k views

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

I have this server that has only one site with one database on it. And yet, I cannot tweak it to make the load go back down to normal. If I restart mysql service, memory and load go down to normal, ...
user avatar
  • 161
0 votes
1 answer
565 views

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

After Upgrading from MySql 8.0.13 (compiled from sourcecode) to MySql 8.0.15, the MySql Server can not start. Log: 2019-02-12T10:09:52.275336Z 1 [ERROR] [MY-013178] [Server] Execution of server-...
user avatar
  • 121
1 vote
2 answers
274 views

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

Mysqld process showed all config file options on command line in CentOs 5 and CentOs 6. But it's not showing the same in CentOs 7. I am using mysql 5.7.21 on CentOs 7 example stated below and 5.7.19 ...
user avatar
  • 409
1 vote
1 answer
5k views

Wordpress causes high CPU usage (mysqld)

I have a wordpress site with 500k posts in MYSQL database running on debian dedicated server: Server OS: Debian 8 "Jesssie)" - Linux version 4.9.58-xxxx-std-ipv6-64 (kernel@kernel.ovh.net) (gcc ...
user avatar
1 vote
0 answers
613 views

mariadb won't start

Using Vultr with Ubuntu 16.04 i386 along with EasyEngine and WP-CLI installed. Today I updated the machine to Ubuntu 16.04.3 LTS and upon restart the MySQL stopped working. I tried several ways and ...
user avatar
0 votes
1 answer
558 views

Is it possible to import DBs information_schema, performance_schema and mysql from mysql-community-server-5.6.x to mariadb-server-5.5.x?

Is it possible to import the following DBs from an existing mysql-community-server-5.6.x configuration to a fresh mariadb-server-5.5.x : +--------------------+ | Database | +----------------...
user avatar
1 vote
1 answer
3k views

Unable to start mysqld service after enabling log_bin

Hi I am unable to start mysqld service after I make changes in my.cnf to enable log-bin. After making changes the file looks like below: # For advice on how to change settings please see # http://dev....
user avatar
  • 11
2 votes
1 answer
1k views

mysqld node not connecting to cluster

I'm trying to set up a basic NDB cluster, the data nodes register correctly but the mysqld API node doesn't accept Connected to Management Server at: 174.138.80.168:1186 Cluster Configuration --------...
user avatar
2 votes
1 answer
2k views

MySQL fails to start after editing my.cnf

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 ...
user avatar
  • 121
-1 votes
1 answer
66 views

Mysql crashes on fresh installation

I try to run mysqld and here's the dump I get: https://pastebin.com/TCk2YWQN I tried re-installing mysql, but the same thing happens. Just running mysql returns ERROR 2002 (HY000): Can't connect to ...
user avatar
  • 161
3 votes
1 answer
13k views

MySQL 5.7.15 turn off strict mode

mysql Ver 14.14 Distrib 5.7.15, for Linux (x86_64) using EditLine wrapper I'm trying to configure my MYSQL instance to turn off some of the stricter settings currently I've done this: mysql> ...
user avatar
  • 133
1 vote
0 answers
295 views

Cannot kill query "Optimize Table" - the temporary #sql data keeps increasing!

First of all, I apologize if a similar question has been asked, but I am very not familiar with mySql and did my best to get used to some terms by reading wiki pages, etc and also look up topics on ...
user avatar
3 votes
1 answer
1k views

mysqld not starting up [closed]

I installed mysql on ubuntu. mysqld does not startup with the following errors - 2017-04-16T00:22:35.320639Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2017-04-16T00:...
user avatar
0 votes
2 answers
2k views

Mariadb configuration is not loaded from my.cnf

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 /...
user avatar
2 votes
0 answers
101 views

Signal handler on mysql connection break

I want to know if there is any signal that I can catch by which I can know that my mysql connection with the server has broken in c programming? I know I can check at query time whether my connection ...
user avatar
  • 21
1 vote
1 answer
4k views

Can't start mysqld after crash

Prehistory: I wanted to see how mysql handles in tables with millions of rows. So, I started to insert bunches of rows in one table. After ~80 millions mysql server has gone away and didn't start ...
user avatar
  • 11
0 votes
1 answer
499 views

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

I'm running Plesk and CentOS 6.7 Following is the excerpt of the log file mysqld.log when I restart mysqld service. I normally don't check this log file, but I just noticed some errors messages. It ...
user avatar
  • 123
1 vote
2 answers
171 views

mysql55 spontaneous malfunction [duplicate]

MySQL runs fine for weeks or days, and then suddenly and without any user action, all attempts to connect begin failing. This is /var/log/mysqld.log: 160916 14:42:01 [Note] /usr/libexec/mysql55/...
user avatar
-1 votes
1 answer
3k views

MAMP Pro - MySQL not starting

I've tried other reccomendations on other threads with same issue, but no luck. Please advise how to resolve. 160802 09:38:03 mysqld_safe Starting mysqld daemon with databases from /Library/...
user avatar
  • 101
1 vote
2 answers
50 views

Different services using different port pointing to same datadir folder

Let say I have already installed service MySQLa with mysqla.ini (port number=3306) setting and datadir folder in ...\data Is it possible then, I install another service MySQLb with mysqlb.ini (port ...
user avatar
1 vote
4 answers
3k views

20 mysqld processes using only 1 port?

These are from Aliyun Cloud DB Servers,20 mysqld processes using one 3306 port Has anyone seen this before ? Can anybody explain how to do that ? Are there any advantages to this ?
user avatar
1 vote
2 answers
2k views

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

I did recently a site migration; during that I had to erase all plugins and the reinstalling only the minimum as the site was causing the server to crash (A Vps with 1gb of ram), the most problematic ...
user avatar
  • 11
4 votes
3 answers
18k views

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

I am doing a fresh install of MySQL on Fedora 22. After I run mysql_install_db I try to start the daemon using mysqld_safe but it does not work. The system says: mysqld_safe Logging to '/var/log/...
user avatar
5 votes
1 answer
23k views

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

I would like to know, if possible, how to display (using the command line) the path to my.ini used by the server. I am using MySQL 5.6 inside a windows IIS. I have the following: Program Files\...
user avatar
  • 317
2 votes
2 answers
445 views

Mysql hand machine due to high load average and CPU

Mysql is used by only one application which only fire query periodically. When i restart server,It run smooth for period of time. and then crash the whole server. My my.cnf file [mysqld] datadir=/...
user avatar
4 votes
1 answer
8k views

MySQL server won't start with foreign_key_checks=0

I'm running Ubuntu with MySQL version 5.5.44 mysqld Ver 5.5.44-0ubuntu0.14.10.1 for debian-linux-gnu on x86_64 ((Ubuntu)) I have a DB with foreign keys. I would like to have the foreign key check ...
user avatar
2 votes
2 answers
2k views

MySQL binary logging with just one log file?

I have a MySQL database running with binary logging turned on. Each time the database is restarted a new binary log file is created in the format : mysql-bin.00001 mysql-bin.00002 ... mysql-bin.0000n ...
user avatar
5 votes
1 answer
4k views

How do I change the config path for mysqld?

I want to change configuration file path from C:\ to E:\, but I can't find the way to do this. Alternatively, is there a way to start a new instance with the config file I want? I've done something ...
user avatar
5 votes
1 answer
3k views

Too many mysql instances. How to kill?

I should be ashamed of myself, for asking, I know. Check out this screenshot attached. My server, which is indeed not seeing HUGE amounts of traffic, should not be this overloaded. Mysql is having ...
user avatar
  • 151
1 vote
1 answer
111 views

Where can I find mysqld error logs?

I am trying to run mysql but I get this errors and I don't know what to do. Are there any more error logs where I can find more information? /usr/local/mysql/bin# ./mysqld 150321 15:35:20 [ERROR] ...
user avatar
  • 26
0 votes
0 answers
32 views

MySQL Cluster - use subnet in config.ini for [MYSQLD] connections?

In MySQL Cluster (7.3), is there any way to lock down the [mysqld] section in config.ini to a small subnet, rather than setting it to a single IP Address, or open for any IP Address? I've searched ...
user avatar
  • 1,920
1 vote
1 answer
2k views

Moved MySQL datadir Now Server Will Not Run!

My problem yesterday (MySQL - Alter Table Fails As Workbench Tries To Create Existing Table) was caused by /dev/sda2 (/root) running out of space. The cause of this was that, by default, MySQL had ...
user avatar
1 vote
1 answer
328 views

mysqld can't start without any info

mysqld can't start without any info, that is the only information I get is 'Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!'. I edited the my.cnf file to enable logging on /...
user avatar
  • 115
2 votes
1 answer
26k views

mysqld got signal 11 - it's my fault but how do I fix it?

I was copying the database tables from our production server to my dev machine, and in the middle of the transfer I found out users were being locked out of the system because the select had locked a ...
user avatar
2 votes
1 answer
2k views

MySQL Daemon failed to start - Can't find file: './mysql/plugin.frm'

Fresh install of CentOS 6 on a test box, ran following as root: yum install mysql-server #success service mysqld start #success service mysqld stop #success cd /var/lib/ cp -rp ...
user avatar
  • 429
0 votes
0 answers
3k views

MySQL - Out of memory: Kill process 3046 (mysqld)

We run a MySQL (v5.6.17) dump backup every 4 hours, and today noticed: Apr 19 20:09:30 mysql1 kernel: Out of memory: Kill process 3046 (mysqld) score 970 or sacrifice child Apr 19 20:09:30 mysql1 ...
user avatar
  • 439
0 votes
1 answer
5k views

Is it safe, and how can I delete mysql.sock before mysqld start?

I have CentOS running on virtual machine on my desktop. When my desktop unexpectedly restarts (blue screen, power failure, restart after updates), virtual machine faces the same problem - unexpected ...
user avatar
4 votes
2 answers
1k views

Make MySQL server terminate when shell exits or on ctrl-c

If I run mysqld, ie invoke it directly on the command-line, it survives the shell being closed or hitting ctrl-c. Is there any way to run it "interactively", ie so that it will shut down if either of ...
user avatar
  • 291
1 vote
1 answer
2k views

one node in cluster got crashed ,how to recover it?

we are using percona galera cluster with 3 nodes. In my cluster one node got crashed due to low disk space ,we have cleared some log files and provided sufficient disk space.Now we are trying to start ...
user avatar
1 vote
2 answers
4k views

/usr/sbin/mysqld was deleted and replaced by another mysqld with different inode

This happened on three of our mysql server running on RHEL. While checking for open and deleted files, I found that mysqld in use is deleted (as seen in lsof) and was replaced by a similar mysqld (in /...
user avatar
3 votes
2 answers
9k views

mysqld dead but subsys locked

I'm executing the following command in a shell script and I'm executing this on an RHEL-6 server and MySQL version 5.1.47- mysqld_safe --defaults-extra-file=/custom/path/of/my.cnf The path of my.cnf ...
user avatar
2 votes
1 answer
10k views

mysqld_safe version different than mysqld?

Is it a problem that mysqld socket has a different version than the mysqld server? I noticed this in my mysqld log during startup 120420 19:30:06 mysqld_safe Starting mysqld daemon with databases ...
user avatar
  • 1,377