错误1238 (HY000): Variable 'tmpdir' is a read only variable 表示尝试动态修改 MySQL 的 tmpdir 参数时遇到了问题,因为该参数是只读的。 在MySQL 中,tmpdir 参数用于指定临时文件的存储路径。这个参数通常是静态的,意味着它不能在运行时通过 SET 命令动态修改。如果你尝试使用 SET GLOBAL tmpdir = '/new/path...
tmpdir Yes Yes Yes Global No transaction_alloc_block_size Yes Yes Yes Both Yes transaction_allow_batching Yes Session Yes transaction_isolation Yes Yes Both Yes - Variable: tx_isolation Yes Both Yes transaction_prealloc_size Yes Yes Yes Both Yes transaction_read_only Yes Yes Both Yes - Variab...
innodb_tmpdir Section 17.14, “InnoDB Startup Options and System Variables” Section 17.12.7, “Online DDL Failure Conditions” Section 17.12.3, “Online DDL Space Requirements” Section 17.6.5, “Redo Log”innodb_trx_purge_view_update_only_debug Section 17.14, “InnoDB Startup Options and ...
If a server option set on the command line or in an option file differs from the name of the corresponding system variable, the variable name is noted immediately below the corresponding option. The scope of the variable (Var Scope) is Global, Session, or both. Please see the corresponding ...
D2D - DImage Tests - TestBitmapAlphaOnly D2D - DImage Tests - TestBitmapRenderTarget D2D - DImage Tests - TestBitmapShaderResource D2D - DImage Tests - TestDrawFrameOne D2D - DImage Tests - TestDrawFrameZero D2D - DImage Tests - TestDrawInvalidTmpDir D2D - DImage Tests - TestDrawNoImage...
tmpdir Yes Yes Yes Global No transaction_alloc_block_size Yes Yes Yes Both Yes transaction_allow_batching Yes Session Yes transaction_isolation Yes Yes Yes Both Yes transaction_prealloc_size Yes Yes Yes Both Yes transaction_read_only Yes Yes Yes Both Yes transaction_write_set_extraction Yes Yes...
TMPDIR=directory Place temporary files created and used by the shell in directory. auto_resume=list Enables the use of simple strings for resuming stopped jobs. With a value of exact, the string must match a command name exactly. With a value of substring, it can match a substring of the...
READLINE_LINE REPLY TIMEFORMAT TMOUT TMPDIR histchars RefrEnv was created to respond to this Stackoverflow thread:https://stackoverflow.com/questions/171588/is-there-a-command-to-refresh-environment-variables-from-the-command-prompt-in-w
direct' GOROOT='/usr/local/go1.22.1.linux-amd64' GOSUMDB='sum.golang.org' GOTMPDIR='' GOTOOLCHAIN='auto' GOTOOLDIR='/usr/local/go1.22.1.linux-amd64/pkg/tool/linux_amd64' GOVCS='' GOVERSION='go1.22.1' GCCGO='gccgo' GOAMD64='v1' AR='ar' CC='gcc' CXX='g++' CGO_ENABLED...
Section C.5.2.12, “The table is full” Section 7.4.3.3, “How MySQL Uses Internal Temporary Tables” Section 7.11.4.1, “How MySQL Uses Memory” Section 5.1.6, “Server Status Variables” Section 5.1.4, “Server System Variables” tmpdir Section C.5.2.13, “Can't create/write to file...