Skip to content

Instantly share code, notes, and snippets.

@ronaldbradford

ronaldbradford/README.md

Last active October 20, 2023 20:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ronaldbradford/6e2856e9e90672d3b33755af4240fe49 to your computer and use it in GitHub Desktop.
Save ronaldbradford/6e2856e9e90672d3b33755af4240fe49 to your computer and use it in GitHub Desktop.
Download ZIP
Config Examples
Raw
README.md

Example Configs

Databases

  • MySQL (table format)
  • MySQL (tsv format)
  • MariaDB (Table format)
  • PostgreSQL (table format)
Raw
mariadb-version.txt
| in_predicate_conversion_threshold | 1000 |
| protocol_version | 10 |
| slave_type_conversions | |
| system_versioning_alter_history | ERROR |
| system_versioning_asof | DEFAULT |
| system_versioning_insert_history | OFF |
| tls_version | TLSv1.1,TLSv1.2,TLSv1.3 |
| version | 11.1.2-MariaDB-1:11.1.2+maria~ubu2204 |
| version_comment | mariadb.org binary distribution |
| version_compile_machine | x86_64 |
| version_compile_os | debian-linux-gnu |
| version_malloc_library | system |
| version_source_revision | 9bc25d98209df6810f7a7d5e7dd3ae677a313ab5 |
| version_ssl_library | OpenSSL 3.0.2 15 Mar 2022 |
| wsrep_patch_version | wsrep_26.22 |
Raw
mysql-no-table.txt
auto_increment_increment 1
auto_increment_offset 1
table_lock_wait_timeout 50
table_type MyISAM
thread_cache_size 0
thread_stack 262144
time_format %H:%i:%s
time_zone SYSTEM
timed_mutexes OFF
tmp_table_size 33554432
tmpdir /Users/rbradfor/sandboxes/msb_5_0_96/tmp
transaction_alloc_block_size 8192
transaction_prealloc_size 4096
tx_isolation REPEATABLE-READ
updatable_views_with_limit YES
version 5.0.96
version_comment MySQL Community Server (GPL)
version_compile_machine i386
version_compile_os apple-darwin9.8.0
wait_timeout 28800
Raw
mysql-table-rows.txt
+-----------------------------------------+-------------------------------------------------------------------------------------------+
| Variable_name | Value |
+-----------------------------------------+-------------------------------------------------------------------------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| autocommit | ON |
| automatic_sp_privileges | ON |
| thread_cache_size | 0 |
| thread_handling | one-thread-per-connection |
| tmpdir | /Users/rbradfor/sandboxes/msb_5_1_73/tmp |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| updatable_views_with_limit | YES |
| version | 5.1.73 |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | i386 |
| version_compile_os | apple-darwin10.3.0 |
+-----------------------------------------+-------------------------------------------------------------------------------------------+
277 rows in set (0.00 sec)
Raw
postgres-table-rows.txt
name |
-------------------------------------------------------+---
enable_partitionwise_join | off
enable_seqscan | on
enable_sort | on
enable_tidscan | on
escape_string_warning | on
event_source | PostgreSQL
eventpoints_mode | off
external_pid_file |
extra_float_digits | 1
force_parallel_mode | off
row_security | on
search_path | "$user", public
segment_size | 131072
seq_page_cost | 1
server_encoding | UTF8
server_version | 15.4
server_version_num | 150004
(426 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment