Skip to content

Instantly share code, notes, and snippets.

@sakama

sakama/mysql_cluster_error.sh

Last active May 10, 2019 08:45
Show Gist options
  • Save sakama/5330101 to your computer and use it in GitHub Desktop.
Save sakama/5330101 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Clusterでエラーが出た場合の対処
Raw
mysql_cluster_error.sh
ERROR 1297 (HY000) at line 1207: Got temporary error 410 'REDO log files overloaded (decrease TimeBetweenLocalCheckpoints or increase NoOfFragmentLogFiles)' from NDBCLUSTER
#NoOfFragmentLogFiles=4にしていたのをNoOfFragmentLogFiles=16(デフォルト値)に戻した
ERROR 1114 (HY000) at line 1213: The table 'sample_table' is full
#→通常のMySQLでも出るが一旦以下のようにして回避
#innodb_data_file_path=ibdata1:10M:autoextend→ダメだった
#config.iniの[NDBD_DEFAULT]セクション内のDataMemory、IndexMemoryを増やす必要がある
#IndexMemory=100M
#DataMemory=1024M
#※本来はndb_size.pl(http://dev.mysql.com/doc/refman/5.1/ja/mysql-cluster-utilities-ndb-size.html)や
#sizer(https://github.com/severalnines/sizer)で適正な数値を探る方が良さそう
ERROR 1297 (HY000) at line 1821: Got temporary error 233 'Out of operation records in transaction coordinator (increase MaxNoOfConcurrentOperations)' from NDBCLUSTER
#デフォルト32Kを1Mにした
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment