ERROR 1238 (HY000): Variable 'innodb_buffer_pool_size' is a read only variable mysql> set @@global.thread_stack=262144; ERROR 1238 (HY000): Variable 'thread_stack' is a read only variable mysql> set @@global.binlog_cache_size=65536; Query OK, 0 rows affected (0.00 sec) mysql> set ...
-- 设置全局系统变量 set global sort_buffer_size=32M; set @@global.sort_buffer_size=32M; -- 设置会话系统变量 set session sort_buffer_size=32M; set @@session.sort_buffer_size=32M; set sort_buffer_size=32M; -- 查看全局系统变量值 select @@global.sort_buffer_size; show global variables li...
Training & Tutorials » Advanced MariaDB Articles » Development Articles » MariaDB Internals Documentation » Using MariaDB with Your Programs (API) » Error Codes » MariaDB Error Codes 1200 to 1299 » Error 1229: Variable is a GLOBAL variable and should be set with SET GLOBAL ...
1 row in set (0.00 sec) # 默认通用日志存放在文件中 mysql> SHOW GLOBAL VARIABLES LIKE 'log_output'; +---+---+ | Variable_name | Value | +---+---+ | log_output | FILE | +---+---+ 1 row in set (0.00 sec) # 通用日志存放的文件路径 mysql> select @@general_log_file; +...
MariaDB [(none)]> show global variables like 'log_error'; +---+---+ | Variable_name | Value | +---+---+ | log_error | /data/mysql/masterdns.err | +---+---+ 1. 2. 3. 4. 5. 6. log_warnings:是否记录警告日志 MariaDB [(none)]> select @@log_warnings...
MariaDB [(none)]> set global read_only=0; 2、在主库上新建数据库并创建数据 MariaDB [(none)]> show databases; MariaDB [(none)]> drop database t1; MariaDB [(none)]> create database t4; MariaDB [(none)]> show databases;
Referenced variables may be ones declared inside a stored program, global system variables, or user-defined variables. The SET statement in stored programs is implemented as part of the pre-existing SET syntax. This allows an extended syntax of SET a=x, b=y, ... where different variable ...
set GLOBAL SQL_SLAVE_SKIP_COUNTER=1; start slave 或者 stop slave; mysql> change master to master_host='192.168.202.99', master_user='user', master_password='pwd', master_port=3306, master_log_file='mysql-bin.000002', master_log_pos=514; ...
set{global|session}variable_name='value' 注意:无论是全局还是会话变量级别的动态变量修改,在重启mysql后都会失效,想永久生效,可以定义在配置文件中的相应段[mysqld] MariaDB中字符大小写 1.SQL关键字及函数不区分大小写 2.数据库、表及视图名称的大小写区分与否取决于底层OS和FS ...
set character_set_server=utf8; 5、查看编码修改结果 执行: show variables like 'character%'; 显示: +---+---+ | Variable_name | Value | +---+---+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_...