Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL tmpdir parameter modification     - Ubuntu Live CD by updating Grub resume boot the Boot Menu (Linux)

- Linux kernel netpoll framework netconsole (Linux)

- How to use the DM-Crypt encryption Linux File System (Linux)

- Mac OS X Server installation and application (Linux)

- VMware 8 installation configuration Win7, CentOS-7 Wizard (Linux)

- Linux Network Programming - raw socket can do (Programming)

- Udev: Device Manager for Linux Fundamentals (Linux)

- Elaborate 10-point difference between the new and malloc (Programming)

- DRBD rapid installation and deployment (Server)

- Use JMS listener Oracle AQ, trigger the execution of Java programs in the database changes (Database)

- C ++ thread creates transmission parameters are changed (Programming)

- REDO LOG records management (Database)

- Ubuntu Tutorial: How to Upgrade a New Linux Kernel 3.12.7 on Ubuntu (Linux)

- Amazon EC2 server using Rsync + Inotify real-time synchronization (Server)

- How to statistical data of various size Redis (Database)

- Graphics of Java Tools (Programming)

- CentOS7 install and configure Nagios (Server)

- CentOS network configuration 7, and set the host name and IP-bound problems (Linux)

- Understanding the type in C ++ bitset (Programming)

- Oracle 11g Export guide problem not an empty table (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)
     
         
         
         
  More:      
 
- Installation and configuration under Linux SVN server - Backup - Recovery - Scheduled Tasks (Server)
- 20 Advanced Java interview questions summary (Programming)
- Profile Linux users login shell and login to read (Linux)
- Git uses a standard process (Linux)
- C # using the HttpClient Note: Preheat the long connection (Programming)
- Java proxy mode (Programming)
- PostgreSQL using the system cache to improve operational efficiency (Database)
- Hands to teach you to solve Ubuntu error message (Linux)
- Download Manager uGet 2.0 installed in Debian, Ubuntu, Linux Mint and Fedora (Linux)
- How to update the Linux kernel to improve system performance (Linux)
- About MongoDB query method according to fuzzy field (Database)
- Oracle Linux 6.4 (BOND) dual NIC teaming combat - Annotated (Linux)
- ORA-01839 error caused by incorrect system date setting (Database)
- PostgreSQL-- run Supervisord on Docker in Ubuntu (Database)
- C ++ overloaded stream insertion operator and the stream extraction operator (Programming)
- I like Linux Security (Linux)
- SSL VPN SSL VPN access to security websites patron (Linux)
- GAMIT baseline solution using batch were counted (Linux)
- bash login and welcome message: / etc / issue, / etc / motd (Linux)
- Zabbix using Omsa monitor hardware information of Dell server (Server)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.