Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL tmpdir parameter modification     - Gentoo: startx appeared Failed to load module Problem Solving (Linux)

- Eclipse Android development environment installation (Linux)

- Analysis of memory mapping process in Linux x86-64 mode (Linux)

- Linux --- manual release system cache (Linux)

- Ten minutes to find out the character set and character encoding (Linux)

- Using Oracle for Oracle GoldenGate to achieve a one-way data synchronization (Database)

- Linux itself disguised illusion strengthen security (Linux)

- Mounting kit under Fedora Linux (Linux)

- Teamviewer not start in Linux (Linux)

- Linux serial debugging tools xgcom install (Linux)

- MySQL to manage multiple instances of method (Database)

- How to install and use the malware detection tool LMD and ClamAV antivirus engine on Linux (Linux)

- On Android running ClojureScript (Linux)

- Fatal: unable to connect to github.com problem solving (Linux)

- Docker commonly used commands Description (Linux)

- Oracle 12c of the auto-increment Identity Columns (Database)

- General Linux interface server parameter tuning (Server)

- CentOS 6.5 install Firefox (Linux)

- Linux, MySQL / MariaDB Galera Cluster Setup Process (Database)

- Configuring Allatori code confusion when developing general Java applications in NetBeans (Programming)

 
         
  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:      
 
- Shell script to delete empty folders recursively (Linux)
- Linux resource restriction level summary (Linux)
- How to create a someone project on github (Linux)
- Java deserialization test (Programming)
- Android to determine whether the device to open WIFI, GPRS data connection (Programming)
- Linux environmental performance data acquisition system (Linux)
- KVM virtualization nested configuration (Server)
- Red Hat Linux security settings document (Linux)
- Oracle 12CIN-memory in table spaces (Database)
- Two strokes to improve development productivity Struts2 (Programming)
- Those things packaged using Gradle to Android (Programming)
- OpenGL Superb Learning Notes - Depth Texture and Shadows (Programming)
- Oracle database, some basic grammatical structures (Database)
- Using the Linux VNC service (Server)
- Linux shared libraries .so file name and Dynamic Link (Linux)
- Oracle Linux 7.1 install Oracle 12C RAC (Database)
- To help you easily protect the Linux System (Linux)
- MySQL master-slave database configuration and error handling Raiders (Database)
- VMware6 achieve nat Internet (Linux)
- Install VLC player on Ubuntu 14.10 (Linux)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.