Advertisement
Guest User

Untitled

a guest
Feb 28th, 2024
221
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
VIM 3.54 KB | Software | 0 0
  1. my.cnf - Note, I want to be using MyISAM, not InnoDB.  I see that InnoDB is still listed throughout this file and my sql queries, but I don't think it's being used.  Also, I did not make all of this myself, I stole most of it off the internet years ago.  It worked for RHEL 7.
  2. -------------------------
  3. [mysqld]
  4. datadir=/outsql/mysql
  5. socket=/var/lib/mysql/mysql.sock
  6. skip-grant-tables
  7. default-storage-engine=MyISAM
  8. bind-address=0.0.0.0
  9. sql-mode='NO_ENGINE_SUBSTITUTION'
  10. symbolic-links=0
  11. character-set-server=utf8
  12. collation-server=utf8_general_ci
  13. columnstore-use-import-for-batchinsert=ALWAYS
  14. performance_schema=ON
  15. skip-innodb
  16. [mysqld_safe]
  17. log-error=/var/log/mariadb/mariadb.log
  18. pid-file=/var/run/mariadb/mariadb.pid
  19. [client]
  20. socket=/var/lib/mysql/mysql.sock
  21. [mariadb]
  22. log_error=mariadb.err
  23. character_set_server=utf8
  24. plugin_load_add=metadata_lock_info
  25. !includedir /etc/my.cnf.d
  26. -------------------------
  27.  
  28. SHOW ENGINES;
  29. Engine              | Support   | Transactions  | XA    | Savepoints
  30. ---------------------------------------------------------------------
  31. Columnstore         | YES       | YES           | NO    | NO        |
  32. MRG_MyISAM          | YES       | NO            | NO    | NO        |
  33. MEMORY              | YES       | NO            | NO    | NO        |
  34. Aria                | YES       | NO            | NO    | NO        |
  35. MyISAM              | DEFAULT   | NO            | NO    | NO        |
  36. SEQUENCE            | YES       | YES           | NO    | YES       |
  37. InnoDB              | YES       | YES           | YES   | YES       |
  38. PERFORMANCE_SCHEMA  | YES       | NO            | NO    | NO        |
  39. CSV                 | YES       | NO            | NO    | NO        |
  40. ---------------------------------------------------------------------
  41.  
  42.  
  43.  
  44. SHOW GLOBAL STATUS; - Note, this returned ~570 lines on my unintentionally airgapped machine.  I've selected some of the largest numbers.  There were no entries with MyISAM in this table, but there were a few with InnoDB.
  45. Variable Name               | Value
  46. ---------------------------------------------------------------------
  47. wsrep_cluster_conf_id       | 18446744073709551615
  48. wsrep_local_index           | 18446744073709551615
  49. Bytes_received              | 273239125724
  50. Bytes_sent                  | 188061508716
  51. Rows_read                   | 109705313104
  52. Handler_read_next           | 52125598494
  53. Handler_read_key            | 40182624911
  54. Handler_read_rnd_next       | 33582173647
  55. Handler_write               | 26332091055
  56. Key_read_requests           | 18917763105
  57. Handler_tmp_write           | 5183619407
  58. Key_write_requests          | 4098350379
  59. Rows_tmp_read               | 3951632540
  60. Innodb_lsn_flushed          | 3172273491
  61. Innodb_lsn_current          | 3172273491
  62. Innodb_lsn_last_checkpoint  | 3172273479
  63. Table_open_cache_misses     | 2651238344
  64. Handler_read_rnd            | 2015970912
  65. Sort_rows                   | 2015619954
  66. Handler_tmp_update          | 1495832112
  67. Rows_sent                   | 1165867242
  68. Memory_used                 | 970494080
  69. ---------------------------------------------------------------------
  70.  
  71.  
  72.  
  73. SHOW VARIABLES; - Note, this returned ~680 lines, so here are some of the largest numeric results, and some things that might be helpful.
  74. Variable Name               | Value
  75. ---------------------------------------------------------------------
  76. tmp_disk_table_size         | 18446744073709551615
  77. sql_select_limit            | 18446744073709551615
  78. myisam_mmap_size            | 18446744073709551615
  79. max_session_mem_used        | 9223372036854775807
  80. max_join_size               | 18446744073709551615
  81. max_binlog_stmt_cache_size  | 18446744073709547520
  82. max_binlog_cache_size       | 18446744073709547520
  83. myisam_max_sort_file_size   | 9223372036853727232
  84. aria_max_sort_file_size     | 9223372036853727232
  85. key_buffer_size             | 134217728
  86. default_storage_engine      | MyISAM
  87. myisam_use_mmap             | OFF
  88. storage_engine              | MyISAM
  89. myisam_block_size           | 1024
  90. key_cache_block_size        | 1024
  91. version                     | 10.5.22-MariaDB
  92. have_query_cache            | YES
  93. ---------------------------------------------------------------------
Tags: mysql
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement