Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ MySQL tmpdir parameter modification     - iptables using summary (Linux)

- pga_aggregate_target and _pga_max_size can not use absolute limit actual PGA (Database)

- CentOS modify yum update source (Linux)

- Use Elasticsearch + Logstash + Kibana set up centralized log Practice Analysis Platform (Server)

- How to network to share files between Windows, MAC and Linux (Linux)

- How to install open source ITIL portal iTOP on CentOS 7 (Server)

- Linux Network Programming - libnet Guide (Programming)

- SVN common commands (Linux)

- MySQL stored procedures execute dynamic sql statement (Database)

- Installation and Configuration rsync server under CentOS 6.3 (Server)

- User and user group management Linux Command (Linux)

- Gentoo: !!! existing preserved libs problem (Linux)

- Partition and file system under Linux (Linux)

- Rails project prepared some tips small experience (Linux)

- Android first line of code study notes (Programming)

- To resolve Ubuntu 14.04 Unity Desktop Environment Login freeze problem (Linux)

- Eight sorting algorithm implemented in Python (Programming)

- To install the Git and Github under Ubuntu (Linux)

- Java singleton mode (Singleton mode) (Programming)

- Linux Firewall IPCop Profile (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)
- Linux System Getting Started Tutorial: Linux file permissions brief description (Linux)
- Use OpenSSL to generate a certificate detailed process (Linux)
- To create and manage virtual machines on Ubuntu Redhat (Linux)
- Crawl use Wireshark packet on remote Linux (Linux)
- Linux disk and File System Concepts (Linux)
- 10 practical Java programming technology (Programming)
- Math objects easily overlooked but very convenient method --JavaScript (Programming)
- Nine tips to protect the security of Linux desktop (Linux)
- These days have been tossing in the Linux under the ASP.NET 5, on the next in the other operating systems in the ASP.NET 5 or. NET applications, in order to complete the MS VM (CoreCLR) run is not far Reach, the effect of the application.

- CentOS 7.0 local address and configure yum source address priority (Linux)
- hexdump Linux command (Linux)
- JavaScript cross-browser event object library (Programming)
- Ubuntu Locale configuration problem solving Can not set LC_CTYPE (Linux)
- To compile and install MySQL 5.7.7 RC under CentOS 7.1 (Database)
- Install GAMIT / GLOBK 10.50 software under Ubuntu 14.04 (Linux)
- Improve the Ubuntu SSH login authentication approach speed (Linux)
- Nodejs complete installation instructions for Express (Linux)
- Formatting Java floating-point types (Programming)
- ethtool implementation framework and application in Linux (Linux)
- Why you can have JavaScript string method (Programming)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.