Questions tagged [mysqld]
mysqld : Server Process for MySQL
46
questions
0
votes
0
answers
19
views
mysqld --initialize not starting MySQL5.7 on Ubuntu 20.04
Recent crash (RAID controller cache failure) made me re-create the MySQL system databases and tables for some were missing. I run MySQL 5.7 on Ubuntu 20.04.
2023-03-10T19:06:19.363955Z 0 [ERROR] --...
- 11
-2
votes
1
answer
539
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/...
0
votes
5
answers
378
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 ...
1
vote
0
answers
231
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 ...
- 11
0
votes
1
answer
4k
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 ...
- 1
5
votes
3
answers
4k
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, ...
- 171
0
votes
1
answer
585
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-...
- 121
1
vote
2
answers
300
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 ...
- 409
1
vote
1
answer
6k
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 ...
- 13
1
vote
0
answers
636
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 ...
- 11
0
votes
1
answer
611
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 |
+----------------...
- 103
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....
- 11
3
votes
1
answer
2k
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
--------...
- 31
2
votes
1
answer
3k
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 ...
- 121
-1
votes
1
answer
83
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 ...
- 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> ...
- 133
1
vote
0
answers
355
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
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:...
- 31
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 /...
- 165
2
votes
0
answers
109
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 ...
- 21
1
vote
1
answer
5k
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 ...
- 11
0
votes
1
answer
513
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 ...
- 123
1
vote
2
answers
185
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/...
- 136
-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/...
- 101
1
vote
2
answers
62
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
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 ?
- 321
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 ...
- 11
4
votes
3
answers
19k
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/...
user93897
5
votes
1
answer
24k
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\...
- 317
2
votes
2
answers
455
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
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 ...
- 143
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
...
user68337
5
votes
1
answer
5k
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 ...
- 153
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 ...
- 151
1
vote
1
answer
116
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] ...
- 26
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 ...
- 439
1
vote
1
answer
336
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 /...
- 115
2
votes
1
answer
29k
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 ...
- 141
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 ...
- 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 ...
- 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 ...
- 123
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 ...
- 321
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 ...
- 11
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 /...
- 11
3
votes
2
answers
10k
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 ...
- 151
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 ...
- 1,387