Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ MySQL tmpdir parameter modification     - Create a DLL using MinGW and Attention (Programming)

- Summarize small problems encountered in the use Lua (Programming)

- Linux system firewall defense network attacks (Linux)

- OpenCV 3.0 + Python 2.7 installation and testing under Ubuntu 14.04 (Linux)

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

- Revive Adserver ad server installation on Ubuntu 15.04 / CentOS7 (Server)

- Linux installation and error under codeblocks exclude [Ubuntu 10.04] (Linux)

- GRUB and Linux system repair (Linux)

- Memcached installation, configuration and monitoring (Server)

- Install Open vSwitch under CentOS 6.5 (Linux)

- CentOS install Memcached (Server)

- Redis master-slave replication switch (Database)

- JavaScript basic tools list (Programming)

- top command causes the system load increases (Linux)

- Hadoop safe hftp (Server)

- PostgreSQL Select source code analysis (Database)

- CentOS 7 How to connect to a wireless network (Linux)

- ORA-04031 error appears in the solution run utlrp.sql (Database)

- Seven Steps to Help Google Chrome Speed - (Linux)

- Oracle Linux 6.4 installed Oracle 11gR2 + RAC + ASM (Database)

  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)
- Java memory model subclasses (Programming)
- jdbc Oracle database connection string writing pluggable (Database)
- Ubuntu program using the Sound Recorder (Linux)
- Linux Samba server-side structures and the use of the client (Server)
- Linux RPM (Linux)
- The difference between Objective-C language nil, Nil, NULL, NSNull (Programming)
- RHEL6.5 replace local YUM source (Linux)
- Linux find command usage summary (Linux)
- Hibernate Search and Lucene quick introduction (Linux)
- Use Python automatically cleared Android Engineering excess resources (Programming)
- Hive handle count distinct inclination to produce data processing (Database)
- Add a custom encryption algorithm in OpenSSL (Linux)
- Android imageView in the Src and Background (Programming)
- Let the terminal under Mac OS X as like Linux has displayed a variety of colors (Linux)
- How to make a U disk to install Ubuntu (Linux)
- In-depth understanding of PHP ini configuration (Server)
- CentOS 6 rapid deployment of Java applications (Linux)
- To_explore Linux system boot process (Linux)
- To create a Linux server network security (Linux)
- Everyone should know something about TCP (Linux)
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.