[MYSQL案例][001] MYSQL_BIN_LOG::open_purge_index_file failed to open register file

2023-05-10T14:55:56.958837Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-05-10T14:55:56.960049Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2023-05-10T14:55:56.960152Z 0 [Note] /soft/mysql_3308/mysqlbase/mysql/bin/mysqld (mysqld 5.7.38-log) starting as process 38376 ...
2023-05-10T14:55:56.969241Z 0 [Warning] Can't create test file /data/mysql_3308/mysqldata/ddcw21.lower-test
2023-05-10T14:55:56.969526Z 0 [Warning] Can't create test file /data/mysql_3308/mysqldata/ddcw21.lower-test
mysqld: File '/data/mysql_3308/mysqllog/binlog/m3308.~rec~' not found (Errcode: 28 - No space left on device)
2023-05-10T14:55:56.972077Z 0 [ERROR] MYSQL_BIN_LOG::open_purge_index_file failed to open register  file.
2023-05-10T14:55:56.972116Z 0 [ERROR] MYSQL_BIN_LOG::open_index_file failed to sync the index file.
2023-05-10T14:55:56.972176Z 0 [ERROR] Aborting

2023-05-10T14:55:56.972246Z 0 [Note] Binlog end
2023-05-10T14:55:56.972810Z 0 [Note] /soft/mysql_3308/mysqlbase/mysql/bin/mysqld: Shutdown complete

mysqld: File '/data/mysql_3314/mysqllog/binlog/m3314.~rec~' not found (OS errno 28 - No space left on device)
2023-05-10T14:54:25.876802Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2023-05-10T14:54:25.876849Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-file' is deprecated and will be removed in a future release.
2023-05-10T14:54:25.876870Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2023-05-10T14:54:25.876889Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2023-05-10T14:54:25.876954Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2023-05-10T14:54:25.877032Z 0 [System] [MY-010116] [Server] /soft/mysql_3314/mysqlbase/mysql/bin/mysqld (mysqld 8.0.28) starting as process 37123
2023-05-10T14:54:25.881545Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2023-05-10T14:54:25.881563Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2023-05-10T14:54:25.882567Z 0 [Warning] [MY-010091] [Server] Can't create test file /data/mysql_3314/mysqldata/mysqld_tmp_file_case_insensitive_test.lower-test
2023-05-10T14:54:25.882603Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /data/mysql_3314/mysqldata/ is case insensitive
2023-05-10T14:54:25.887814Z 0 [ERROR] [MY-010846] [Server] MYSQL_BIN_LOG::open_purge_index_file failed to open register file.
2023-05-10T14:54:25.887985Z 0 [ERROR] [MY-010817] [Server] MYSQL_BIN_LOG::open_index_file failed to sync the index file.
2023-05-10T14:54:25.888076Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-05-10T14:54:25.888448Z 0 [System] [MY-010910] [Server] /soft/mysql_3314/mysqlbase/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.28)  MySQL Community Server - GPL

find /tmp -size 0 #文件多的话, 会刷屏,使用的时候要注意下

python null_file.py /tmp/t20230510dir66 40000000 32
#在/tmp/t20230510dir66目录下面创建40M个空文件, 使用32个进程来创建(单个进程太慢了,就使用多进程)

#在 param[0] 目录下面 生成 param[1] 个空文件, 并发为 param[2]

import sys,os
from multiprocessing import Process

dirname = sys.argv[1] if len(sys.argv) > 1 else 'dont_list_by_ddcw'
files = int(sys.argv[2]) if len(sys.argv) > 2 else 10*1000*1000 #默认10MB
parallel = int(sys.argv[3]) if len(sys.argv) > 3 else 8 #默认8个线程


#创建目录
os.makedirs(dirname,exist_ok=True)


#创建文件
def create_empty_file(n,p):#n:文件个数
	for x in range(n):
		try:
			filename = os.path.join(dirname,f'.{p}_{x}')
			os.mknod(filename)
		except:
			break

pl = {}
for x in range(parallel):
	pl[x] = Process(target=create_empty_file,args=(int(files/parallel),x))
for x in range(parallel):
	pl[x].start()
for x in range(parallel):
	pl[x].join()