Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ MySQL tmpdir parameter modification     - Use Swift remove the spaces in the string (Programming)

- Linux Security and Optimization (Linux)

- How to view information about the installed version of CentOS (Linux)

- MNIST presentation and database conversion (Database)

- Install Ubuntu 14.04 and Windows 8 / 8.1 dual-boot in UEFI mode (Linux)

- RHEL7.0 log system (Linux)

- [SHELL] MySQL primary recovery solution from + Keepalived online (Server)

- An example of troubleshooting of embedded Linux OpenWRT (Linux)

- To compile and install Clang 3.5.0 in Linux CentOS (Linux)

- Linux process or thread is bound to a CPU (Programming)

- Error: Unable to establish connection with FTP SFTP server (Server)

- SendMail version of Java implementation with attachments (Programming)

- CentOS yum install LNMP PHP5.4 version (Server)

- Use small network command to check whether PC Security (Linux)

- When should I use Angular 2 (Programming)

- How to install CentOS 7.x in OpenERP (Odoo) (Linux)

- Using Ruby to build a simple HTTP service and sass environment (Server)

- iOS in Singleton (Programming)

- ElasticSearch - Basic Concepts (Server)

- Install Jetty on CentOS / RHEL 6.X (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)
- Linux source code to install Apache and solutions to common errors (Server)
- RHEL 6.5 x86_64 CentOS yum configuration source (Linux)
- Linux configuration Samba server (Server)
- Eclipse distributed management using GitHub project development (Linux)
- Use the dd command to the hard disk I / O performance test (Linux)
- Linux maximum number of threads and limit the number of queries the current thread (Linux)
- Explore Android SQLite3 multithreading (Programming)
- How to use the Docker Machine cluster deployment Swarm (Server)
- GAMIT10.5 install and update failed Solution (Linux)
- AFNetworking + Nginx HTTPS communication server + (Server)
- Using iptables achieve NAT (Linux)
- IntelliJ IDEA common list of shortcuts (Linux)
- Hutchison DG standby database CPU consumption reached bottleneck repair (Database)
- Sublime Text 3 (Linux)
- Ubuntu program using the Sound Recorder (Linux)
- Set multiple IP addresses for a single network card on Ubuntu 15.10 (Linux)
- Execute command sentence can result in equipment permanently bricked in Linux laptop (Linux)
- The development environment to build Nodejs under Ubuntu 14.04 (Linux)
- CentOS 7 - use cgroups limit process resource (Linux)
- TWiki LDAP error appears the problem is solved (Linux)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.