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
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
|
# Instances ##################################################
Port Data Directory Nice OOM Socket
===== ========================== ==== === ======
12345 /tmp/12345/data 0 0 /tmp/12345/mysql_sandbox12345.sock
12346 /tmp/12346/data 0 0 /tmp/12346/mysql_sandbox12346.sock
12347 /tmp/12347/data 0 0 /tmp/12347/mysql_sandbox12347.sock
# MySQL Executable ###########################################
Path to executable | /home/hugmeir/mysql5/mysqlbrew/mysqls/Percona-Server-5.1/libexec/mysqld
Has symbols | Yes
# Report On Port 12345 #######################################
User | msandbox@%
Time | 2012-03-30 22:33:19 (ART)
Hostname | hugmeir
Version | 5.1.61rel13.2-log Percona Server with XtraDB (GPL), Release rel13.2, Revision 430
Built On | pc-linux-gnu i686
Started | 2012-03-30 21:45 (up 0+00:48:00)
Databases | 3
Datadir | /tmp/12345/data/
Processes | 2 connected, 2 running
Replication | Is not a slave, has 1 slaves connected
Pidfile | /tmp/12345/data/mysql_sandbox12345.pid (exists)
# Processlist ################################################
Command COUNT(*) Working SUM(Time) MAX(Time)
------------------------------ -------- ------- --------- ---------
Binlog Dump 1 1 3000 3000
Query 1 1 0 0
User COUNT(*) Working SUM(Time) MAX(Time)
------------------------------ -------- ------- --------- ---------
msandbox 2 2 3000 3000
Host COUNT(*) Working SUM(Time) MAX(Time)
------------------------------ -------- ------- --------- ---------
localhost 2 2 3000 3000
db COUNT(*) Working SUM(Time) MAX(Time)
------------------------------ -------- ------- --------- ---------
NULL 2 2 3000 3000
State COUNT(*) Working SUM(Time) MAX(Time)
------------------------------ -------- ------- --------- ---------
Has sent all binlog to slave; 1 1 3000 3000
NULL 1 1 0 0
# Status Counters (Wait 10 Seconds) ##########################
Variable Per day Per second 11 secs
Binlog_cache_disk_use 30
Binlog_cache_use 30
Bytes_received 100000000 1250 3000
Bytes_sent 150000000 1750 20000
Com_admin_commands 60
Com_begin 30
Com_change_db 4500 4
Com_commit 30
Com_create_db 30
Com_create_function 90
Com_create_procedure 90
Com_create_table 500
Com_create_trigger 175
Com_create_view 200
Com_drop_db 30
Com_insert 30000
Com_select 22500 6
Com_set_option 30000 30
Com_show_binlogs 500
Com_show_create_db 175
Com_show_create_func 250
Com_show_create_proc 250
Com_show_create_table 8000 8
Com_show_create_trigger 500
Com_show_databases 1000
Com_show_engine_status 1000
Com_show_fields 4000 4
Com_show_function_status 175
Com_show_master_status 500
Com_show_plugins 900
Com_show_procedure_status 175
Com_show_processlist 900
Com_show_slave_status 900
Com_show_status 1500
Com_show_table_status 4000 4
Com_show_tables 350
Com_show_triggers 4000 4
Com_show_variables 1000
Connections 12500 1
Created_tmp_disk_tables 15000 10
Created_tmp_files 175
Created_tmp_tables 50000 20
Flush_commands 30
Handler_commit 1250
Handler_prepare 1000
Handler_read_first 450
Handler_read_key 600
Handler_read_next 2250 2
Handler_read_rnd_next 900000 10 90
Handler_write 2250000 25 80
Innodb_buffer_pool_pages_flushed 20000
Innodb_buffer_pool_read_requests 12500000 150 70
Innodb_buffer_pool_write_requests 7000000 80
Innodb_data_fsyncs 3000
Innodb_data_writes 5000
Innodb_data_written 700000000 9000
Innodb_dblwr_pages_written 12500
Innodb_dblwr_writes 350
Innodb_dict_tables 700
Innodb_log_write_requests 450000 5
Innodb_log_writes 1500
Innodb_os_log_fsyncs 2000
Innodb_os_log_written 200000000 2500
Innodb_pages_created 15000
Innodb_pages_written 20000
Innodb_rows_inserted 1500000 15
Key_read_requests 900000 10 2
Key_write_requests 350000 3
Key_writes 6000
Open_table_definitions 1500
Opened_files 80000 60
Opened_table_definitions 2000
Opened_tables 2250
Queries 125000 1 70
Questions 100000 1 70
Select_scan 20000 15
Sort_scan 175
Table_locks_immediate 4500 1
Threads_created 12500 1
Uptime 90000 1 1
# Table cache ################################################
Size | 64
Usage | 60%
# Key Percona Server features ################################
Table & Index Stats | Disabled
Multiple I/O Threads | Enabled
Corruption Resilient | Disabled
Durable Replication | Disabled
Import InnoDB Tables | Disabled
Fast Server Restarts | Disabled
Enhanced Logging | Disabled
Replica Perf Logging | Disabled
Response Time Hist. | Disabled
Smooth Flushing | Enabled
HandlerSocket NoSQL | Not Supported
Fast Hash UDFs | Unknown
# Percona XtraDB Cluster #####################################
# Plugins ####################################################
InnoDB compression | ACTIVE
# Query cache ################################################
query_cache_type | ON
Size | 0.0
Usage | 0%
HitToInsertRatio | 0%
# Schema #####################################################
Database Tables Views SPs Trigs Funcs FKs Partn
mysql 21
sakila 16 7 3 6 3 22
Database MyISAM InnoDB
mysql 21
sakila 8 15
Database BTREE FULLTEXT
mysql 29
sakila 63 1
c t s e l d i t s t b v b y d m
h i e n o a n i m e i a l e e e
a m t u n t t n a x g r o a c d
r e m g e y l t i c b r i i
s b t i l n h m u
t l i n i t a a m
a o m t n r l i
m b e t n
p t
Database === === === === === === === === === === === === === === === ===
mysql 58 7 6 77 5 4 19 2 3 2 8 1 4
sakila 1 15 1 3 4 2 19 26 4 45 1 1 7 2
# Noteworthy Technologies ####################################
Full Text Indexing | Yes
Geospatial Types | No
Foreign Keys | Yes
Partitioning | No
InnoDB Compression | No
SSL | No
Explicit LOCK TABLES | No
Delayed Insert | No
XA Transactions | No
NDB Cluster | No
Prepared Statements | No
Prepared statement count | 0
# InnoDB #####################################################
Version | 1.0.17-13.2
Buffer Pool Size | 32.0M
Buffer Pool Fill | 25%
Buffer Pool Dirty | 0%
File Per Table | OFF
Page Size | 16k
Log File Size | 2 * 5.0M = 10.0M
Log Buffer Size | 8M
Flush Method |
Flush Log At Commit | 1
XA Support | ON
Checksums | ON
Doublewrite | ON
R/W I/O Threads | 4 4
I/O Capacity | 200
Thread Concurrency | 0
Concurrency Tickets | 500
Commit Concurrency | 0
Txn Isolation Level | REPEATABLE-READ
Adaptive Flushing | OFF
Adaptive Checkpoint | estimate
Checkpoint Age | 0
InnoDB Queue | 0 queries inside InnoDB, 0 queries in queue
Oldest Transaction | 0 Seconds
History List Len | 0
Read Views | 1
Undo Log Entries | 0 transactions, 0 total undo, 0 max undo
Pending I/O Reads | 0 buf pool reads, 0 normal AIO, 0 ibuf AIO, 0 preads
Pending I/O Writes | 0 buf pool (0 LRU, 0 flush list, 0 page); 0 AIO, 0 sync, 0 log IO (0 log, 0 chkp); 0 pwrites
Pending I/O Flushes | 0 buf pool, 0 log
Transaction States | 1xnot started
# MyISAM #####################################################
Key Cache | 16.0M
Pct Used | 10%
Unflushed | 0%
# Security ###################################################
Users | 2 users, 0 anon, 0 w/o pw, 0 old pw
Old Passwords | OFF
# Encryption #################################################
Keyring plugins:
'+--------------+---------------+
| PLUGIN_NAME | PLUGIN_STATUS |
+--------------+---------------+
| keyring_file | ACTIVE |
+--------------+---------------+'
# Binary Logging #############################################
Binlogs | 1
Zero-Sized | 0
Total Size | 3.1M
binlog_format | STATEMENT
expire_logs_days | 0
sync_binlog | 0
server_id | 12345
binlog_do_db |
binlog_ignore_db |
# Noteworthy Variables #######################################
Auto-Inc Incr/Offset | 1/1
default_storage_engine |
flush_time | 0
init_connect |
init_file |
sql_mode |
join_buffer_size | 128k
sort_buffer_size | 2M
read_buffer_size | 128k
read_rnd_buffer_size | 256k
bulk_insert_buffer | 0.00
max_heap_table_size | 16M
tmp_table_size | 16M
max_allowed_packet | 1M
thread_stack | 192k
log | OFF
log_error | /tmp/12345/data/mysqld.log
log_warnings | 1
log_slow_queries | OFF
log_queries_not_using_indexes | OFF
log_slave_updates | ON
# Configuration File #########################################
Config File | /tmp/12345/my.sandbox.cnf
[client]
user = msandbox
password = msandbox
port = 12345
socket = /tmp/12345/mysql_sandbox12345.sock
[mysqld]
port = 12345
socket = /tmp/12345/mysql_sandbox12345.sock
pid-file = /tmp/12345/data/mysql_sandbox12345.pid
basedir = /home/hugmeir/mysql5/mysqlbrew/mysqls/Percona-Server-5.1/
datadir = /tmp/12345/data
key_buffer_size = 16M
innodb_buffer_pool_size = 16M
innodb_data_home_dir = /tmp/12345/data
innodb_log_group_home_dir = /tmp/12345/data
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_file_size = 5M
log-bin = mysql-bin
relay_log = mysql-relay-bin
log_slave_updates
server-id = 12345
report-host = 127.0.0.1
report-port = 12345
log-error = mysqld.log
innodb_lock_wait_timeout = 3
# Memory management library ##################################
# The End ####################################################
|
