Shulou(Shulou.com)06/01 Report--

The size limit of individual files is determined by the operating system. File size can be more than 4GB on operating systems that support large files. Use of raw disk partitions for global temporary tablespace data files is not supported. Description: the temporary file size of the temporary tablespace is determined by the operating system, the file size can be more than 4G, only the operating system can support it. Usually the operating system we use is CentOS or RHEL 64-bit. Bare devices are not supported. The autoextend and max attributes can be used only for the data file specified last in the innodb_temp_data_file_path setting. For example: key points: to set innodb_temp_data_file_path, it can be a temporary file or multiple files. Be sure to set autoextend automatic extension, and also set a maximum value. According to the amount of data in the business system, you can set a few gigabytes. For the problems encountered in the work, the maximum value of max is not set. As a result, the disk space is full and the business stops. Of course, it is caused by the adjustment of the business. [mysqld] innodb_temp_data_file_path=ibtmp1:50M;ibtmp2:12M:autoextend:max:500MB

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.