MySQL Forums
Forum List  »  Newbie

Re: Suggested settings for MySql
Posted by: Hans Brost
Date: October 05, 2017 02:46PM

Here's all the info I have:

cpsrvd 11.66.0.23
Database client version: libmysql - 5.1.73

Server type: MariaDB
Server version: 10.0.32-MariaDB - MariaDB Server
Protocol version: 10

Edit Edit aria block size 8,192
Edit Edit aria checkpoint interval 30
Edit Edit aria checkpoint log activity 1,048,576
Edit Edit aria force start after recovery failures 0
Edit Edit aria group commit none
Edit Edit aria group commit interval 0
Edit Edit aria log file size 1,073,741,824
Edit Edit aria log purge type immediate
Edit Edit aria max sort file size 9,223,372,036,853,727,232
Edit Edit aria page checksum ON
Edit Edit aria pagecache age threshold 300
Edit Edit aria pagecache buffer size 134,217,728
Edit Edit aria pagecache division limit 100
Edit Edit aria pagecache file hash size 512
Edit Edit aria recover NORMAL
Edit Edit aria repair threads 1
Edit Edit aria sort buffer size 268,434,432
Edit Edit aria stats method nulls_unequal
Edit Edit aria sync log dir NEWFILE
Edit Edit aria used for temp tables ON
Edit Edit auto increment incrementDocumentation 1
Edit Edit auto increment offsetDocumentation 1
Edit Edit autocommitDocumentation ON
Edit Edit automatic sp privilegesDocumentation ON
Edit Edit back logDocumentation 150
Edit Edit basedirDocumentation /usr
Edit Edit big tablesDocumentation OFF
Edit Edit binlog annotate row events OFF
Edit Edit binlog cache sizeDocumentation 32 KiB
Edit Edit binlog checksumDocumentation NONE
Edit Edit binlog commit wait count 0
Edit Edit binlog commit wait usec 100,000
Edit Edit binlog direct non transactional updatesDocumentation OFF
Edit Edit binlog formatDocumentation STATEMENT
Edit Edit binlog optimize thread scheduling ON
Edit Edit binlog stmt cache sizeDocumentation 32 KiB
Edit Edit bulk insert buffer sizeDocumentation 8 MiB
Edit Edit character set clientDocumentation latin1
(Session value ) utf8mb4
Edit Edit character set connectionDocumentation latin1
(Session value ) utf8mb4
Edit Edit character set databaseDocumentation latin1
Edit Edit character set filesystemDocumentation binary
Edit Edit character set resultsDocumentation latin1
(Session value ) utf8mb4
Edit Edit character set serverDocumentation latin1
Edit Edit character set systemDocumentation utf8
Edit Edit character sets dirDocumentation /usr/share/mysql/charsets/
Edit Edit collation connectionDocumentation latin1_swedish_ci
(Session value ) utf8mb4_unicode_ci
Edit Edit collation databaseDocumentation latin1_swedish_ci
Edit Edit collation serverDocumentation latin1_swedish_ci
Edit Edit completion typeDocumentation NO_CHAIN
Edit Edit concurrent insertDocumentation AUTO
Edit Edit connect timeoutDocumentation 10
Edit Edit datadirDocumentation /var/lib/mysql/
Edit Edit date formatDocumentation %Y-%m-%d
Edit Edit datetime formatDocumentation %Y-%m-%d %H:%i:%s
Edit Edit deadlock search depth long 15
Edit Edit deadlock search depth short 4
Edit Edit deadlock timeout long 50,000,000
Edit Edit deadlock timeout short 10,000
Edit Edit debug no thread alarm OFF
Edit Edit default regex flags
Edit Edit default storage engineDocumentation MyISAM
Edit Edit default week formatDocumentation 0
Edit Edit delay key writeDocumentation ON
Edit Edit delayed insert limitDocumentation 100
Edit Edit delayed insert timeoutDocumentation 300
Edit Edit delayed queue sizeDocumentation 1,000
Edit Edit div precision incrementDocumentation 4
Edit Edit event schedulerDocumentation OFF
Edit Edit expensive subquery limit 100
Edit Edit expire logs daysDocumentation 0
Edit Edit extra max connections 1
Edit Edit extra port 0
Edit Edit flushDocumentation OFF
Edit Edit flush timeDocumentation 0
Edit Edit foreign key checksDocumentation ON
Edit Edit ft boolean syntaxDocumentation + -><()~*:""&|
Edit Edit ft max word lenDocumentation 84
Edit Edit ft min word lenDocumentation 4
Edit Edit ft query expansion limitDocumentation 20
Edit Edit ft stopword fileDocumentation (built-in)
Edit Edit general logDocumentation OFF
Edit Edit general log fileDocumentation klxm-5sty.log
Edit Edit group concat max lenDocumentation 1,024
Edit Edit gtid binlog pos
Edit Edit gtid binlog state
Edit Edit gtid current pos
Edit Edit gtid domain id 0
Edit Edit gtid ignore duplicates OFF
Edit Edit gtid slave pos
Edit Edit gtid strict mode OFF
Edit Edit have compressDocumentation YES
Edit Edit have cryptDocumentation YES
Edit Edit have dynamic loadingDocumentation YES
Edit Edit have geometryDocumentation YES
Edit Edit have opensslDocumentation YES
Edit Edit have profilingDocumentation YES
Edit Edit have query cacheDocumentation YES
Edit Edit have rtree keysDocumentation YES
Edit Edit have sslDocumentation DISABLED
Edit Edit have symlinkDocumentation YES
Edit Edit histogram size 0
Edit Edit histogram type SINGLE_PREC_HB
Edit Edit host cache sizeDocumentation 128
Edit Edit hostnameDocumentation klxm-5sty.accessdomain.com
Edit Edit ignore builtin innodbDocumentation OFF
Edit Edit ignore db dirsDocumentation
Edit Edit init connectDocumentation
Edit Edit init fileDocumentation
Edit Edit init slaveDocumentation
Edit Edit innodb adaptive flushingDocumentation ON
Edit Edit innodb adaptive flushing lwmDocumentation 10
Edit Edit innodb adaptive hash indexDocumentation ON
Edit Edit innodb adaptive hash index partitions 1
Edit Edit innodb adaptive max sleep delayDocumentation 150,000
Edit Edit innodb additional mem pool sizeDocumentation 8 MiB
Edit Edit innodb api bk commit intervalDocumentation 5
Edit Edit innodb api disable rowlockDocumentation OFF
Edit Edit innodb api enable binlogDocumentation OFF
Edit Edit innodb api enable mdlDocumentation OFF
Edit Edit innodb api trx levelDocumentation 0
Edit Edit innodb autoextend incrementDocumentation 64
Edit Edit innodb autoinc lock modeDocumentation 1
Edit Edit innodb buffer pool dump at shutdownDocumentation OFF
Edit Edit innodb buffer pool dump nowDocumentation OFF
Edit Edit innodb buffer pool dump pctDocumentation 100
Edit Edit innodb buffer pool filenameDocumentation ib_buffer_pool
Edit Edit innodb buffer pool instancesDocumentation 8
Edit Edit innodb buffer pool load abortDocumentation OFF
Edit Edit innodb buffer pool load at startupDocumentation OFF
Edit Edit innodb buffer pool load nowDocumentation OFF
Edit Edit innodb buffer pool populate OFF
Edit Edit innodb buffer pool sizeDocumentation 128 MiB
Edit Edit innodb change buffer max sizeDocumentation 25
Edit Edit innodb change bufferingDocumentation all
Edit Edit innodb checksum algorithmDocumentation innodb
Edit Edit innodb checksumsDocumentation ON
Edit Edit innodb cleaner lsn age factor high_checkpoint
Edit Edit innodb cmp per index enabledDocumentation OFF
Edit Edit innodb commit concurrencyDocumentation 0
Edit Edit innodb compression failure threshold pctDocumentation 5
Edit Edit innodb compression levelDocumentation 6
Edit Edit innodb compression pad pct maxDocumentation 50
Edit Edit innodb concurrency ticketsDocumentation 5,000
Edit Edit innodb corrupt table action assert
Edit Edit innodb data file pathDocumentation ibdata1:12M:autoextend
Edit Edit innodb data home dirDocumentation
Edit Edit innodb disable sort file cacheDocumentation OFF
Edit Edit innodb doublewriteDocumentation ON
Edit Edit innodb empty free list algorithm legacy
Edit Edit innodb fake changes OFF
Edit Edit innodb fast shutdownDocumentation 1
Edit Edit innodb file formatDocumentation Antelope
Edit Edit innodb file format checkDocumentation ON
Edit Edit innodb file format maxDocumentation Antelope
Edit Edit innodb file per tableDocumentation ON
Edit Edit innodb flush log at timeoutDocumentation 1
Edit Edit innodb flush log at trx commitDocumentation 1
Edit Edit innodb flush methodDocumentation
Edit Edit innodb flush neighborsDocumentation 1
Edit Edit innodb flushing avg loopsDocumentation 30
Edit Edit innodb force load corruptedDocumentation OFF
Edit Edit innodb force recoveryDocumentation 0
Edit Edit innodb foreground preflush exponential_backoff
Edit Edit innodb ft aux tableDocumentation
Edit Edit innodb ft cache sizeDocumentation 8,000,000
Edit Edit innodb ft enable diag printDocumentation OFF
Edit Edit innodb ft enable stopwordDocumentation ON
Edit Edit innodb ft max token sizeDocumentation 84
Edit Edit innodb ft min token sizeDocumentation 3
Edit Edit innodb ft num word optimizeDocumentation 2,000
Edit Edit innodb ft result cache limitDocumentation 2,000,000,000
Edit Edit innodb ft server stopword tableDocumentation
Edit Edit innodb ft sort pll degreeDocumentation 2
Edit Edit innodb ft total cache sizeDocumentation 640,000,000
Edit Edit innodb ft user stopword tableDocumentation
Edit Edit innodb io capacityDocumentation 200
Edit Edit innodb io capacity maxDocumentation 2,000
Edit Edit innodb kill idle transaction 0
Edit Edit innodb large prefixDocumentation OFF
Edit Edit innodb lock wait timeoutDocumentation 50
Edit Edit innodb locking fake changes ON
Edit Edit innodb locks unsafe for binlogDocumentation OFF
Edit Edit innodb log arch dir ./
Edit Edit innodb log arch expire sec 0
Edit Edit innodb log archive OFF
Edit Edit innodb log block size 512
Edit Edit innodb log buffer sizeDocumentation 8 MiB
Edit Edit innodb log checksum algorithmDocumentation innodb
Edit Edit innodb log compressed pagesDocumentation ON
Edit Edit innodb log file sizeDocumentation 48 MiB
Edit Edit innodb log files in groupDocumentation 2
Edit Edit innodb log group home dirDocumentation ./
Edit Edit innodb lru scan depthDocumentation 1,024
Edit Edit innodb max bitmap file size 104,857,600
Edit Edit innodb max changed pages 1,000,000
Edit Edit innodb max dirty pages pctDocumentation 75
Edit Edit innodb max dirty pages pct lwmDocumentation <1
Edit Edit innodb max purge lagDocumentation 0
Edit Edit innodb max purge lag delayDocumentation 0
Edit Edit innodb mirrored log groupsDocumentation 1
Edit Edit innodb monitor disableDocumentation
Edit Edit innodb monitor enableDocumentation
Edit Edit innodb monitor resetDocumentation
Edit Edit innodb monitor reset allDocumentation
Edit Edit innodb old blocks pctDocumentation 37
Edit Edit innodb old blocks timeDocumentation 1,000
Edit Edit innodb online alter log max sizeDocumentation 128 MiB
Edit Edit innodb open filesDocumentation 400
Edit Edit innodb optimize fulltext onlyDocumentation OFF
Edit Edit innodb page sizeDocumentation 16 KiB
Edit Edit innodb print all deadlocksDocumentation OFF
Edit Edit innodb purge batch sizeDocumentation 300
Edit Edit innodb purge threadsDocumentation 1
Edit Edit innodb random read aheadDocumentation OFF
Edit Edit innodb read ahead thresholdDocumentation 56
Edit Edit innodb read io threadsDocumentation 4
Edit Edit innodb read onlyDocumentation OFF
Edit Edit innodb replication delayDocumentation 0
Edit Edit innodb rollback on timeoutDocumentation OFF
Edit Edit innodb rollback segmentsDocumentation 128
Edit Edit innodb sched priority cleaner 19
Edit Edit innodb show locks held 10
Edit Edit innodb show verbose locks 0
Edit Edit innodb simulate comp failures 0
Edit Edit innodb sort buffer sizeDocumentation 1 MiB
Edit Edit innodb spin wait delayDocumentation 6
Edit Edit innodb stats auto recalcDocumentation ON
Edit Edit innodb stats include delete marked OFF
Edit Edit innodb stats methodDocumentation nulls_equal
Edit Edit innodb stats modified counter 0
Edit Edit innodb stats on metadataDocumentation OFF
Edit Edit innodb stats persistentDocumentation ON
Edit Edit innodb stats persistent sample pagesDocumentation 20
Edit Edit innodb stats sample pagesDocumentation 8
Edit Edit innodb stats traditional ON
Edit Edit innodb stats transient sample pagesDocumentation 8
Edit Edit innodb status outputDocumentation OFF
Edit Edit innodb status output locksDocumentation OFF
Edit Edit innodb strict modeDocumentation OFF
Edit Edit innodb support xaDocumentation ON
Edit Edit innodb sync array sizeDocumentation 1
Edit Edit innodb sync spin loopsDocumentation 30
Edit Edit innodb table locksDocumentation ON
Edit Edit innodb thread concurrencyDocumentation 0
Edit Edit innodb thread sleep delayDocumentation 10,000
Edit Edit innodb tmpdir
Edit Edit innodb track changed pages OFF
Edit Edit innodb undo directoryDocumentation .
Edit Edit innodb undo logsDocumentation 128
Edit Edit innodb undo tablespacesDocumentation 0
Edit Edit innodb use atomic writes OFF
Edit Edit innodb use fallocate OFF
Edit Edit innodb use global flush log at trx commit ON
Edit Edit innodb use native aioDocumentation ON
Edit Edit innodb use stacktrace OFF
Edit Edit innodb use sys mallocDocumentation ON
Edit Edit innodb versionDocumentation 5.6.36-82.1
Edit Edit innodb write io threadsDocumentation 4
Edit Edit interactive timeoutDocumentation 28,800
Edit Edit join buffer sizeDocumentation 128 KiB
Edit Edit join buffer space limit 2,097,152
Edit Edit join cache level 2
Edit Edit keep files on createDocumentation OFF
Edit Edit key buffer sizeDocumentation 512 MiB
Edit Edit key cache age thresholdDocumentation 300
Edit Edit key cache block sizeDocumentation 1 KiB
Edit Edit key cache division limitDocumentation 100
Edit Edit key cache file hash size 512
Edit Edit key cache segments 0
Edit Edit large files supportDocumentation ON
Edit Edit large page sizeDocumentation 0 B
Edit Edit large pagesDocumentation OFF
Edit Edit lc messagesDocumentation en_US
Edit Edit lc messages dirDocumentation
Edit Edit lc time namesDocumentation en_US
Edit Edit licenseDocumentation GPL
Edit Edit local infileDocumentation ON
Edit Edit lock wait timeoutDocumentation 31,536,000
Edit Edit locked in memoryDocumentation OFF
Edit Edit log binDocumentation OFF
Edit Edit log bin trust function creatorsDocumentation OFF
Edit Edit log errorDocumentation /var/lib/mysql/klxm-5sty.accessdomain.com.err
Edit Edit log outputDocumentation FILE
Edit Edit log queries not using indexesDocumentation OFF
Edit Edit log slave updatesDocumentation OFF
Edit Edit log slow filter admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
Edit Edit log slow rate limit 1
Edit Edit log slow verbosity
Edit Edit log warningsDocumentation 1
Edit Edit long query timeDocumentation 10
Edit Edit low priority updatesDocumentation OFF
Edit Edit lower case file systemDocumentation OFF
Edit Edit lower case table namesDocumentation 0
Edit Edit master verify checksumDocumentation OFF
Edit Edit max allowed packetDocumentation 268,435,456
Edit Edit max binlog cache sizeDocumentation 16 EiB
Edit Edit max binlog sizeDocumentation 1 GiB
Edit Edit max binlog stmt cache sizeDocumentation 16 EiB
Edit Edit max connect errorsDocumentation 100
Edit Edit max connectionsDocumentation 151
Edit Edit max delayed threadsDocumentation 20
Edit Edit max digest lengthDocumentation 1,024
Edit Edit max error countDocumentation 64
Edit Edit max heap table sizeDocumentation 64 MiB
Edit Edit max insert delayed threadsDocumentation 20
Edit Edit max join sizeDocumentation 18,446,744,073,709,551,616
Edit Edit max length for sort dataDocumentation 1,024
Edit Edit max long data sizeDocumentation 268,435,456
Edit Edit max prepared stmt countDocumentation 16,382
Edit Edit max relay log sizeDocumentation 1 GiB
Edit Edit max seeks for keyDocumentation 4,294,967,295
Edit Edit max sort lengthDocumentation 1,024
Edit Edit max sp recursion depthDocumentation 0
Edit Edit max tmp tablesDocumentation 32
Edit Edit max user connectionsDocumentation 0
(Session value ) 2,147,483,647
Edit Edit max write lock countDocumentation 4,294,967,295
Edit Edit metadata locks cache sizeDocumentation 1,024
Edit Edit metadata locks hash instancesDocumentation 8
Edit Edit min examined row limitDocumentation 0
Edit Edit mrr buffer size 262,144
Edit Edit multi range countDocumentation 256
Edit Edit myisam block size 1,024
Edit Edit myisam data pointer sizeDocumentation 6 B
Edit Edit myisam max sort file sizeDocumentation 8 EiB
Edit Edit myisam mmap sizeDocumentation 16 EiB
Edit Edit myisam recover optionsDocumentation DEFAULT
Edit Edit myisam repair threadsDocumentation 1
Edit Edit myisam sort buffer sizeDocumentation 127.999 MiB
Edit Edit myisam stats methodDocumentation nulls_unequal
Edit Edit myisam use mmapDocumentation OFF
Edit Edit net buffer lengthDocumentation 16,384
Edit Edit net read timeoutDocumentation 30
Edit Edit net retry countDocumentation 10
Edit Edit net write timeoutDocumentation 60
Edit Edit oldDocumentation OFF
Edit Edit old alter tableDocumentation OFF
Edit Edit old mode
Edit Edit old passwordsDocumentation OFF
Edit Edit open files limitDocumentation 10,000
Edit Edit optimizer prune levelDocumentation 1
Edit Edit optimizer search depthDocumentation 62
Edit Edit optimizer selectivity sampling limit 100
Edit Edit optimizer switchDocumentation index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on
Edit Edit optimizer use condition selectivity 1
Edit Edit performance schemaDocumentation OFF
Edit Edit performance schema accounts sizeDocumentation -1
Edit Edit performance schema digests sizeDocumentation -1
Edit Edit performance schema events stages history long sizeDocumentation -1
Edit Edit performance schema events stages history sizeDocumentation -1
Edit Edit performance schema events statements history long sizeDocumentation -1
Edit Edit performance schema events statements history sizeDocumentation -1
Edit Edit performance schema events waits history long sizeDocumentation -1
Edit Edit performance schema events waits history sizeDocumentation -1
Edit Edit performance schema hosts sizeDocumentation -1
Edit Edit performance schema max cond classesDocumentation 80
Edit Edit performance schema max cond instancesDocumentation -1
Edit Edit performance schema max digest lengthDocumentation 1,024
Edit Edit performance schema max file classesDocumentation 50
Edit Edit performance schema max file handlesDocumentation 32,768
Edit Edit performance schema max file instancesDocumentation -1
Edit Edit performance schema max mutex classesDocumentation 200
Edit Edit performance schema max mutex instancesDocumentation -1
Edit Edit performance schema max rwlock classesDocumentation 40
Edit Edit performance schema max rwlock instancesDocumentation -1
Edit Edit performance schema max socket classesDocumentation 10
Edit Edit performance schema max socket instancesDocumentation -1
Edit Edit performance schema max stage classesDocumentation 150
Edit Edit performance schema max statement classesDocumentation 180
Edit Edit performance schema max table handlesDocumentation -1
Edit Edit performance schema max table instancesDocumentation -1
Edit Edit performance schema max thread classesDocumentation 50
Edit Edit performance schema max thread instancesDocumentation -1
Edit Edit performance schema session connect attrs sizeDocumentation -1
Edit Edit performance schema setup actors sizeDocumentation 100
Edit Edit performance schema setup objects sizeDocumentation 100
Edit Edit performance schema users sizeDocumentation -1
Edit Edit pid fileDocumentation /var/lib/mysql/klxm-5sty.accessdomain.com.pid
Edit Edit plugin dirDocumentation /usr/lib64/mysql/plugin/
Edit Edit plugin maturity unknown
Edit Edit portDocumentation 3,306
Edit Edit preload buffer sizeDocumentation 32 KiB
Edit Edit profilingDocumentation OFF
Edit Edit profiling history sizeDocumentation 15
Edit Edit progress report time 5
Edit Edit protocol versionDocumentation 10
Edit Edit query alloc block sizeDocumentation 8 KiB
Edit Edit query cache limitDocumentation 32 MiB
Edit Edit query cache min res unitDocumentation 4,096
Edit Edit query cache sizeDocumentation 64 MiB
Edit Edit query cache strip comments OFF
Edit Edit query cache typeDocumentation ON
Edit Edit query cache wlock invalidateDocumentation OFF
Edit Edit query prealloc sizeDocumentation 8 KiB
Edit Edit range alloc block sizeDocumentation 4 KiB
Edit Edit read buffer sizeDocumentation 8 MiB
Edit Edit read onlyDocumentation OFF
Edit Edit read rnd buffer sizeDocumentation 8 MiB
Edit Edit relay logDocumentation
Edit Edit relay log indexDocumentation
Edit Edit relay log info fileDocumentation relay-log.info
Edit Edit relay log purgeDocumentation ON
Edit Edit relay log recoveryDocumentation OFF
Edit Edit relay log space limitDocumentation 0
Edit Edit replicate annotate row events OFF
Edit Edit replicate do db
Edit Edit replicate do table
Edit Edit replicate events marked for skip replicate
Edit Edit replicate ignore db
Edit Edit replicate ignore table
Edit Edit replicate wild do table
Edit Edit replicate wild ignore table
Edit Edit report hostDocumentation
Edit Edit report passwordDocumentation
Edit Edit report portDocumentation 3,306
Edit Edit report userDocumentation
Edit Edit rowid merge buff size 8,388,608
Edit Edit rpl recovery rankDocumentation 0
Edit Edit secure authDocumentation OFF
Edit Edit secure file privDocumentation
Edit Edit server idDocumentation 0
Edit Edit skip external lockingDocumentation ON
Edit Edit skip name resolveDocumentation OFF
Edit Edit skip networkingDocumentation OFF
Edit Edit skip show databaseDocumentation OFF
Edit Edit slave compressed protocolDocumentation OFF
Edit Edit slave ddl exec mode IDEMPOTENT
Edit Edit slave domain parallel threads 0
Edit Edit slave exec modeDocumentation STRICT
Edit Edit slave load tmpdirDocumentation /tmp
Edit Edit slave max allowed packetDocumentation 1,073,741,824
Edit Edit slave net timeoutDocumentation 3,600
Edit Edit slave parallel max queued 131,072
Edit Edit slave parallel threads 0
Edit Edit slave skip errorsDocumentation OFF
Edit Edit slave sql verify checksumDocumentation ON
Edit Edit slave transaction retriesDocumentation 10
Edit Edit slave type conversionsDocumentation
Edit Edit slow launch timeDocumentation 2
Edit Edit slow query logDocumentation OFF
Edit Edit slow query log fileDocumentation klxm-5sty-slow.log
Edit Edit socketDocumentation /var/lib/mysql/mysql.sock
Edit Edit sort buffer sizeDocumentation 32 MiB
Edit Edit sql auto is nullDocumentation OFF
Edit Edit sql big selectsDocumentation ON
Edit Edit sql buffer resultDocumentation OFF
Edit Edit sql log binDocumentation ON
Edit Edit sql log offDocumentation OFF
Edit Edit sql modeDocumentation
Edit Edit sql notesDocumentation ON
Edit Edit sql quote show createDocumentation ON
Edit Edit sql safe updatesDocumentation OFF
Edit Edit sql select limitDocumentation 18,446,744,073,709,551,616
Edit Edit sql slave skip counterDocumentation 0
Edit Edit sql warningsDocumentation OFF
Edit Edit ssl caDocumentation
Edit Edit ssl capathDocumentation
Edit Edit ssl certDocumentation
Edit Edit ssl cipherDocumentation
Edit Edit ssl crlDocumentation
Edit Edit ssl crlpathDocumentation
Edit Edit ssl keyDocumentation
Edit Edit storage engineDocumentation MyISAM
Edit Edit stored program cacheDocumentation 256
Edit Edit sync binlogDocumentation 0
Edit Edit sync frmDocumentation ON
Edit Edit sync master infoDocumentation 0
Edit Edit sync relay logDocumentation 0
Edit Edit sync relay log infoDocumentation 0
Edit Edit system time zoneDocumentation -7
Edit Edit table definition cacheDocumentation 400
Edit Edit table open cacheDocumentation 400
Edit Edit thread cache sizeDocumentation 10
Edit Edit thread concurrencyDocumentation 10
Edit Edit thread handlingDocumentation one-thread-per-connection
Edit Edit thread pool idle timeout 60
Edit Edit thread pool max threads 500
Edit Edit thread pool oversubscribe 3
Edit Edit thread pool size 24
Edit Edit thread pool stall limit 500
Edit Edit thread stackDocumentation 294,912
Edit Edit time formatDocumentation %H:%i:%s
Edit Edit time zoneDocumentation SYSTEM
Edit Edit timed mutexesDocumentation OFF
Edit Edit tmp table sizeDocumentation 64 MiB
Edit Edit tmpdirDocumentation /tmp
Edit Edit transaction alloc block sizeDocumentation 8 KiB
Edit Edit transaction prealloc sizeDocumentation 4 KiB
Edit Edit tx isolationDocumentation REPEATABLE-READ
Edit Edit tx read onlyDocumentation OFF
Edit Edit unique checksDocumentation ON
Edit Edit updatable views with limitDocumentation YES
Edit Edit use stat tables NEVER
Edit Edit userstat OFF
Edit Edit versionDocumentation 10.0.32-MariaDB
Edit Edit version commentDocumentation MariaDB Server
Edit Edit version compile machineDocumentation x86_64
Edit Edit version compile osDocumentation Linux
Edit Edit version malloc library bundled jemalloc
Edit Edit wait timeoutDocumentation 28,800

Options: ReplyQuote


Subject
Written By
Posted
October 05, 2017 11:03AM
Re: Suggested settings for MySql
October 05, 2017 02:46PM
October 05, 2017 04:21PM
October 05, 2017 02:49PM
October 05, 2017 02:50PM
October 05, 2017 04:18PM
October 05, 2017 04:21PM
October 05, 2017 04:28PM
October 09, 2017 12:18PM
October 11, 2017 09:35AM
October 11, 2017 10:12AM
October 11, 2017 09:47AM
October 14, 2017 12:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.