Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL tmpdir parameter modification     - Linux performance monitoring and common commands Introduction (Linux)

- Debian GNU / Linux service list acquisition, shutting down services or run (Linux)

- How to Install Android Studio on Ubuntu 15.04 / CentOS7 (Linux)

- Nodejs complete installation instructions for Express (Linux)

- Linux system Iptables Firewall User Manual (Linux)

- Elasticsearch 2.20 Highlight (Server)

- CentOS modify yum update source (Linux)

- Linux / CentOS 7.0 installation and configuration under Tomcat 8.0 (Server)

- Hadoop 0.23 compile common errors (Server)

- How to install the client sqlplus under linux (Database)

- MongoDB uses aggregate, group, match mysql achieve in having (count (1)> 1) features (Database)

- ORA-12154 TNS could not resolve the specified identifier (Database)

- C # socket udp broadcast (Programming)

- To learn linux security (Linux)

- Ubuntu 12.04 kernel configuration automatically restart and crash dump (Linux)

- GoldenGate for Oracle data consistency initializing (Database)

- CentOS and RHEL to install IPython 0.11 (Linux)

- Ubuntu U disk do not have write privileges can only read but not write (Linux)

- Java input and output common class Scanner (Programming)

- Storm how to ensure that at least once semantics (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:      
 
- Check the Linux server performance with ten or so commands in a minute (Server)
- CentOS6.0 successful installation and configuration OpenCV (Linux)
- mysql_config_editor encryption and decryption of the new features of MySQL realization (Database)
- Novice Advanced Ubuntu7.10 configured IP address (Linux)
- Upgrading Oracle 11.2.0.1.0 to 11.2.0.3.0 (Database)
- Restore database fault encountered ORA-0600 (Database)
- Multi-core CPU, multi-threading and parallel computation (Linux)
- Java interface (Programming)
- RMAN backup file is much larger than the size of the database Cause Analysis (Database)
- How to disable IPv6 on Ubuntu, Linux Mint, Debian (Linux)
- 10 easy to use Linux utilities Recommended (Linux)
- Linux group account deletion, and other related operations (Linux)
- Cache implementation APP interacts with the server-side interface control Session (Server)
- OS X CAOpenGLLayer how to enable OpenGL 3.2 core profile (Programming)
- ORA-4031 error Solution (Database)
- grep, egrep and regular expressions (Linux)
- awk variables (Linux)
- Fedora 19/20 and Debian Jessie / Sid users to install FFmpeg 2.3.2 (Linux)
- Ubuntu 14.04 Fixed update information is outdated error (Linux)
- Select helps secure the system network management tools (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.