Guest User

Untitled

a guest
Apr 26th, 2018
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.99 KB | None | 0 0
  1. The below is the my config:
  2. Window Server 2016
  3. RAM: 7.71GB
  4. 64-bit OS
  5. MYSQL Server 5.7 Win32
  6.  
  7. max_connections=151
  8. table_open_cache=200000
  9. thread_cache_size=10000
  10. myisam_max_sort_file_size=1000G
  11. myisam_sort_buffer_size=64M
  12. key_buffer_size=1024M
  13. read_buffer_size=8192
  14. read_rnd_buffer_size=1
  15. innodb_flush_log_at_trx_commit=1
  16. innodb_log_buffer_size=64M
  17. innodb_buffer_pool_size = 2G
  18. innodb_log_file_size=512M
  19. innodb_thread_concurrency=8
  20. innodb_autoextend_increment=64
  21. innodb_buffer_pool_instances=8
  22. innodb_concurrency_tickets=5000
  23. innodb_old_blocks_time=1000
  24. innodb_open_files=300
  25. innodb_stats_on_metadata=0
  26. innodb_file_per_table=1
  27. for strict_none.
  28. innodb_checksum_algorithm=0
  29. back_log=80
  30. flush_time=0
  31. join_buffer_size = 1024M
  32. max_allowed_packet=4M
  33. max_connect_errors=100
  34. open_files_limit=4161
  35. sort_buffer_size=64M
  36. table_definition_cache=1400
  37. binlog_row_event_max_size=8K
  38. sync_master_info=10000
  39. sync_relay_log=10000
  40. sync_relay_log_info=10000
  41. net_write_timeout = 6000
  42. net_read_timeout = 3000
  43. innodb_page_size = 16384
  44. innodb_page_cleaners = 16
  45. max_heap_table_size = 8G
  46. tmp_table_size=8G
  47. innodb_data_file_path = ibdata1:12M:autoextend:max:8G
  48.  
  49. Mysql > Show table status;
  50. # 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
  51. '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', ''
  52.  
  53. 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