auto increment increment |
1 |
auto increment offset |
1 |
autocommit |
ON |
automatic sp privileges |
ON |
back log |
50 |
basedir |
/usr/local/ |
big tables |
OFF |
binlog cache size |
32,768 |
binlog format |
STATEMENT |
bulk insert buffer size |
8,388,608 |
character set client |
utf8 |
(Global value) |
cp1251 |
character set connection |
utf8 |
(Global value) |
cp1251 |
character set database |
cp1251 |
character set filesystem |
binary |
character set results |
utf8 |
(Global value) |
cp1251 |
character set server |
cp1251 |
character set system |
utf8 |
character sets dir |
/usr/local/share/mysql/charsets/ |
collation connection |
utf8_unicode_ci |
(Global value) |
cp1251_general_ci |
collation database |
cp1251_general_ci |
collation server |
cp1251_general_ci |
completion type |
0 |
concurrent insert |
1 |
connect timeout |
10 |
datadir |
/var/db/mysql/ |
date format |
%Y-%m-%d |
datetime format |
%Y-%m-%d %H:%i:%s |
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 |
ON |
error count |
0 |
event scheduler |
OFF |
expire logs days |
0 |
flush |
OFF |
flush time |
0 |
foreign key checks |
ON |
ft boolean syntax |
+ -><()~*:""&| |
ft max word len |
84 |
ft min word len |
4 |
ft query expansion limit |
20 |
ft stopword file |
(built-in) |
general log |
OFF |
general log file |
/var/db/mysql/www.log |
group concat max len |
1,024 |
have community features |
YES |
have compress |
YES |
have crypt |
YES |
have csv |
YES |
have dynamic loading |
YES |
have geometry |
YES |
have innodb |
YES |
have ndbcluster |
NO |
have openssl |
DISABLED |
have partitioning |
YES |
have query cache |
YES |
have rtree keys |
YES |
have ssl |
DISABLED |
have symlink |
YES |
hostname |
www.hihosting.ru |
identity |
0 |
ignore builtin innodb |
OFF |
init connect |
|
init file |
|
init slave |
|
innodb adaptive hash index |
ON |
innodb additional mem pool size |
1,048,576 |
innodb autoextend increment |
8 |
innodb autoinc lock mode |
1 |
innodb buffer pool size |
8,388,608 |
innodb checksums |
ON |
innodb commit concurrency |
0 |
innodb concurrency tickets |
500 |
innodb data file path |
ibdata1:10M:autoextend |
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 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 stats on metadata |
ON |
innodb support xa |
ON |
innodb sync spin loops |
20 |
innodb table locks |
ON |
innodb thread concurrency |
8 |
innodb thread sleep delay |
10,000 |
innodb use legacy cardinality algorithm |
ON |
insert id |
0 |
interactive timeout |
28,800 |
join buffer size |
131,072 |
keep files on create |
OFF |
key buffer size |
8,384,512 |
key cache age threshold |
300 |
key cache block size |
1,024 |
key cache division limit |
100 |
language |
/usr/local/share/mysql/english/ |
large files support |
ON |
large page size |
0 |
large pages |
OFF |
last insert id |
0 |
lc time names |
en_US |
license |
GPL |
local infile |
ON |
locked in memory |
OFF |
log |
OFF |
log bin |
OFF |
log bin trust function creators |
OFF |
log bin trust routine creators |
OFF |
log error |
/var/db/mysql/www.hihosting.ru.err |
log output |
FILE |
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 |
1,048,576 |
max binlog cache size |
18446744073709547520 |
max binlog size |
1,073,741,824 |
max connect errors |
10 |
max connections |
151 |
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 |
min examined row limit |
0 |
multi range count |
256 |
myisam data pointer size |
6 |
myisam max sort file size |
9223372036853727232 |
myisam recover options |
OFF |
myisam repair threads |
1 |
myisam sort buffer size |
8,388,608 |
myisam stats method |
nulls_unequal |
myisam use mmap |
OFF |
net buffer length |
16,384 |
net read timeout |
30 |
net retry count |
1,000,000 |
net write timeout |
60 |
new |
OFF |
old |
OFF |
old alter table |
OFF |
old passwords |
OFF |
open files limit |
11,095 |
optimizer prune level |
1 |
optimizer search depth |
62 |
optimizer switch |
index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on |
pid file |
/var/db/mysql/www.hihosting.ru.pid |
plugin dir |
/usr/local/lib/mysql/plugin |
port |
3,306 |
preload buffer size |
32,768 |
profiling |
OFF |
profiling history size |
15 |
protocol version |
10 |
pseudo thread id |
14,364 |
(Global value) |
0 |
query alloc block size |
8,192 |
query cache limit |
1,048,576 |
query cache min res unit |
4,096 |
query cache size |
0 |
query cache type |
ON |
query cache wlock invalidate |
OFF |
query prealloc size |
8,192 |
rand seed1 |
|
rand seed2 |
|
range alloc block size |
4,096 |
read buffer size |
131,072 |
read only |
OFF |
read rnd buffer size |
262,144 |
relay log |
|
relay log index |
|
relay log info file |
relay-log.info |
relay log purge |
ON |
relay log space limit |
0 |
report host |
|
report password |
|
report port |
3,306 |
report user |
|
rpl recovery rank |
0 |
secure auth |
OFF |
secure file priv |
|
server id |
0 |
skip external locking |
ON |
skip networking |
OFF |
skip show database |
OFF |
slave compressed protocol |
OFF |
slave exec mode |
STRICT |
slave load tmpdir |
/var/tmp/ |
slave net timeout |
3,600 |
slave skip errors |
OFF |
slave transaction retries |
10 |
slow launch time |
2 |
slow query log |
OFF |
slow query log file |
/var/db/mysql/www-slow.log |
socket |
/tmp/mysql.sock |
sort buffer size |
2,097,144 |
sql auto is null |
ON |
sql big selects |
ON |
sql big tables |
OFF |
sql buffer result |
OFF |
sql log bin |
ON |
sql log off |
OFF |
sql log update |
ON |
sql low priority updates |
OFF |
sql max join size |
18446744073709551615 |
sql mode |
|
sql notes |
ON |
sql quote show create |
ON |
sql safe updates |
OFF |
sql select limit |
18446744073709551615 |
sql slave skip counter |
|
sql warnings |
OFF |
ssl ca |
|
ssl capath |
|
ssl cert |
|
ssl cipher |
|
ssl key |
|
storage engine |
MyISAM |
sync binlog |
0 |
sync frm |
ON |
system time zone |
MSK |
table definition cache |
256 |
table lock wait timeout |
50 |
table open cache |
64 |
table type |
MyISAM |
thread cache size |
0 |
thread handling |
one-thread-per-connection |
thread stack |
262,144 |
time format |
%H:%i:%s |
time zone |
SYSTEM |
timed mutexes |
OFF |
timestamp |
1,296,453,295 |
tmp table size |
16,777,216 |
tmpdir |
/var/tmp/ |
transaction alloc block size |
8,192 |
transaction prealloc size |
4,096 |
tx isolation |
REPEATABLE-READ |
unique checks |
ON |
updatable views with limit |
YES |
version |
5.1.35 |
version comment |
FreeBSD port: mysql-server-5.1.35 |
version compile machine |
amd64 |
version compile os |
portbld-freebsd7.1 |
wait timeout |
28,800 |
warning count |
0 |