Os cuento, hace unos cuantos días toqué algunas variables de la configuración de MySql (lo malo es que no recuerdo cuales) y ahora se me ha vuelto muy inestable, más o menos cada 2 días me veo en la obligación de reiniciarlo.
He estado revisando la configuración y me he encontrado con 4 variables que contienen el valor "18446744073709551615". Sinceramente, no se de donde ha salido semejante cantidad, y lo peor de todo es que no se como solucionarlo.
Os agradecería mucho cualquier sugerencia.
PD: Por si os sirve de ayuda, el servidor tiene 8 GB de RAM.
Código PHP:
completion type 0
concurrent insert 1
connect timeout 5
default week format 0
delay key write ON
delayed insert limit 100
delayed insert timeout 300
delayed queue size 1,000
div precision increment 4
engine condition pushdown OFF
expire logs days 10
flush OFF
flush time 0
ft boolean syntax + -><()~*:""&|
ft max word len 84
ft min word len 4
ft query expansion limit 20
ft stopword file (built-in)
group concat max len 1,024
have archive YES
have bdb NO
have blackhole engine NO
have compress YES
have crypt YES
have csv YES
have dynamic loading YES
have example engine NO
have federated engine YES
have geometry YES
have innodb DISABLED
have isam NO
have merge engine YES
have ndbcluster DISABLED
have openssl DISABLED
have query cache YES
have raid NO
have rtree keys YES
have symlink YES
init connect
init file
init slave
innodb additional mem pool size 1,048,576
innodb autoextend increment 8
innodb buffer pool awe mem mb 0
innodb buffer pool size 8,388,608
innodb checksums ON
innodb commit concurrency 0
innodb concurrency tickets 500
innodb data file path
innodb data home dir
innodb doublewrite ON
innodb fast shutdown 1
innodb file io threads 4
innodb file per table OFF
innodb flush log at trx commit 1
innodb flush method
innodb force recovery 0
innodb lock wait timeout 50
innodb locks unsafe for binlog OFF
innodb log arch dir
innodb log archive OFF
innodb log buffer size 1,048,576
innodb log file size 5,242,880
innodb log files in group 2
innodb log group home dir
innodb max dirty pages pct 90
innodb max purge lag 0
innodb mirrored log groups 1
innodb open files 300
innodb rollback on timeout OFF
innodb support xa ON
innodb sync spin loops 20
innodb table locks ON
innodb thread concurrency 8
innodb thread sleep delay 10,000
interactive timeout 28,800
join buffer size 131,072
key buffer size 16,777,216
key cache age threshold 300
key cache block size 1,024
key cache division limit 100
large files support ON
large page size 0
large pages OFF
lc time names en_US
license GPL
local infile ON
locked in memory OFF
log OFF
log bin ON
log bin trust function creators OFF
log queries not using indexes OFF
log slave updates OFF
log slow queries OFF
log warnings 1
long query time 10
low priority updates OFF
lower case file system OFF
lower case table names 0
max allowed packet 16,776,192
max binlog cache size 18446744073709551615
max binlog size 104,857,600
max connect errors 10
max connections 100
max delayed threads 20
max error count 64
max heap table size 16,777,216
max insert delayed threads 20
max join size 18446744073709551615
max length for sort data 1,024
max prepared stmt count 16,382
max relay log size 0
max seeks for key 18446744073709551615
max sort length 1,024
max sp recursion depth 0
max tmp tables 32
max user connections 0
max write lock count 18446744073709551615
multi range count 256
myisam data pointer size 6
myisam max sort file size 9223372036854775807
myisam recover options OFF
myisam repair threads 1
myisam sort buffer size 33,554,432
myisam stats method nulls_unequal
ndb autoincrement prefetch sz 32
ndb force send ON
ndb use exact count ON
ndb use transactions ON
(Valor global) OFF
ndb cache check time 0
net buffer length 16,384
net read timeout 30
net retry count 10
net write timeout 60
new OFF
old passwords OFF
open files limit 65,535
optimizer prune level 1
optimizer search depth 62
pid file /var/run/mysqld/mysqld.pid
port 3,306
preload buffer size 32,768
protocol version 10
query alloc block size 8,192
query cache limit 16,777,216
query cache min res unit 4,096
query cache size 1,610,612,736
query cache type ON
query cache wlock invalidate OFF
query prealloc size 8,192
range alloc block size 2,048
read buffer size 131,072
read only OFF
read rnd buffer size 262,144
relay log purge ON
relay log space limit 0
rpl recovery rank 0
secure auth OFF
server id 1
skip external locking ON
skip networking OFF
skip show database OFF
slave compressed protocol OFF
slave load tmpdir /tmp/
slave net timeout 3,600
slave skip errors OFF
slave transaction retries 10
slow launch time 2
sort buffer size 2,097,144
sql big selects ON
sql notes ON
sql warnings OFF
storage engine MyISAM
sync binlog 0
sync frm ON
system time zone CET
table cache 32,712
table lock wait timeout 50
table type MyISAM
thread cache size 8
thread stack 131,072
time format %H:%i:%s
time zone SYSTEM
timed mutexes OFF
tmp table size 536,870,912
transaction alloc block size 8,192
transaction prealloc size 4,096
tx isolation REPEATABLE-READ
updatable views with limit YES
wait timeout 28,800
