mysqld : Server Process for MySQL

learn more… | top users | synonyms

1
vote
1answer
18 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
13 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
56 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 ...
0
votes
0answers
18 views

MySQL by default autostarts on Ubuntu Linux?

I installed MySQL server on Ubuntu Linux 14.04 LTS following instructions at https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu. The console ...
0
votes
0answers
19 views

high cpu load because high CPU time for sys [duplicate]

I am using MariaDB galera cluster with two nodes + one node for arbiter. My system has 24 core CPU. I am getting stuck with CPU bound. Sometimes, my system consume CPU time to 1000% and CPU load get ...
1
vote
1answer
59 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
224 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 ...
0
votes
1answer
495 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
704 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
160 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
387 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
263 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
1k 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
501 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
2k 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
3k 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 ...