Hi @geek_girl.
What does it mean to use the MyISAM storage engine? Can some of these failures be fixed? how?
Hi @DigitZup.
I understand what you say, since I have seen forums on this subject since 2008 and all without solution. What I do not understand is why Boonex says nothing about these errors, so that time in this matter is not wasted, if it has no arrangement, it is said and that's it.
A manual of how to configure the variables and topic solved is made.
I am going to put here the VARIABLES of my database and on it we can create which are the best options, so surely all the members of the community can benefit, since surely we ALL have the same problems.
Thanks in advance
And best regards
My Variables:
aria block size 8,192
aria checkpoint interval 30
aria checkpoint log activity 1,048,576
aria force start after recovery failures 0
aria group commit none
aria group commit interval 0
aria log file size 1,073,741,824
aria log purge type immediate
aria max sort file size 9,223,372,036,853,727,232
aria page checksum ON
aria pagecache age threshold 300
aria pagecache buffer size 134,217,728
aria pagecache division limit 100
aria recover NORMAL
aria repair threads 1
aria sort buffer size 134,217,728
aria stats method nulls_unequal
aria sync log dir NEWFILE
aria used for temp tables ON
auto increment increment Documentation 1
auto increment offset Documentation 1
autocommit Documentation ON
automatic sp privileges Documentation ON
back log Documentation 50
basedir Documentation /usr
big tables Documentation OFF
binlog annotate row events OFF
binlog cache size Documentation 32 KiB
binlog checksum Documentation NONE
binlog direct non transactional updates Documentation OFF
binlog format Documentation STATEMENT
binlog optimize thread scheduling ON
binlog stmt cache size Documentation 32 KiB
bulk insert buffer size Documentation 8 MiB
character set client Documentation latin1
(Session value) utf8
character set connection Documentation latin1
(Session value) utf8
character set database Documentation latin1
character set filesystem Documentation binary
character set results Documentation latin1
(Session value) utf8
character set server Documentation latin1
character set system Documentation utf8
character sets dir Documentation /usr/share/mysql/charsets/
collation connection Documentation latin1_swedish_ci
(Session value) utf8_unicode_ci
collation database Documentation latin1_swedish_ci
collation server Documentation latin1_swedish_ci
completion type Documentation NO_CHAIN
concurrent insert Documentation AUTO
connect timeout Documentation 10
datadir Documentation /var/lib/mysql/
date format Documentation %Y-%m-%d
datetime format Documentation %Y-%m-%d %H:%i:%s
deadlock search depth long 15
deadlock search depth short 4
deadlock timeout long 50,000,000
deadlock timeout short 10,000
debug no thread alarm OFF
default storage engine Documentation InnoDB
default week format Documentation 0
delay key write Documentation ON
delayed insert limit Documentation 100
delayed insert timeout Documentation 300
delayed queue size Documentation 1,000
div precision increment Documentation 4
engine condition pushdown Documentation OFF
event scheduler Documentation OFF
expensive subquery limit 100
expire logs days Documentation 0
extra max connections 1
extra port 0
flush Documentation OFF
flush time Documentation 0
foreign key checks Documentation ON
ft boolean syntax Documentation + -><()~*:""&|
ft max word len Documentation 84
ft min word len Documentation 4
ft query expansion limit Documentation 20
ft stopword file Documentation (built-in)
general log Documentation OFF
general log file Documentation server.log
group concat max len Documentation 1,024
have compress Documentation YES
have crypt Documentation YES
have csv Documentation YES
have dynamic loading Documentation YES
have geometry Documentation YES
have innodb Documentation YES
have ndbcluster Documentation NO
have openssl Documentation DISABLED
have partitioning Documentation YES
have profiling Documentation YES
have query cache Documentation YES
have rtree keys Documentation YES
have ssl Documentation DISABLED
have symlink Documentation DISABLED
hostname Documentation server.MISERVER.com
ignore builtin innodb Documentation OFF
ignore db dirs Documentation
init connect Documentation
init file Documentation
init slave Documentation
innodb adaptive flushing Documentation ON
innodb adaptive flushing method estimate
innodb adaptive hash index Documentation ON
innodb adaptive hash index partitions 1
innodb additional mem pool size Documentation 8 MiB
innodb autoextend increment Documentation 8
innodb autoinc lock mode Documentation 1
innodb blocking buffer pool restore OFF
innodb buffer pool instances Documentation 1
innodb buffer pool populate OFF
innodb buffer pool restore at startup 0
innodb buffer pool shm checksum ON
innodb buffer pool shm key 0
innodb buffer pool size Documentation 128 MiB
innodb change buffering Documentation all
innodb checkpoint age target 0
innodb checksums Documentation ON
innodb commit concurrency Documentation 0
innodb concurrency tickets Documentation 500
innodb corrupt table action assert
innodb data file path Documentation ibdata1:10M:autoextend
innodb data home dir Documentation
innodb dict size limit 0
innodb doublewrite Documentation ON
innodb doublewrite file
innodb fake changes OFF
innodb fast checksum OFF
innodb fast shutdown Documentation 1
innodb file format Documentation Antelope
innodb file format check Documentation ON
innodb file format max Documentation Antelope
innodb file per table Documentation OFF
innodb flush log at trx commit Documentation 1
innodb flush method Documentation
innodb flush neighbor pages area
innodb force load corrupted Documentation OFF
innodb force recovery Documentation 0
innodb ibuf accel rate 100
innodb ibuf active contract 1
innodb ibuf max size 67,092,480
innodb import table from xtrabackup 0
innodb io capacity Documentation 200
innodb kill idle transaction 0
innodb large prefix Documentation OFF
innodb lazy drop table 0
innodb lock wait timeout Documentation 50
innodb locking fake changes ON
innodb locks unsafe for binlog Documentation OFF
innodb log block size 512
innodb log buffer size Documentation 8 MiB
innodb log file size Documentation 5 MiB
innodb log files in group Documentation 2
innodb log group home dir Documentation ./
innodb max bitmap file size 104,857,600
innodb max changed pages 1,000,000
innodb max dirty pages pct Documentation 75
innodb max purge lag Documentation 0
innodb merge sort block size 1,048,576
innodb mirrored log groups Documentation 1
innodb old blocks pct Documentation 37
innodb old blocks time Documentation 0
innodb open files Documentation 300
innodb page size Documentation 16 KiB
innodb print all deadlocks Documentation OFF
innodb purge batch size Documentation 20
innodb purge threads Documentation 1
innodb random read ahead Documentation OFF
innodb read ahead linear
innodb read ahead threshold Documentation 56
innodb read io threads Documentation 4
innodb recovery stats OFF
innodb recovery update relay log OFF
innodb replication delay Documentation 0
innodb rollback on timeout Documentation OFF
innodb rollback segments Documentation 128
innodb show locks held 10
innodb show verbose locks 0
innodb simulate comp failures 0
innodb spin wait delay Documentation 6
innodb stats auto update 1
innodb stats method Documentation nulls_equal
innodb stats modified counter 0
innodb stats on metadata Documentation ON
innodb stats sample pages Documentation 8
innodb stats traditional ON
innodb stats update need lock 1
innodb strict mode Documentation OFF
innodb support xa Documentation ON
innodb sync spin loops Documentation 30
innodb table locks Documentation ON
innodb thread concurrency Documentation 0
innodb thread concurrency timer based OFF
innodb thread sleep delay Documentation 10,000
innodb track changed pages OFF
innodb use atomic writes OFF
innodb use fallocate OFF
innodb use global flush log at trx commit ON
innodb use native aio Documentation ON
innodb use stacktrace OFF
innodb use sys malloc Documentation ON
innodb use sys stats table OFF
innodb version Documentation 5.5.59-MariaDB-38.11
innodb write io threads Documentation 4
interactive timeout Documentation 28,800
join buffer size Documentation 128 KiB
join buffer space limit 2,097,152
join cache level 2
keep files on create Documentation OFF
key buffer size Documentation 128 MiB
key cache age threshold Documentation 300
key cache block size Documentation 1 KiB
key cache division limit Documentation 100
key cache segments 0
large files support Documentation ON
large page size Documentation 0 B
large pages Documentation OFF
lc messages Documentation en_US
lc messages dir Documentation
lc time names Documentation en_US
license Documentation GPL
local infile Documentation OFF
lock wait timeout Documentation 31,536,000
locked in memory Documentation OFF
log Documentation OFF
log bin Documentation OFF
log bin trust function creators Documentation OFF
log error Documentation /var/log/mariadb/mariadb.log
log output Documentation FILE
log queries not using indexes Documentation OFF
log slave updates Documentation OFF
log slow filter admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
log slow queries Documentation ON
log slow rate limit 1
log slow verbosity
log warnings Documentation 1
long query time Documentation 5
low priority updates Documentation OFF
lower case file system Documentation OFF
lower case table names Documentation 0
master verify checksum Documentation OFF
max allowed packet Documentation 1,048,576
max binlog cache size Documentation 16 EiB
max binlog size Documentation 1 GiB
max binlog stmt cache size Documentation 16 EiB
max connect errors Documentation 10
max connections Documentation 1,024
max delayed threads Documentation 20
max error count Documentation 64
max heap table size Documentation 1 GiB
max insert delayed threads Documentation 20
max join size Documentation 18,446,744,073,709,551,616
max length for sort data Documentation 1,024
max long data size Documentation 1,048,576
max prepared stmt count Documentation 16,382
max relay log size Documentation 0 B
max seeks for key Documentation 4,294,967,295
max sort length Documentation 1,024
max sp recursion depth Documentation 0
max tmp tables Documentation 32
max user connections Documentation 0
max write lock count Documentation 4,294,967,295
metadata locks cache size Documentation 1,024
min examined row limit Documentation 0
mrr buffer size 262,144
multi range count Documentation 256
myisam block size 1,024
myisam data pointer size Documentation 6 B
myisam max sort file size Documentation 8 EiB
myisam mmap size Documentation 16 EiB
myisam recover options Documentation DEFAULT
myisam repair threads Documentation 1
myisam sort buffer size Documentation 8 MiB
myisam stats method Documentation nulls_unequal
myisam use mmap Documentation OFF
net buffer length Documentation 16,384
net read timeout Documentation 30
net retry count Documentation 10
net write timeout Documentation 60
old Documentation OFF
old alter table Documentation OFF
old mode
old passwords Documentation OFF
open files limit Documentation 4,096
optimizer prune level Documentation 1
optimizer search depth Documentation 62
optimizer switch Documentation 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=off
performance schema Documentation OFF
performance schema events waits history long size Documentation 10,000
performance schema events waits history size Documentation 10
performance schema max cond classes Documentation 80
performance schema max cond instances Documentation 1,000
performance schema max file classes Documentation 50
performance schema max file handles Documentation 32,768
performance schema max file instances Documentation 10,000
performance schema max mutex classes Documentation 200
performance schema max mutex instances Documentation 1,000,000
performance schema max rwlock classes Documentation 30
performance schema max rwlock instances Documentation 1,000,000
performance schema max table handles Documentation 100,000
performance schema max table instances Documentation 50,000
performance schema max thread classes Documentation 50
performance schema max thread instances Documentation 1,000
pid file Documentation /var/run/mariadb/mariadb.pid
plugin dir Documentation /usr/lib64/mysql/plugin/
plugin maturity unknown
port Documentation 3,306
preload buffer size Documentation 32 KiB
profiling Documentation OFF
profiling history size Documentation 15
progress report time 5
protocol version Documentation 10
query alloc block size Documentation 8 KiB
query cache limit Documentation 20 MiB
query cache min res unit Documentation 4,096
query cache size Documentation 128 MiB
query cache strip comments OFF
query cache type Documentation ON
query cache wlock invalidate Documentation OFF
query prealloc size Documentation 8 KiB
range alloc block size Documentation 4 KiB
read buffer size Documentation 128 KiB
read only Documentation OFF
read rnd buffer size Documentation 1 MiB
relay log Documentation
relay log index Documentation
relay log info file Documentation relay-log.info
relay log purge Documentation ON
relay log recovery Documentation OFF
relay log space limit Documentation 0
replicate annotate row events OFF
replicate do db
replicate do table
replicate events marked for skip replicate
replicate ignore db
replicate ignore table
replicate wild do table
replicate wild ignore table
report host Documentation
report password Documentation
report port Documentation 3,306
report user Documentation
rowid merge buff size 8,388,608
rpl recovery rank Documentation 0
secure auth Documentation OFF
secure file priv Documentation
server id Documentation 0
skip external locking Documentation ON
skip name resolve Documentation OFF
skip networking Documentation OFF
skip show database Documentation OFF
slave compressed protocol Documentation OFF
slave exec mode Documentation STRICT
slave load tmpdir Documentation /var/tmp
slave max allowed packet Documentation 1,073,741,824
slave net timeout Documentation 3,600
slave skip errors Documentation OFF
slave sql verify checksum Documentation ON
slave transaction retries Documentation 10
slave type conversions Documentation
slow launch time Documentation 2
slow query log Documentation ON
slow query log file Documentation server-slow.log
socket Documentation /var/lib/mysql/mysql.sock
sort buffer size Documentation 8 MiB
sql auto is null Documentation OFF
sql big selects Documentation ON
sql big tables Documentation OFF
sql buffer result Documentation OFF
sql log bin Documentation ON
sql log off Documentation OFF
sql low priority updates Documentation OFF
sql max join size Documentation 18,446,744,073,709,551,616
sql mode Documentation
sql notes Documentation ON
sql quote show create Documentation ON
sql safe updates Documentation OFF
sql select limit Documentation 18,446,744,073,709,551,616
sql slave skip counter Documentation 0
sql warnings Documentation OFF
ssl ca Documentation
ssl capath Documentation
ssl cert Documentation
ssl cipher Documentation
ssl key Documentation
storage engine Documentation InnoDB
stored program cache Documentation 256
sync binlog Documentation 0
sync frm Documentation ON
sync master info Documentation 0
sync relay log Documentation 0
sync relay log info Documentation 0
system time zone Documentation BST
table definition cache Documentation 1,024
table open cache Documentation 1,600
thread cache size Documentation 128
thread concurrency Documentation 10
thread handling Documentation one-thread-per-connection
thread pool idle timeout 60
thread pool max threads 500
thread pool oversubscribe 3
thread pool size 8
thread pool stall limit 500
thread stack Documentation 294,912
time format Documentation %H:%i:%s
time zone Documentation SYSTEM
timed mutexes Documentation OFF
tmp table size Documentation 1 GiB
tmpdir Documentation /var/tmp
transaction alloc block size Documentation 8 KiB
transaction prealloc size Documentation 4 KiB
tx isolation Documentation REPEATABLE-READ
unique checks Documentation ON
updatable views with limit Documentation YES
userstat OFF
version Documentation 5.5.60-MariaDB
version comment Documentation MariaDB Server
version compile machine Documentation x86_64
version compile os Documentation Linux
wait timeout Documentation 28,800
