Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL tmpdir parameter modification     - Security Configuration SQL Server 2000 database tutorial (Linux)

- Use read command to read user input (Programming)

- Linux System Getting Started Learning: complete installation on Debian or Ubuntu kernel source (Linux)

- Implement Oracle dynamic registration of non-standard port 1521 (Database)

- Echo Command Examples (Linux)

- How to use the Vault secure password storage and API key (Linux)

- How SSHfs mount a remote file system on Linux (Linux)

- iptables using summary (Linux)

- Hadoop 1 and 2.x installation notes (Server)

- OpenvSwitch 2.1.2 shell script to start and stop (Linux)

- Java transient keyword (Programming)

- MySQL to recover the data through binlog (Database)

- How to use SHA256 checksum files download (Linux)

- Analysis of potential problems through custom Orabbix monitoring Oracle (Database)

- Simple Linux file system - df, du, ln (Linux)

- HDFS Hadoop Distributed File System Works (Server)

- Linux command in the dialog whiptail (Linux)

- Use LKM change the default linux security level (Linux)

- What is Java EE (Programming)

- To generate a certificate using OpenSSL under Linux (Server)

 
         
  MySQL tmpdir parameter modification
     
  Add Date : 2018-11-21      
         
         
         
  Today, I suddenly received a warning message that is / disk space usage exceeds a threshold. After a look and found there are many abnormal SQL, execution can not, cause has been processed to produce a temporary occupation of / tmp disk space.

Because the operating system / tmp space is limited, we need to modify the parameters, the value of the path tmpdir be modified.

mysql> show variables like 'tmpdir';
+ --------------- + ------- +
| Variable_name | Value |
+ --------------- + ------- +
| Tmpdir | / tmp |
+ --------------- + ------- +
1 row in set (0.00 sec)

mysql> set global tmpdir = '/Data/app/mysql5.6.25/mysqltmp';
ERROR 1238 (HY000): Variable 'tmpdir' is a read only variable

It can only be changed through the configuration file.
Restart mysql
mysql> show variables like 'tmpdir';
+ --------------- + -------------------------------- +
| Variable_name | Value |
+ --------------- + -------------------------------- +
| Tmpdir | /mysql5.6/var/tmp |
+ --------------- + -------------------------------- +
1 row in set (0.00 sec)
     
         
         
         
  More:      
 
- Linux Detailed instructions alias settings (Linux)
- C ++ constant definition (Programming)
- To install Redis under Linux (Database)
- Use ARChon runtime environment to run Android apps on Ubuntu (Linux)
- Heartbeat (v1, v2, pacemaker) cluster components Overview (Server)
- Oracle to use full-text indexing (Database)
- Learn about EditText little depth (Programming)
- Android imageView in the Src and Background (Programming)
- Check with Hello World Docker installation (Server)
- Linux can modify the maximum number of open files (Linux)
- Udev: Device Manager for Linux Fundamentals (Linux)
- Linux Network Programming - raw socket Example: sending a UDP packet (Programming)
- Java Set and List in the relationship and difference (Programming)
- Linux file system (inode and block) (Linux)
- Terminal multiplexing tool tmux use (Linux)
- Number JavaScript type system (Programming)
- Linux kernel modules related to the management Comments (Linux)
- Detailed LVM2 (Linux)
- 24 Docker recommendations (Linux)
- Share and show your code on GitHub (Linux)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.