| 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 |
Server: localhost
Server variables and settings
Databases
SQL
Status
Charsets
Engines
Processes
Export
Import
Open new phpMyAdmin window