Variable Wert für diese Sitzung / Globaler Wert
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 |
auto increment increment 1 auto increment offset 1 automatic sp privileges ON back log 50 basedir /usr/local/mysql-5.0.92/ binlog cache size 32,768 bulk insert buffer size 8,388,608 character set client utf8 character set connection utf8 character set database utf8 character set filesystem binary character set results utf8 character set server utf8 character set system utf8 character sets dir /usr/local/mysql-5.0.92/share/mysql/charsets/ collation connection utf8_unicode_ci (Globaler Wert) utf8_general_ci collation database utf8_general_ci collation server utf8_general_ci completion type 0 concurrent insert 1 connect timeout 60 datadir /var/lib/mysql_data/3/ 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 keep files on create OFF engine condition pushdown OFF expire logs days 0 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 YES have compress YES have community features YES have profiling YES have crypt YES have csv YES have dynamic loading YES have example engine NO have federated engine YES have geometry YES have innodb YES have isam NO have merge engine YES have ndbcluster NO have openssl NO have ssl NO have query cache YES have raid NO have rtree keys YES have symlink YES hostname p3nlhdb5030-05.shr.prod.phx3.secureserver.net init connect init file init slave innodb additional mem pool size 10,485,760 innodb autoextend increment 8 innodb buffer pool awe mem mb 0 innodb buffer pool size 134,217,728 innodb checksums ON innodb commit concurrency 0 innodb concurrency tickets 500 innodb data file path ibdata1:10M:autoextend innodb data home dir /var/lib/mysql_data/3 innodb adaptive hash index ON innodb doublewrite ON innodb fast shutdown 1 innodb file io threads 4 innodb file per table ON innodb flush log at trx commit 0 innodb show locks held 10 innodb show verbose locks 0 innodb flush method O_DIRECT 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 8,388,608 innodb log file size 67,108,864 innodb log files in group 2 innodb log group home dir /var/lib/mysql_data/3 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 OFF innodb sync spin loops 20 innodb table locks ON innodb thread concurrency 8 innodb thread sleep delay 10,000 innodb io capacity 200 innodb ibuf max size 67,108,864 innodb ibuf active contract 0 innodb ibuf accel rate 100 innodb flush neighbor pages 1 innodb read ahead both innodb enable unsafe group commit 0 innodb adaptive checkpoint none innodb read io threads 8 innodb write io threads 8 innodb use sys malloc ON innodb fast recovery OFF innodb thread concurrency timer based OFF innodb extra rsegments 0 innodb dict size limit 0 innodb io pattern trace 0 innodb io pattern trace running 0 innodb io pattern size limit 0 innodb use legacy cardinality algorithm ON interactive timeout 60 join buffer size 4,194,304 key buffer size 536,870,912 key cache age threshold 300 key cache block size 1,024 key cache division limit 100 language /usr/local/mysql-5.0.92/share/mysql/english/ 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 error /var/lib/mysql_logs/3/error.log log queries not using indexes OFF log slave updates OFF log slow queries OFF log slow filter log slow rate limit 1 log slow verbosity microtime log warnings 1 long query time 10 low priority updates OFF lower case file system OFF lower case table names 0 max allowed packet 33,554,432 max binlog cache size 18446744073709547520 max binlog size 1,073,741,824 max connect errors 10,000 max connections 1,000 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 200 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 mmap size 18446744073709551615 myisam recover options FORCE myisam repair threads 1 myisam sort buffer size 134,217,728 myisam stats method nulls_unequal net buffer length 8,192 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/mysql/3.pid plugin dir port 3,306 preload buffer size 32,768 profiling OFF profiling history size 15 profiling server OFF profiling use getrusage OFF protocol version 10 query alloc block size 8,192 query cache limit 1,048,576 query cache min res unit 4,096 query cache size 67,108,864 query cache type ON query cache wlock invalidate OFF query prealloc size 8,192 range alloc block size 4,096 read buffer size 4,194,304 read only OFF read rnd buffer size 4,194,304 relay log /var/lib/mysql_logs/3/p3nlhdb5030-05-relay-bin relay log index /var/lib/mysql_logs/3/p3nlhdb5030-05-relay-bin.index relay log info file /var/lib/mysql_data/3/relay-log.info relay log purge ON relay log space limit 0 rpl recovery rank 0 secure auth OFF secure file priv server id 1 skip external locking ON skip networking OFF skip show database OFF slave compressed protocol OFF slave load tmpdir /tmp/mysqltmp/ 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 socket /var/run/mysql/3.sock sort buffer size 4,194,304 sql big selects ON sql mode sql notes ON 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 MST table cache 10,000 table lock wait timeout 50 table type MyISAM thread cache size 100 thread stack 262,144 time format %H:%i:%s time zone SYSTEM timed mutexes OFF tmp table size 8,388,608 tmpdir /tmp/mysqltmp/ transaction alloc block size 8,192 transaction prealloc size 4,096 tx isolation READ-COMMITTED updatable views with limit YES userstat running OFF use global long query time OFF version 5.0.92-log version comment MySQL Community Server (GPL) version compile machine x86_64 version compile os unknown-linux-gnu wait timeout 60 |