New answers tagged mysql
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 ...
- 24.3k
0
votes
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
- 121
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 ...
- 49k
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 ...
- 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.
...
- 173
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 ...
- 182
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 ('...
Top 50 recent answers are included