MySQL – myisamchk: error: myisam_sort_buffer_size is too small hatası

Ayhan ARDA

12 yıl önce

Büyük boyutlu myisam tablolar&inodot;n&inodot;z&inodot; repair ederken ba&scedil;l&inodot;kta belirtilen hatay&inodot; alabilirsiniz&period; Sebebi myisam sort buffer size de&gbreve;erine tak&inodot;lman&inodot;zd&inodot;r&period; Bunun için tablo repair i&scedil;lemlerinizi a&scedil;a&gbreve;&inodot;daki &scedil;ekilde yapabilirsiniz&period;&NewLine;root&commat;ayhanarda [/var/lib/mysql/ayhan&lowbar;testdb]&num; /etc/init&period;d/mysql stop &NewLine;Shutting down MySQL&&num;8230&semi; SUCCESS&excl; &NewLine;root&commat;ayhanarda [/var/lib/mysql/ayhan&lowbar;testdb]&num; myisamchk -r -q ayhan&lowbar;posts&period;MYI &&num;8211&semi;sort&lowbar;buffer&lowbar;size=3G &NewLine;&&num;8211&semi; check record delete-chain &NewLine;&&num;8211&semi; recovering (with sort) MyISAM-table &&num;8216&semi;ayhan&lowbar;posts&period;MYI&&num;8217&semi; &NewLine;Data records&colon; 0 &NewLine;&&num;8211&semi; Fixing index 1 &NewLine;&&num;8211&semi; Fixing index 2 &NewLine;&&num;8211&semi; Fixing index 3 &NewLine;&&num;8211&semi; Fixing index 4 &NewLine;&&num;8211&semi; Fixing index 5 &NewLine;&&num;8211&semi; Fixing index 6 &NewLine;&&num;8211&semi; Fixing index 7 &NewLine;Data records&colon; 720336 &NewLine;root&commat;ayhanarda [/var/lib/mysql/ayhan&lowbar;testdb]&num; /etc/init&period;d/mysql start &NewLine;Starting MySQL&&num;8230&semi; SUCCESS&excl;&NewLine;Ayhan ARDA&NewLine;Ayr&inodot;ca&semi; Mysql error &colon; Can’t create new tempfile&colon; &OpenCurlyQuote;&ast;&period;TMD file &scedil;eklinde bir hata al&inodot;rsan&inodot;z da ayn&inodot; çözümü kullanabilirsiniz&period;&NewLine;&NewLine;