Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL tmpdir parameter modification     - Generic mechanism C11 standard (Programming)

- Oracle 11g partition maintenance (Nice) - Truncating And Partitions (Database)

- Oracle 11g users to create, authorize and import dmp file (Database)

- Linux, Google Test (GTest) test environment to build step (Linux)

- Linux (RHEL5) general optimization system security (Linux)

- Use smem visual display Linux memory usage (Linux)

- Spring WebSocket Comments (Programming)

- History and Statistics tuptime use tools to view Linux server system boot time (Server)

- Ubuntu 14.04.02 LTS startup items erroneous writing / dev / sda1 (win 7 loader) Repair (Linux)

- Share Java-based multithreading file case (Programming)

- Sublime Text 3 using summary (Linux)

- STL spatial Configurator (Programming)

- Present Situation and Development Trend of firewall products (Linux)

- Running the open-source Swift under Linux platform (Linux)

- Linux installed and tested the deployment of Kafka distributed cluster (Server)

- 3 ways to create a lightweight, durable system of Ubuntu Linux USB disk (Linux)

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

- Oriented C ++ test-driven development (Programming)

- Linux Operating System Security Study (Linux)

- CoreOS quick installation to get started on a PC (Linux)

 
         
  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:      
 
- Python KNN algorithm of actual realization (Programming)
- Linux installation and error under codeblocks exclude [Ubuntu 10.04] (Linux)
- Linux how to view the graphics models notebook (Linux)
- Start Linux ISO image directly from the hard disk (Linux)
- MySQL / MariaDB database master-slave replication (Database)
- SpringMVC garbage processing (Programming)
- Installation and use Docker under Ubuntu 14.04 (Linux)
- Snapshot DataGuard (Database)
- Spring inject a type of object to enumerate (Programming)
- OpenStack image production in the CentOS 6.2 (Linux)
- Observation network performance tools for Linux (Linux)
- Installation and configuration to compile MySQL 5.6.10 under CentOS 5.9 (Database)
- Teach you how to protect the security of Linux desktop (Linux)
- Installation of Theano + CUDA under Ubuntu (Linux)
- A key installation Gitlab 7 on RHEL6.4 and Setup Mail TX (Linux)
- Linux System Getting Started Tutorial: How to Force Change your password at next logon Linux (Linux)
- B-tree - ideas and implementation of C language code (Programming)
- Ubuntu Tutorial: How to Upgrade a New Linux Kernel 3.12.7 on Ubuntu (Linux)
- AngularJS asynchronous service testing and Mocking (Programming)
- Linux Tutorial ---- fundamentals of data traffic redirection (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.