daily_issues
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
daily_issues [2016/05/13 14:45] – [Reading Binlog] k2patel | daily_issues [2020/08/10 02:35] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 14: | Line 14: | ||
</ | </ | ||
+ | ===== Mysql Generate hash for password ===== | ||
+ | <code mysql> | ||
+ | SELECT PASSWORD(' | ||
+ | </ | ||
+ | OR | ||
+ | |||
+ | <code mysql> | ||
+ | SELECT OLD_PASSWORD(' | ||
+ | </ | ||
==== MySQL Cluster information gathering ==== | ==== MySQL Cluster information gathering ==== | ||
Line 142: | Line 151: | ||
I've started seeing following error in my log.\\ | I've started seeing following error in my log.\\ | ||
+ | <code text> | ||
+ | [ERROR] / | ||
+ | </ | ||
+ | |||
+ | It is caused by file discriptor limit set by the system.\\ | ||
+ | You can check that by changing your shell to mysql user and running following command. | ||
+ | |||
+ | <code bash> | ||
+ | ulimit -a | ||
+ | </ | ||
+ | |||
+ | In order to increase the open file limit.\\ | ||
+ | edit following file.\\ | ||
+ | |||
+ | <code bash / | ||
+ | mysql soft nofile | ||
+ | mysql hard nofile | ||
+ | </ | ||
+ | |||
+ | Now you can check mysql for limit seen by mysql.\\ | ||
+ | login to mysql as root and run following command.\\ | ||
+ | |||
+ | <code mysql> | ||
+ | show GLOBAL VARIABLES LIKE " | ||
+ | </ | ||
+ | |||
+ | Now you can modify it to increased limit in limits.conf.\\ | ||
+ | by editing following file. | ||
+ | |||
+ | <code bash / | ||
+ | [mysqld] | ||
+ | open-files-limit=49152 | ||
+ | |||
+ | [mysqld_safe] | ||
+ | open-files-limit=49152 | ||
+ | </ | ||
+ | |||
+ | restart mysql and check again it should represent new value. | ||
+ | |||
+ | ==== InnoDB: Unable to lock ./ibdata1, error: 11 ==== | ||
+ | |||
+ | I've stumble across this issue while running mariadb server in VM Guest.\\ | ||
+ | I believe this happens sometime when VDP is doing backup or machine is being migrated by DRS. | ||
+ | |||
+ | In my case, i've enable innodb per tables. So i've to clear lock from all files in subfolder.\\ | ||
+ | In order to fix the issue, following command usually fix the issue. | ||
+ | <code bash> | ||
+ | systemctl stop mariadb | ||
+ | cd / | ||
+ | for i in `find . -name ' | ||
+ | systemctl start mariadb | ||
+ | </ |
daily_issues.1463150750.txt.gz · Last modified: 2020/08/10 02:28 (external edit)