Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- The below is the my config:
- Window Server 2016
- RAM: 7.71GB
- 64-bit OS
- MYSQL Server 5.7 Win32
- max_connections=151
- table_open_cache=200000
- thread_cache_size=10000
- myisam_max_sort_file_size=1000G
- myisam_sort_buffer_size=64M
- key_buffer_size=1024M
- read_buffer_size=8192
- read_rnd_buffer_size=1
- innodb_flush_log_at_trx_commit=1
- innodb_log_buffer_size=64M
- innodb_buffer_pool_size = 2G
- innodb_log_file_size=512M
- innodb_thread_concurrency=8
- innodb_autoextend_increment=64
- innodb_buffer_pool_instances=8
- innodb_concurrency_tickets=5000
- innodb_old_blocks_time=1000
- innodb_open_files=300
- innodb_stats_on_metadata=0
- innodb_file_per_table=1
- for strict_none.
- innodb_checksum_algorithm=0
- back_log=80
- flush_time=0
- join_buffer_size = 1024M
- max_allowed_packet=4M
- max_connect_errors=100
- open_files_limit=4161
- sort_buffer_size=64M
- table_definition_cache=1400
- binlog_row_event_max_size=8K
- sync_master_info=10000
- sync_relay_log=10000
- sync_relay_log_info=10000
- net_write_timeout = 6000
- net_read_timeout = 3000
- innodb_page_size = 16384
- innodb_page_cleaners = 16
- max_heap_table_size = 8G
- tmp_table_size=8G
- innodb_data_file_path = ibdata1:12M:autoextend:max:8G
- Mysql > Show table status;
- # Name, Engine, Version, Row_format, Rows, Avg_row_length, Data_length, Max_data_length, Index_length, Data_free, Auto_increment, Create_time, Update_time, Check_time, Collation, Checksum, Create_options, Comment
- 'tbl_invoice_detail_lesson', 'InnoDB', '10', 'Dynamic', '15455046', '148', '2292187136', '0', '3805609984', '4194304', '15572231', '2018-04-26 12:05:28', '2018-04-26 17:33:27', NULL, 'utf8_general_ci', NULL, 'max_rows=1000000000', ''
- InnoDB: Trying to access page number 263280 in space 69, space name db_yyyy/tbl_xxxxx, which is outside the tablespace bounds. Byte offset 0, len 16384, i/o type read. If you get this error at mysqld startup, please check that your my.cnf [truncated, 316 bytes total]
Add Comment
Please, Sign In to add comment