Questions tagged [mysqld]

mysqld : Server Process for MySQL

Filter by
Sorted by
Tagged with
0
votes
0answers
11 views

Can not stop mysqld with mysqladmin

I am in MySQl8.0 on macOS. I have try to stop mysqld with to way: kill this process from Activity Monitor, But It will restart immediately by itself. kill this with mysqlsadmin, but still faild. It ...
0
votes
1answer
437 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-...
0
votes
2answers
209 views

Failed Starting mysqld on centOS 6

I'm a newbie in Linux. I try to install and run MySQL but when I start it it's got failed and this is my logs : 180426 18:01:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql ...
0
votes
2answers
175 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 its not showing the same in CentOs 7. I am using mysql 5.7.21 on CentOs 7 example stated below and 5.7.19 on ...
0
votes
1answer
2k 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 ...
1
vote
0answers
388 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 ...
0
votes
1answer
208 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 | +----------------...
0
votes
1answer
1k 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....
1
vote
1answer
799 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 --------...
1
vote
1answer
809 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 ...
-1
votes
1answer
18 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 ...
3
votes
1answer
9k 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> ...
1
vote
0answers
120 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 ...
3
votes
1answer
669 views

mysqld not starting up

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:...
0
votes
2answers
1k 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 /...
2
votes
0answers
62 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 ...
1
vote
1answer
2k 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 ...
0
votes
1answer
137 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 ...
1
vote
2answers
115 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/...
-1
votes
1answer
2k 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/...
1
vote
2answers
36 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 ...
1
vote
4answers
1k 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 ?
1
vote
2answers
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 ...
3
votes
3answers
11k 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/...
5
votes
1answer
15k 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\...
2
votes
2answers
391 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=/...
4
votes
1answer
5k 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 ...
2
votes
2answers
1k 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 ...
4
votes
1answer
920 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 ...
5
votes
1answer
2k 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 ...
1
vote
1answer
78 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] ...
0
votes
0answers
28 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 ...
1
vote
1answer
1k 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 ...
1
vote
1answer
247 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 /...
1
vote
1answer
18k 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 ...
1
vote
1answer
1k 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 ...
0
votes
0answers
2k 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 ...
0
votes
1answer
3k 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 ...
4
votes
2answers
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 ...
1
vote
1answer
1k 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 ...
1
vote
2answers
3k 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 /...
3
votes
2answers
8k 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 ...
2
votes
1answer
8k 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 ...