mysqld : Server Process for MySQL

learn more… | top users | synonyms

0
votes
1answer
15 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 ...
1
vote
1answer
66 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 ...
0
votes
0answers
46 views

Fresh install of TokuDB using MariaDB

After a recent server crash, I am unable to restart the mysql server daemon with the following errors: 2016-01-07 12:02:52 3263 [ERROR] Can't open shared library '/usr/lib/mysql/plugin/ha_tokudb.so' ...
2
votes
2answers
50 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] ...
0
votes
0answers
51 views

Mysqladmin shudown works, though mysql is still running. How is this possible?

I've had so many problems with this now that I'm hoping one of you knowledgeable folks will be able to help. Every time I install mysql and do a restart of the computer it doesn't let me connect: ...
2
votes
1answer
556 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 ...
0
votes
0answers
30 views

Mysql Cluster Don't save data on data node

I am using mysql cluster. This is my setup [ndbd(NDB)] 2 node(s) id=2 @192.168.64.236 (mysql-5.6.23 ndb-7.4.4, Nodegroup: 0, *) id=3 @192.168.64.235 (mysql-5.6.23 ndb-7.4.4, Nodegroup: 0) ...
1
vote
2answers
217 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 ...
0
votes
0answers
221 views

Cannot change datadir for mysqld

I'm currently using Windows 8.1 MySQL 5.6 community server I once had my own mysql server, and all the data is currently stored in E:\db\data, which was the data directory for previous db server. ...
2
votes
1answer
40 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 ...
2
votes
1answer
383 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
25 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
20 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
215 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
137 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 ...
0
votes
1answer
4k 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
809 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
1k 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
435 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 ...
3
votes
2answers
699 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
536 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
2k 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 ...
0
votes
0answers
661 views

MySQL is running but not working [closed]

In an attempt to tune MySQL to make it work with a recent installation of Drupal I had to modify the MySQL settings on my server. After modifying the configuration file for MySQL (/etc/my.cnf) MySQL ...
1
vote
1answer
4k 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 ...
1
vote
1answer
4k 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 ...