Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL tmpdir parameter modification     - The ActiveMQ JMS installation and application examples for Linux (Linux)

- Linux desktop system using the remote server in clear text ssh password (Server)

- Intrusion prevention network server security maintenance tips (Linux)

- MySQL query plan key_len know all (Database)

- Ubuntu / Fedora / CentOS system how to install Plex Media Server 0.9.9 (Linux)

- FreeRadius installation process record (Linux)

- Linux Getting Started tutorial: GNU C and Vim will fight the C / C ++ IDE semi-automatic (Linux)

- How to use the Linux command compress JPEG images (Linux)

- Customize the output format in Linux history (Linux)

- Ubuntu How to install and upgrade Linux Kernel 3.15 (Linux)

- Solaris 10 nagios monitoring system (Linux)

- linux system optimization and security configuration (Linux)

- Samba public folder permissions (Server)

- How to upgrade to Oracle 11g Oracle 12c (Database)

- How to install Bugzilla 4.4 on Ubuntu / CentOS 6.x (Linux)

- Android Activity launchMode (Programming)

- Storm how to ensure that at least once semantics (Programming)

- Fedora 20 users install the Mate 1.8 desktop (Linux)

- CentOS 6.7 compile and install LAMP (Server)

- OpenStack / Dev stack with neutron on Ubuntu 14.04 (Server)

 
         
  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:      
 
- Android project using the command to create and install the package (Programming)
- PHP generates a random password several ways (Programming)
- After installing minimize RHEL / CentOS 7 need to do some things (Linux)
- Installation and configuration under Linux SVN server - Backup - Recovery - Scheduled Tasks (Server)
- Java generate two-dimensional code by Zxing (Programming)
- Let Ubuntu 14.04 Save screen luminance value (Linux)
- Oracle 10046 Event (Database)
- Ubuntu cut screen method (Linux)
- CentOS7 installation configuration (Server)
- CentOS 7.1 install NTFS-3G (Linux)
- Linux Beginner Guide: Installing packages on Ubuntu and Fedora (Linux)
- VirtualBox - Linux system virtual machine shared folders (Linux)
- Lucene Getting Started Tutorial (Server)
- Use py2exe to generate exe files Python script (Programming)
- OpenGL Superb Learning Notes - Fragment Shader (Programming)
- CentOS 6.5 installation and simple configuration Nginx (Server)
- Swift string common method (Programming)
- Linux System Getting Started Learning: Debian download, installation and graphical interface (Linux)
- Git use and interpretation of common commands (Linux)
- Java implementation of stacks and queues (Programming)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.