Questions tagged [mysqld]

mysqld : Server Process for MySQL

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

MySQL Group Replication - Member won't join after clone, access denied for for user mysql_innodb_cluster

I have a problem with a MySQL group replication cluster member not joining the cluster group after cloning operation. Question: How do I get the failed member to join the group again and be able to ...
0
votes
0answers
142 views

Get mariadb to listen to local connection at 127.0.0.1

I'm trying to get mysql (mariadb) on Ubuntu to listen for local connections at 127.0.0.1, so that the following line works: mysql --host=127.0.0.1 --user=root -p. At the moment this line returns this ...
3
votes
3answers
305 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, ...
0
votes
1answer
512 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-...
1
vote
2answers
230 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 ...
1
vote
1answer
4k 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
540 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
368 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 | +----------------...
1
vote
1answer
2k 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
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 --------...
1
vote
1answer
1k 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
29 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
11k 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
191 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
1k 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
73 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
3k 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
322 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
136 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
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/...
1
vote
2answers
40 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
2k 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
15k 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
19k 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
424 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
6k 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
2k 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
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 ...
1
vote
1answer
95 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
30 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
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 ...
1
vote
1answer
257 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
22k 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 ...
2
votes
1answer
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 ...
0
votes
0answers
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 ...
0
votes
1answer
4k 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
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 ...
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
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 ...
2
votes
1answer
9k 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 ...