MySQL - 问题集 - "Got error 28 from storage engine"

时间:2023-03-09 01:04:34
MySQL - 问题集 - "Got error 28 from storage engine"

数据库的临时目录空间不够,修改配置文件中的tmpdir,指向一个硬盘空间很大的目录即可。

windows下,找到配置文件my.ini.

[mysqld]
tmpdir=D:/work/tool/mysql-5.6.28-winx64/temp

修改完毕重启。

附:查询当前临时目录

SHOW VARIABLES LIKE '%tmp%';

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAgEAAAB0CAIAAACT9HZtAAAaI0lEQVR4nO2d76sdRZrH60/ZBZ2d1QRM0mkYGBYEGQjzJoI7OhOb3DnujuCbIIiDykqkIdfDkMF5MQijruP1RWPMHHwRJBuiom6Sc6/5eUzILxjkSmDPvsgP97x3X1R39VNVT3VVn65zz73nfj88L87pU11P/f5WVfe9Jf75Z/8qbXRzHQaDwWDbygQ0AAaDwbatQQNgMBhs+1qtAX8FAACwDfiRoGnA/RhIH1GiAsAArQuAjng0YPXsyS52n/TS1bMnJ9+8BoPFMqN1wWCwtubXgLVzp5T9WwA0/Nq5U0Yv/b8Lb8BgsQwaAIN1NL8GfLN6WlmIBtDw36yeNjXg0pswWCyDBsBgHc2vARfWPlcmR/kfHchfafgLa58bvVRInvr3H0Z/vPTyP8hv6cuv/jD6Yws7sT8VPzveGObNx4R4bL99/fhT0qfndtiWML517c9Xz57826FH5Ledh95jm/5b++Xv+96adyeEweZofg24eP5LZSEaQMNfPP+l0Ut/ePvn6e8P/3D1z9Iu/f4ff/v2n9XXqPbCbx97yvXrm4/9/PhMnMI21Mx1wNF9dMT/26FHnjzq6QAv7oAGwLa1+TXg8oWvlYVoAA1/+cLXRi99cP3QkviX49fffXD93QfX313eVX6+9MpD5SRu1zMPyl8PLQkhxEPLf3kmFUJUdx3/lQxXR+K8fdcz6vrSX+rA1K95u3ho+b+0kA/MYA+lu8yQlneZciGEEL86tLyrDhzoCBZo1l5Q/iSZ16vxXa0JxI7njQ5ANeCt/dWy4Og+Gri+XTzy4rH5d1oYLKL5NeDKpTPKQjSAhr9y6YypATdXLr368NI7Kw9urjx453Hx9EsPbsrPLx2/uSJ/TV/9Q3nx5srxp4UQDy+fWnnwzuP0+vKux49Xnx23v7QkhNh1oPr88PKpFf72UwfSMpj+mbPjT4syzc2JP3UgFY8fv7myvEukr/6hTHwbR7AQs58H1HP/o/vkptDq2ZOrR3MlBsbWkLEOIF/zJ6UGHHt+p1IO+hkGWwjza8Do8jllIRpAw48unzN66f3bH90/fTB95pX7tz/6+JmfLJ/+6P7tj+7f/ujiaz9RU+f0tT/Ji0YYasu7nviYfOVuf2VJkDDvPkGjpbfTe4UQQvAerfS8srTroNN7lcfS0btPpK/9qZUjWJDZz4SPPb9zf7569uRb++s5O5nIm48HvBpA78VSALZ45teAq6M1ZSEaQMNfHa2ZGvD3T+7//ZOPf/1Py1+8vrT7Ofn1/hfPpeIXH8vP//mL9D/eLq+XIT9RX5Ut767CO29/fUmQMHq02u36T81G0lOln/X+xXPpr1+vHcnrbRzBgox7L+it/Y+8eKyaxZ89uXrs+Z1qg0h/YLAasg6wboHBFsn8GnDt6nllIRpAw1+7et7UgO8+vf/dp/ff35fu/unS+5+WX7/8XfqbN+Tn5d0iff298vp3n378m58uf/mp+qpsefe+j79rvv2NJVFHtbxbi0e7/bs3lgT92mQkPW8s7f6d03t1sXT0/r709fdaOYIFGftu6NF9O3eQp8HVymD17MkXd3jXAeU0/8Ud6nmA9owBBlsw82vA9WsXlYVoAA1//dpFo5fe+/6ze99/du/75SXxy2Pl58/uff/ZsQPlSnvvnkeFEEsrn937+oW9ZAW+9/BKdSPl0SNf87cf2SPEnheO7Am6/d7KL8lFLWHULh5+tApQxXNgmfNe/rr38IpMhox/aSXUESzQHH8fYI7a1WugYueOR4QQTx6VYbgdHvk0WIidh55/UpSvmaqLQgi8SwpbMPNrwI3rV5SF/I0YDX/j+hVTA+78NwwWy/A3YjBYR/NrwK0b3yoL0QAa/taNb41eevd/1mCwWAYNgME6ml8Dbt+61sVMDfjfK1vAVl/eKxgOFvNOGEw3aAAM1tH8GtAd1UsBiA5aFwAdadKAKHBTagCiEauhArBtgQaALYzrRTUAQAgnTpygX+PvBcmOOgYgNkoD1u/chcFg01mTBkQ57AkaAGYENAAG625NGmAc2xTybqh92BM0AMwIaAAM1t0aNUA/tilIA6zDnmwNKDIhRFY09+9hnlQbvkk+bDU0FJm8z+cCzIJhnmxUyVMNOFz9TbgQQuw5EqFvfHiQPnU48OHd9Tt3P3hW2BdhsC1tTRpgHNskR3nXgwX5q33YE7sOyBPPMDH0hvBhRhAeY3ffgWyYowXFXgcc3nPwg3h946vDe6tR/tgBsffwmbvrd+5+8Gz5Yf3OsQMipjsYbC7WqAH6sU1BGmAd9lRrQDU/F1mhBj92ul9fE0Ik+dgIWV2p1xMy5up6FQkZX5Vr7wqBCUkuZUWelEnNEyGSnOSpcbiqU58lCUmznSSazyFNU5JL58IqOprxKtokz1XxhK+p7JDDPBEiSRLrds6RvQJz3d5hmVcj73dpwFeH9wqxd0+5PigHbvbi+p2762fIP5c6U8dQz/Q/PLjn8IV1QwOiLDhgsLlakwYYxzaFaIB92JPsWHSLoKCDkxq/6Gd2ilwURR2wHDZIqCJr0AA+Rgd2yCrxeSKSfDgusiQf6ntaRdY4lpV3yIBqiOQyWcejb6oUWTVcqrjsAiG3SIlSP9cZ0UvJzCYXsk5ykZUfWEcVRq742wOT1EizBqzLrZtnj63fubv+4cHyA3+xnuavnzmyp5rdaxpw5sieZ4+t69tB2AuCLYA1aoB+bFOQBliHPcneMjSn5VmhTQaZeSIzDlvhNk4DsqKOs9YALU/NImDP+BlHeiRDI3t69HaBaPFVY2tDIdv5ZkMS12Uhs44UlgYwtwcmqZkADWDm7MzFao4vTQ39Dg2ge0GQAdiWt8a/D9CPbQrRAPuwpwYNaBg3zeGRTorJXXPWAH0TJmgkM6bAU2sAVyD80ByYMHfI6BrQIkmNbKgGMHtB5o0w2Fa0Rg3Qj20K0gDrsKd6L4iMZ9bugAmjAdX3ckOm/Fx+9O5IkKGKbsc4fBshnesAoQ1vzmGNZJPfBlFJ0nSFZoHRALtAjA2cOvJA9eNDMoM474hJNn97iyQ1EU0D9J19FQnVAHUX1YAPnsU6ALblrVED9GObgjTAOuyp1AB9OyRRQ7b2aFQJg7ZPUI818kKSCKE9WxDak0njYWs9dNYx+CahesjyW5IPS6UpHwQUWZLXuxpNYxqTSVeSmC0vfevEeFJsFAh59pzVcuL0709pFWFW6E98OUdMybtub5EkN/LmHx3vhn51WP7714Mf3KmO+Xn2GHuRBBZCiHJqr78bKqyHAeoiDLalrUkDjGObQjTAPuxJdpap+vgmx9x92lxsgzdcqQbAYLDprFED9GObQv5GzD7saVE1oJ4Hb6pX/Ov5dZQt903gyA00AAbrbk0aYBzbFKIB9mFPm1QDrHdTIgzos4hzFmyVdPqABsBg3a1RA2Ic9rRJNQBsfaABMFh326D/HQ3AjIAGwGBdrEkDcIYM2PycAAB0Y7Ya8Ff9oDIAImI0XwBAW5o0IMpekNSACQAzQDbfeacCgC2MRwNWz57sYtAAMFOgAQB0xKMBa+dOKQt5N5SGXzt3ChoAZgo0AICOeDTgm9XTykI0gIb/ZvX0AmtAPxUi7dvXBz35qLI32Pg0bT+oBlQln/ZH6vfqmnYRAFDj0YALa58rk6O868GC/JWGv7D2+cw1YNRPow+2oXEOepwGSGaQLMCgNGDQq2R30FP620+rj4MeK9gAAI8GXDz/pbIQDaDhL57/UmlAT73K1xv003peNuqnaqJWpqicuvUG5BPPoI61CjdgHck5u/qtaXhm4nSkczLopX113YjT0ID6djohra/2UmjGVDB7QUQDtKvQAAA4PBpw+cLXykI0gIa/fOHreh0wKudk/VSk/ZEcPyeTyWQwkP111E/V6Djqp3Ko5bszxZ6z844GvXqcHvSadwbYdQCTzkGvlgQzTi2KUT9VAxD5rMqATGJBOzQNKDWVKclZLBcBWAw8GnDl0hllIRpAw1+5dEbTgN5gogbHavwjE2RtEHV3Zx1WAxhHuprUo29YnHw6m+KkUdB7zQjM9QZoR8g6QE0pAAA2Hg0YXT6nLEQDaPjR5XMeDRjVG7bGGDroiTRNY2oAHQXaagCfzlAN8Lib6AsF0Ab2vSBa+IMe/+geACDxaMDV0ZqyEA2g4a+O1vwaQB7fqYFSbY3490jq0bMK61wH0Ph9e0GOOPV0anGSrazJxHwewO5pkYvQgGmpNIDsxZHHv/0UKywAPHg04NrV88pCNICGv3b1vPFMuHyGmvbV/nz97l6ayivVzkn9Y/MkWn/7b+BwNOil/XpLxjcu2G8U2umU8ZNHxdb+jvOyen/FvATaUq8DRlZVmHtwKGMAGDwacP3aRWUhGkDDX792cdP8fQBeC1lM8DdiAHTEowE3rl9RFvI3YjT8jetXNokG1O9gYiq4WEADAOiIRwNu3fhWWYgG0PC3bnwbRwOsF2siDOiziBNsONAAADri0YDbt651sU2yDgCLCjQAgI7gf0eDLQw0AICObMQZMl0PuQEAADAzZq4BrleJAOiI0XwBAG1p0oCIe0FjAGaAbL7zTgUAWxiPBsQ6R2ze2QSLCTQAgI54NCDWOWLzziZYTKABAHTEowGxzhFzuS8y+V5+Vsw4n7EcFdlGpJZxNMyTDfG7tSg1oKpdfx0P8yTJY6eCaxQzccQ149k4CvXuYJgnqjqSfOiNuQreHFZVMw1WXZy6EDr3LDbxwzypC2oD62gKPBoQ6xyx5kTkyQaNblEceSIZRsvNhhXL1kWtA0ipF1njUFJkM9BSrtJ5RzGahxHFTHIU7J1lmCchQ38VYahOlI6LTI34Ku+tPEbEkfgiS3JaULNrDN3xaECsc8TGYzo3yBI960ZJ1AHLmtaknk5GyHQjqAGYRU49DZlrdUg1BcmKpnrTJ6QiK7RLWZEnpa88ESLJSaxNjrj5l7yW5DLK7bpE4DRAdsCyOmVtms1Lm5RVJTkkN8g7mObhKPbKfVlTMn579sc0D+pUb8bsxfF4zDZjJkdmk1Npp/nQHZGOWfe5oWyrTu8cLUZkUlnBFFmtAaTinOlyVrHds2RuE2NqX4bLCvKpIfEyLVqCghuDNaa1HEDa49GAWOeIacVVZEaazdoriqIut6EdpvxMizVstaU7IhNGuh60vQ+1KYinwO22WN1eThnKgqAxVSlpdGS38SKru/dcJkFzh9cA8oXRALu0jO91BXHNgy32oWqSGRMThRmqWEdO72O+JeiO+CanBVOfmY5JPNrlF6gBttI5QmZZlrQayMy6diilBl/FJfa6qq4E2pCqOSjRbi7x1VhkRRvQGNgxLXwAmQqPBsQ6R6wqWr5ZONcBtGKtNkuD+RuB7UivE1UdtvehcdsUGpAVtfe6Cs3ENDvy9/zth1cDeIwA8mvVp1T9sM1j7O7MxnyZT4l9hXXk9j5mR2E2R2aT01s5yY/RMVu0Q7MT2g3S01/ISBa0p6XG4uqrEl0yd7OTxFYxmyOt7OsFRx2xXjR24tXtzHLN1xj4MS14APEVHo9HA2KdI2bmXO8qVquqF6QkY2We6cZv22z7NYDzPisN0PeaoAFT4N0LcqEHKbIkH+ZJlsuhXB83x+NxiAY4JrLMDH0WGmDc4dKA8VgubnmVVB2zyFq1w2aaw9MZrLfeisxUWa1amv3YVexIoUsDikwkSWJogJ14bRjXU9u2MRjBvAOIO/tNeDQg1jli5rKqWQOqb8bzlmGeZBmjCuGYe0H2Lifr3Zw0+TSAPMYodYWXcasBNTqCBtiwGkCLhd0LkoH0zpwlSZIPx3m9Jc41Dyv+2o2cZtobkkYjtZsH78jp3f7KOHJrwLjIkjwnkXMds2U75JJCNrKsqbS56q8397W1nBGSvmhDPAVqAFvFfI5YDSC1pT/I4RLPRlvG4m0MdibDB5Cp8GhArHPEtAWnIDNtbiFZvwKWGO3AKiA2VgbeEbvpxHqny+XEXvI7nJEnceTZWrmAlG8ONJSIcsQlfmjMNrapFLDvhpqv1DpaBn1sqXYY6CMopnnwxV5vMbAN0Xg+ar/hyLZD7iLfjC1HriangtE7+S6kt0OrE3gbnWObnq0O8kzaXXHmLgnXYRqliatiJkeVH6067YtMNRk6UkVpJMPbGKwKaTeATIFHA2KdIzZ1+hYXfSkHpqLT34ht2DuVm8xR3M0c0I5ojSHaAOLRgFjniEVJ6yLBzx5AS/B3wm0InjPbd2C+ssmIOIB4NCDWOWIxch2A9Vh9VuPshjkCjUADAOiIRwNinSM272yCxQQaAEBH8L+jwRYGGgBARzbiDJlZH4IDAABgamauAa5XiQDoiNF8AQBtadKAiHtB8z42GSwmJ3CmPADd8GhArHPE5p1NsJhAAwDoiEcDYp0jNu9sgsUEGgBARzwaEOscsflmsp8Kkfbt64OefK2/N4jrb9RPo8cJOIgGyMpkir2fylpO+6NJXedazYdfpNdlhPSi1zsAmw6PBsQ6R2wymUxG/TT6wBga56DHaYBkBskCG4TSAKm6dlX2U2P0JS2hbjzhFye1vA96amIR7B2ATYdHA2KdI2ZMqkRvoM2zeoN+Ws6V5Jxd/dY0PDNxTiZyFl7NveqgaV9dN+I0um59u7f/1kF7aWrMHrU4tZRWqWrhCDgw9oLMUXjQayhZdv4QftGeWLTyDsAmwaMBsc4Rm0y4nlTtmZTTpbLPDHraeryxH7G9czAYVD9WNw969eBrxqlFMeqndPbnXj1MaB8f9IxB30iWClmnt40j4KJZA0b9Xq/HC78duO1Fu+m18g7AJsGjAbHOEZtMHBrQG0xU56k1gIRrnkxxGkDm14IM0s44aRT0Xv8MXVvJaL+4Rg1uEYClwPQ0awCZTegNYNJ1FUCrchrvAGwaPBoQ6xyxyaSNBtDe1VYD6PNYbaIepAFTrt+tiTwzbJDt4+kdAR2vBqhCNsubLf+wi4Me/4pBC+8AbBo8GhDrHLHJhA6U1daJcx0Q3HnccU60J3JanPUWUfmVdt3wKRsJ6dUAsllU/YS5YQQ8zwNIvQx6/O7cpOXFfurc2Qn3DsDmwaMBsc4Rk870t+rKb+XD2rRfLZ4HvbRf75T4+o79pl59JU1lBDJ+8qh4pAdsuNzgng3Hx6lv/LBhMUZMA30viC1M8tjelAArsoCL5hae0vVW3gHYRHg0INY5Ym2S1PQeJwAU/I0YAB3xaECsc8TCE4SZEwgHGgBARzwaEOscsU5ptN6h2VCRmK930Ag0AICOeDQg1jli884mWEygAQB0BP87GmxhoAEAdGQjzpDpesgNAACAmTFzDXC9SgRAR4zmCwBoS5MGRNwLmvexyWAxOYEz5QHohkcDYp0jNu9sgsUEGgBARzwaEOscsXlnEywm0AAAOuLRgFjniEVMcZEJIbJCfR/mCf0KthOlBhQZ/dON0NZQZJEajtkkZ+ZIZdQRXTxH03gnDPNEVUeSD70xV8Gbw6pqpsGqi0kelAc+rZ1KjU38ME/4gppxHU2BRwNinSM2Ho/HwzyJlPloEYEtjloHkMZVZEHDzjhPgoIF0di2NUcxeoEripg5au+dMmyTlDwJ1YnScZGpEV+NqK08RsSR+CJLcragojeG7ng0INY5YsZMTWTFmF7KijwphTRPhEhy9VtdROSSKjluYiKvJbmMcrNpLogKpwGyA5b9TE5ImUZQT8eqBjMkN8jf6tmsis/Ruir3ZYOkc1I672N6AXWqzyXZi+Px2DUKmzkye5ZKO82H7ihLqJJWvmWX9HjXaTEik8oKpshqDSAV50yXs4rtAUTmNjGm9mW4rCCfGhIv08IkKKAxkCWUjLvlONkejwbEOkesLhijqERWKC0tC5SurKs53VCbBBhZtsu6yOp2P5fZAdgYeA0gX1waoLULo5HU7ZCOGsZsRG9dlcdhnhnNzWyAzFDFOnJ6HztGYc0R37O0MOpzfbHIiPiVLuzyC9QAW+kcIbMsS1oNZGZdO5RSg6/iEiNHqhjokD3MEymEdBjnEz/MkyS3o7VTwQ+JSm7V5/Bxcio8GhDrHDFnhrOiLqw6byRckSX5UL/V3FHzlzVYULwawGMEkF+rPqWaIW1D9A6mdQ3zRM7RjF1pd5uvYR25vY/ZUZjNkdmzSDA9P8Z43aK70cGeH4g9+99kJAvaKVdjcfVViW5RFO4ksVXM5kgr+3rBUUesF42deHW7WU0BjcFMO018wDjpKzwejwbEOkesuQjMvOlLaWgAcOHdC2Kxfi+yJB/mSZbLoVwfN8fjcYgGcBNZl1o0BJpOA1wTTDsvcpOGV0k18SyyVt2tmebwdAbr7bZFZqqsVi3NfuwqdqTQpQFFJpIkMTTATrw2jGu3t24MRjDvOOnOfhMeDYh1jliZkzLR1WLLqW9WyZrTFmgAGI8dGkBrn9kLosvtsbolS5IkH47zektc62MeiVHTTBoz54jpBbwjp3f7K+PIrQHjIkvynESu73eozYc23c1C38iyptKu6qCjuB2SfdGG3NKsAWwV8zliNYDUlv4gh0s8E214Y7AzGT5OToVHA2KdI1aXY73CUc/PqodO5cpKPlI3dxPpgjUpF93GUxX15KBpaQoWCfbdUPPNYeudAXusUDsM9GEm84Ij37rqLQbq37W1Yb/hyL5JyV3kGjzjyNWzyp/1V1m0ONn9oUTJEuedx7FNzz6eIc+k3RVn7pJw44Jv/8+qYiZHlR+tOu2LTDUZOlJFqb4HNgarQtqNk1Pg0YBY54i1SZK+xgHATeu/EWOnY7NgEzuKu5kD/MykMUQbJz0aEOscsfAE8bIKAAf+TrgNwXNm+w5MyzYZEcdJjwbEOkcsRq4BMIEGANARjwbEOkds3tkEiwk0AICO4H9Hgy0MNACAjmzEGTKzPgQHAADA1PAa4Hr/BwAAwKICDQAAgO0LNAAAALYv0AAAANi+QAMAAGD78v9MSrGjBF6z+wAAAABJRU5ErkJggg==" alt="" />

default_tmp_storage_engine

The default storage engine for TEMPORARY tables (created with CREATE TEMPORARY TABLE). To set the storage engine for permanent tables, set the default_storage_engine system variable.

If you disable the default storage engine at server startup, you must set the default engine for both permanent and TEMPORARY tables to a different engine or the server will not start.It was added in MySQL 5.6.3.

控制  CREATE TEMPORARY TABLE 创建的临时表的引擎类型.

max_tmp_tables

This variable is unused. It is deprecated as of MySQL 5.6.7 and will be removed in a future MySQL release.

slave_load_tmpdir

The name of the directory where the slave creates temporary files for replicating LOAD DATA INFILE statements.

tmp_table_size

The maximum size of internal in-memory temporary tables. This variable does not apply to user-created MEMORY tables.

tmpdir

The directory used for temporary files and temporary tables. This variable can be set to a list of several paths that are used in round-robin fashion. Paths should be separated by colon characters (:) on Unix and semicolon characters (;) on Windows.