New answers tagged

0 votes

Ansible - community.mysql python module errors

You need to install one of the required modules on the target machine, where the action is executed. Quote from the documentation (highlight by me): Requires the mysql and mysqldump binaries on the ...
Gerald Schneider's user avatar
0 votes

Dovecot dict: Can't open configuration file, Permission denied

chown -R root:mail /etc/dovecot/
chemwile's user avatar
0 votes

Mysql filling all the buff/cache memory

The OS buffer/cache is what is being used. You can clear it with this command: echo "echo 3 > /proc/sys/vm/drop_caches" | sudo sh
doublespaces's user avatar
1 vote
Accepted

Slow MySQL inserts on one specific machine - what might be wrong with it?

It can be due to different fsync behavior on the two different machines. You can try to relax data persistence constrains to see if the slow machines suddenly become fast. If so, your issue is related ...
shodanshok's user avatar
2 votes

MySQL Update Statement taking long time to update small table with 4 rows

50 seconds sounds like lock_wait_timeout. This would imply that another connection has the row locked and is taking a long time. Perhaps a mysqldump is running? Or some big transaction? Also, this ...
Rick James's user avatar
  • 2,523
2 votes
Accepted

yum install mysql-devel causing openssl11-devel conflicts with 1:openssl-devel-1.0.2k-24.amzn2.0.10.x86_64

You can resolve the conflict by removing openssl-devel package by following command. yum remove {package name} Or you can use --skip-broken in the end of command, it will skip the conflicted package. ...
Shivam Ahuja's user avatar
0 votes

Mysql Export current configuration to a file

A summary of my.cnf In order to configure my own mysql-client programmatically, I was interested in the settings that mysql (rather than mysqld) was reading from the various my.cnf files. First, I ...
Martin Rüegg's user avatar
0 votes

Unable to login to my mySql server as root, and unable to reset root password

FOR AWS Linux systemctl stop mysqld systemctl set-environment MYSQLD_OPTS=--skip-grant-tables systemctl start mysqld mysql mysql> UPDATE mysql.user SET authentication_string = PASSWORD ('...
Pilot 777's user avatar

Top 50 recent answers are included