Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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.
- -------------------------
- [mysqld]
- datadir=/outsql/mysql
- socket=/var/lib/mysql/mysql.sock
- skip-grant-tables
- default-storage-engine=MyISAM
- bind-address=0.0.0.0
- sql-mode='NO_ENGINE_SUBSTITUTION'
- symbolic-links=0
- character-set-server=utf8
- collation-server=utf8_general_ci
- columnstore-use-import-for-batchinsert=ALWAYS
- performance_schema=ON
- skip-innodb
- [mysqld_safe]
- log-error=/var/log/mariadb/mariadb.log
- pid-file=/var/run/mariadb/mariadb.pid
- [client]
- socket=/var/lib/mysql/mysql.sock
- [mariadb]
- log_error=mariadb.err
- character_set_server=utf8
- plugin_load_add=metadata_lock_info
- !includedir /etc/my.cnf.d
- -------------------------
- SHOW ENGINES;
- Engine | Support | Transactions | XA | Savepoints
- ---------------------------------------------------------------------
- Columnstore | YES | YES | NO | NO |
- MRG_MyISAM | YES | NO | NO | NO |
- MEMORY | YES | NO | NO | NO |
- Aria | YES | NO | NO | NO |
- MyISAM | DEFAULT | NO | NO | NO |
- SEQUENCE | YES | YES | NO | YES |
- InnoDB | YES | YES | YES | YES |
- PERFORMANCE_SCHEMA | YES | NO | NO | NO |
- CSV | YES | NO | NO | NO |
- ---------------------------------------------------------------------
- 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.
- Variable Name | Value
- ---------------------------------------------------------------------
- wsrep_cluster_conf_id | 18446744073709551615
- wsrep_local_index | 18446744073709551615
- Bytes_received | 273239125724
- Bytes_sent | 188061508716
- Rows_read | 109705313104
- Handler_read_next | 52125598494
- Handler_read_key | 40182624911
- Handler_read_rnd_next | 33582173647
- Handler_write | 26332091055
- Key_read_requests | 18917763105
- Handler_tmp_write | 5183619407
- Key_write_requests | 4098350379
- Rows_tmp_read | 3951632540
- Innodb_lsn_flushed | 3172273491
- Innodb_lsn_current | 3172273491
- Innodb_lsn_last_checkpoint | 3172273479
- Table_open_cache_misses | 2651238344
- Handler_read_rnd | 2015970912
- Sort_rows | 2015619954
- Handler_tmp_update | 1495832112
- Rows_sent | 1165867242
- Memory_used | 970494080
- ---------------------------------------------------------------------
- SHOW VARIABLES; - Note, this returned ~680 lines, so here are some of the largest numeric results, and some things that might be helpful.
- Variable Name | Value
- ---------------------------------------------------------------------
- tmp_disk_table_size | 18446744073709551615
- sql_select_limit | 18446744073709551615
- myisam_mmap_size | 18446744073709551615
- max_session_mem_used | 9223372036854775807
- max_join_size | 18446744073709551615
- max_binlog_stmt_cache_size | 18446744073709547520
- max_binlog_cache_size | 18446744073709547520
- myisam_max_sort_file_size | 9223372036853727232
- aria_max_sort_file_size | 9223372036853727232
- key_buffer_size | 134217728
- default_storage_engine | MyISAM
- myisam_use_mmap | OFF
- storage_engine | MyISAM
- myisam_block_size | 1024
- key_cache_block_size | 1024
- version | 10.5.22-MariaDB
- have_query_cache | YES
- ---------------------------------------------------------------------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement