d @ H5R L d 9vH5S L8 0 H|$Hþ8 HHHT$HCHHSHt$LwH$8 dH3%( H H@ []A\f H5,R LyD
^c Eu DVc EtXH5R LR D H5Q L9D c EuDc EH5Q L=y @ f ATH5 T AH=
z USH dH%( H$ 1H5Q H=y r
xb H @ LQ 1Aٹ H= H={y H;!b 9w
b t H5P H=Qy a 9va H f9wlLP 1Aٹ H.= ` H=x Ha 9vH5x H$ dH3%( H H []A\ =Qw ug=Iw u^8 0 H=w Hþ8 HHHHw HHC=w u
=v TCR H5O H=w UH_ H
< H816 \ffffff. SHHp }?$ @ I
V upH)O L
O LO H
O H5; H$H;_ H11f. # ( f vuv 1H[f D + t@K uH}N HHDH^ H1H[Ã#uv 1H[ @ HH5N^ Hu 1H[ u 1H[ÐH i^ H$N L
N L N H
N H5: H$ 1HH=M H=: H=4; HH5M 1H5r^ H=M H=^ R1k HI] H;tlHtWH=pt HHWt ; t H xH8 u; tC t q t ^ @ H N ffffff. AWE1AVAUATUSHH( H<$Lt$dH%( H$ 18 ( HD$lHHH $~ L) H߉HEHE HE H|I)LeDHEJ\+sHH 8 ( P% HAHE Hž, H%HItUM HI)LL: LHF LHNLmHE df H$HD$H9tY: HHtxHƺ H)HuH<$ HE HEHT$H|H4 H)HuHEAH$ dH3%( DuH( []A\A]A^A_d @ HD$ HHEHHE f AWH5L AVAUATUSHH H\$dH%( H$8 1HH5J HW=q =q s Dr 1E =[ Ld$0 tz [LJ I 1 LX= LHZ 9w
5Z tH5`I HZ 9vZ Ld$0L5M A IIl$~f D L D HL$HHL$IHH HH)H)A6HH9uH5TK H~ LHH50K HY D9 AA9iH5I H8 0 H|$Hž8 HHE HT$HEHHUHt$fH.H$8 dH3%( H HH []A\A]A^A_H5G H3H5H H߃!9-p v%tH5G HX =X u
=X
H5G HH5uH H=X u
=X hH5GG HTH57H H=gX u
=bX "H5G H]HW H-5 H816 \ @ AWH5LI AVAUATUSH L|$0dH%( H$ 1LH5G LD W E Lt$P D LtG H$A1 L= LLv\W 9w DUW EtH5F L,2W 9vD
(W E H$` Lt$PH J A IHHT$ H~)ЉD$, HL$ HL$.HHL$IHH HH)H)3HH9uHT$ D$,LuF E LHT$$ 1= LLdNV D9 AA9X=l uV=l uM8 0 7H|$8Hþ8 H!HHT$8HHS=zl u =rl uCH5E LCHt$0HLH$ dH3%( HuXH []A\A]A^A_H59D LcmU #H!U H2 H81[ @ AUATIUSHHtvHVHtmHH[(Ht_HSHtV=wk AH+uo=`l NIcHLulLtLHpH[(Hu H1[]A\A] H5D H 1H5{D H 1LHLCH$H1 HS L HH T H81F l @ Hl$Ld$LD Ll$H\$H8 dH%( H$ 1IIH HS=Dj Au=0k VIcHL` 1H$ dH3%( ueH$ H$ L$( L$0 H8 H5[C H 1f D H5;C H 1LIHR H0 I HHR H81 *fAWLB IIAVAUATI̹ UH SHH@ H$0 HT$ dH%( H$8@ 1H
=i A~H5B 1=h H =i IcHL =h =i HLiU MtVM $LKB 1 Hh=Yh =Bi HcHLn: HT$ kh H\$1HT$) @ IcLL:< Hٿ 13H5> Hٿ 1 \LIHQN Hz, IHHUN H81 LTIHN Hc, HHN H81Z LIHM IH+ H AWAVAUA8 ATUSHh dH%( H$X 1fe H|$HT$0H<@HH$ HD$` 1HHT$hHH
1e HHL$(u H@e H D1HHD$(5d HD$`=`M L$ H$ H$ H$ D$ L$ L$ HD$H$ HT$8HL$PH\$XHD$@L|$H @ Hc HtHL$0H5L H|$=Gd ~H56= 1=Kc u =Cc tn=!c u)H|$0 HT$0H5= H:H HK 8 H H
L H={* H1HFHE c H=b Ht
H5b Ht
H|$HL$(Hb LH$ H$ Q L$H=EK 8H-aK H=K E H 7K H=hK Et1L|$H1ېH LLL E A9wH=J SL;H= K HJ H=J &H=J H|$81nH=J rM t|Dl$ MH LJ MLl$PLd$X 1L.H$ H$ HH5,J HH$ Hi LH$ 1E uDl$ MMH=I sH|$@1H$ +$ MbH$ +$ i )HL$HcDiHH\$(HYH5` Ht
H|$H=` Ht
r =s` u =k` tWH-I H} tIH sI 1MMIHHf. I$HH5D H=24 HH5HD$ H
qHD HHH[ =U[ t
E[ =C[ t
2[ H=Z .
=#[ uH=[ k C =Z tRH=[ H=Z kZ t
=_Z HC :k H=Y[ i
H Y H#5 HHDHڄt*f. <,HuH< 8 1lL%B II$ @
H1YI^A, HHIu1Hߺ
(H YB AH; t1H;Y ?-t
1ҾA HB n
=%Y tdY H
B H8H H$ H$ 1
H8H$ [B HCHt
1HwH$ IY Hu9f. HH;Hk HtH{HtHHuHrA H8H H$ AH$ 1
H8H$ A H{H
1H$ X Hu 5f D HH;Hk Ht H5U HH==V ~H5/ 1H=U Ht H5U =U t1PHT =CU H=}> |$,U H$ H=
U =T D U EW H8 H1=T uEHQT D
RT H
NT HOT E1H5MT H|$HH$\H H=4= 1L$ H== 1H=`= 1H=B= 1H tT @ =T ~H5. 1I$A 0P I
A6tHHIu== @ Ht H[ HuH=~< H=Z< H=< H=< =NS H=)S HtI<$H 7S Hu!HH;Hk(HtdH\HuH (S Hu"HH;Hk(Ht4H,HuH R Hu"HH;Hk(HtHHuH R Hu"HH;Hk(HtHHuH R Hu0HH;Hk HtH{HtHHuH=S =R 1H$% dH3%( H% []A\A]A^A_H=(S H Ht$01+H* D$H% = & H=R 1Ҿ ; H|$`8 H-HT$`1HƉH9HD$`1 H: H5aQ HHH=Q HlHt$01zH D$H% = H=Q 1Ҿ H|$`8 H|HT$`1HƉHHD$`1 H=6Q t"H-: H5P HHP H D DHHAAuH9 L) 1 LHT$IѺ ,= P A =Q ~IcLH5bHUIH+9 LD$IM H H81\ H=P IM H) b .P H5) L 1MeH5( L 10HHO HL
vO LwO HH
uO HvO H5wO :P1Ҿ H/1#H'8 H8 H(8 =O ~H5 1u1FH=O HHN 1H1H HE(H; O r=kN IM H H{7 H81輿 =\N =N ~H5 1ĿH=N HHN
1HHHE(H; N rH=N HHM 1HHHE(H; N rH' HPM H=M HDH6 H5eM )H=M HH6 H5JM Z=M ~H5m 1 H=M HHL 1Hſ HbHE(H; M rH=M HRH6 H5L 7H=L HH5 H5L HNL H衿IHw5 IM H H81譽H=L 1z 蹽IM H6 H"5 IM HV& H81XH4 LH IM H812 XIM HU FIM Hm 6IM H} &胿IM H@ IM H ff. AWIAVAUATUSHH H e4 dH%( H$8 1HH- 4 DU Et L%#4 HL}DM EuHL1ռHHk d =J =K Z D K E HT$0E1E1HT$(I/Hb H} W E1=IJ u'
EK t 1҉LHHS f. E< H
2 H9 t/ fHPuIH$tHHHHD$ fH|$ >HuH|$ HtJ It
AD9 IGHt I9E Hm(Hy H} n If <<=II HULE A =)J IcLHU!HuLEH$LM H*2 H HH,2 H81r1蛺HL$豽HL$1LMH|$(Lx# H1H1 H Hк HD$HE H$1脽=uH D$ P =\I " HcT$ Ht$(H脺PH褻LL$(H$DD$ (f H耻HHD$蓺AH11 LL$H HH.1 H81tH1HHv HG D
G A L91 H
G HHG H5G LT$H$蓺HR 0A H3G L0 LL$H
0G HD
G H'G H5(G H$?H ܺA HF D
F LD$H
F HL0 HF H5F H$H 舺HF D
F L>0 H
F HF H5F H|$HH$蘹HW 5 H9F D
:F Ht$L/ HH
,F H-F H5.F H$EH HE D
E HL$L/ HH
E HE H5E H$H 菹 HE D
E HT$L@/ HH
E HE H5E H$蟸H^ < D
HE L. HD$H
=E HH#E H4E H55E H$LH HD D
D A L. H
D HHD H5D L\$H$H 蕸HD D
D A LJ. H
D HHD H5D LT$H$褷Hc AHٷHHAH- Hm I HH- H81ѵD
2E E ="D uH`+H - HH%- H=, (覵Hn1H$8 dH3%( HH []A\A]A^A_À=C =D H5j HE1µH5 L 1LD$T$>DL$LD$,H5 L 1HHL$(T$ H5 1HL$(H5 ¿ 1ٴIGHI9|H
H5U 1蚴 H
H51 1E1s=B =zC H5E H蠴:=\B =GC n H5k HmH5 1A HA D
A LD$H
A HL+ HA H5A H$H7 臵HA D
A HL?+ H
A HA H5A Hl$H$蜴H 9HBA D
CA L* H
8A H9A H5:A H|$HH$IH H@ D
@ Ht$L* HH
@ H@ H5@ H$H> 蓴 H@ D
@ HL$LD* HH
@ H@ H5@ H$裳H @ HD@ D
E@ HT$L) HH
7@ H8@ H59@ H$PH D
? L) HD$H
? HH? H? H5? H$HE A 蔳H? D
? HLL) H
? H? H5? Lt$H$該H A @HI? D
J? HL( H
A? HB? H5C? Ll$H$UH A H> D
> HL( H
> H> H5> Ld$H$H]DH
H5O 1蔰nH
H5+ 1pH
\ H5 1LH
8 H5 1("n1 @ 裱IHa' H HHh' H81詯1үHjIH(' H HŐfffff. Hl$Ld$H-! L%! Ll$Lt$L|$H\$H8L)AIHI蛮Ht 1 @ LLDAHH9rH\$Hl$Ld$Ll$ Lt$(L|$0H8ÐUHSHH! HtH ! HHHuH[ÐH?H %s: Error when connecting to server: %d %s
%s,%s,%ld.%03ld,%ld.%03ld,%ld.%03ld,%d,%llu
Average number of seconds to run all queries: %ld.%03ld seconds
Minimum number of seconds to run all queries: %ld.%03ld seconds
Maximum number of seconds to run all queries: %ld.%03ld seconds
Number of clients running queries: %d
Average number of queries per client: %llu
Memory Allocation error in create table
intcol%d INT(32), INDEX(intcol%d) charcol%d VARCHAR(128), INDEX(charcol%d) Memory Allocation error in creating table
Memory Allocation error in creating select
%s Ver %s Distrib %s, for %s (%s)
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license.
Run a query multiple times against the server.
Memory Allocation error in creating insert
Memory Allocation error in creating update
%s: Cannot run query %.*s ERROR : %s
%s: Cannot drop database '%s' ERROR : %s
%s: Cannot create schema %s : %s
%s: Cannot select schema '%s': %s
%s: Cannot set default engine: %s
796c4422-1d94-102a-9d6d-00e0812d %s: Cannot select GUID primary keys. (%s)
%s: Error when storing result: %d %s
Warning: Execution of pre_system option returned %d.
Warning: Execution of post_system option returned %d.
%s: Can't use --auto-generate-sql when create and query strings are specified!
%s: Either auto-generate-sql-guid-primary or auto-generate-sql-add-autoincrement can be used!
%s: Can't perform key test without a primary key!
%s: Either auto-generate-sql-execute-number or number-of-queries can be used!
%s: Could not open csv file: %sn
Building Create Statements for Auto
Building Query Statements for Auto
Generating SELECT Statements for Auto
Generating SELECT for keys Statements for Auto
Generating INSERT Statements for Auto
%s: Create file was not a regular file
%s: Could not open create file
%s: User query supplied file was not a regular file
%s: Could not open query supplied file
%s: Error when connecting to server: %s
%s: mysql_init() failed ERROR : %s
%s: mysql_thread_init() failed ERROR : %s
Generate SQL where not supplied by file or command line. auto-generate-sql-add-autoincrement Add an AUTO_INCREMENT column to auto-generated tables. auto-generate-sql-execute-number Set this number to generate a set number of queries to run. auto-generate-sql-guid-primary Add GUID based primary keys to auto-generated tables. Specify test load type: mixed, update, write, key, or read; default is mixed. auto-generate-sql-secondary-indexes Number of secondary indexes to add to auto-generated tables. auto-generate-sql-unique-query-number Number of unique queries to generate for automatic tests. auto-generate-sql-unique-write-number Number of unique queries to generate for auto-generate-sql-write-number. auto-generate-sql-write-number Number of row inserts to perform for each thread (default is 100). Commit records every X number of statements. Use compression in server/client protocol. Number of clients to simulate for query to run. File or string to use create tables. Generate CSV output to named file or to stdout if no file is named. This is a non-debug version. Catch this and exit. Check memory and open file usage at exit. Print some debug info at exit. Delimiter to use in SQL statements supplied in file or command line. Detach (close and reopen) connections after X number of requests. Storage engine to use for creating the table. Number of times to run the tests. Do not drop the schema after the test. Number of VARCHAR columns to create in table if specifying --auto-generate-sql. Number of INT columns to create in table if specifying --auto-generate-sql. Limit each client to this number of queries (this is not exact). Do not connect to the databases, but instead print out what would have been done. Password to use when connecting to server. If password is not given it's asked from the tty. Port number to use for connection. Query to run or file containing query to execute after tests have completed. system() string to execute after tests have completed. Query to run or file containing query to execute before running tests. system() string to execute before running tests. The protocol to use for connection (tcp, socket, pipe, memory). Query to run or file containing query to run. Run program in silent mode - no output. The socket file to use for connection. Enable SSL for connection (automatically enabled with other flags).Disable with --skip-ssl. CA file in PEM format (check OpenSSL docs, implies --ssl). CA directory (check OpenSSL docs, implies --ssl). X509 cert in PEM format (implies --ssl). SSL cipher to use (implies --ssl). X509 key in PEM format (implies --ssl). Verify server's "Common Name" in its cert against hostname used when connecting. This option is disabled by default. User for login if not current user. More verbose output; you can use this multiple times to get even more verbose output. Output version information and exit. Benchmark
Running for engine %s
CREATE TABLE `t1` ( id serial , id varchar(32) primary key id%d varchar(32) unique key intcol%d INT(32) charcol%d VARCHAR(128) SELECT intcol%d charcol%d FROM t1 WHERE id = - debian-linux-gnu 5.1.63 1.0 x86_64 Copyright (C) 2005 MySQL AB Usage: %s [OPTIONS]
my INSERT INTO t1 VALUES ( NULL uuid() UPDATE t1 SET intcol%d = %ld charcol%d = '%.*s' %.*s;
DROP SCHEMA IF EXISTS `%s` CREATE SCHEMA `%s` Loading Pre-data
use %s;
set storage_engine=`%s` %s %s Generating primary key list
blackhole SELECT id from t1 SET AUTOCOMMIT=0 %s: Could not create thread
Generating stats
root Parsing engines to use.
%s: Too many arguments
Starting Concurrency Test
connected!
%.*s '%s' COMMIT mysqlslap mixed d:t:o,/tmp/mysqlslap.trace client latin1 help Display this help and exit. auto-generate-sql auto-generate-sql-load-type commit compress concurrency create create-schema Schema to run tests in. csv debug debug-check debug-info delimiter detach engine host Connect to host. iterations no-drop number-char-cols number-int-cols number-of-queries only-print password port post-query post-system pre-query pre-system protocol silent socket ssl ssl-ca ssl-capath ssl-cert ssl-cipher ssl-key ssl-verify-server-cert user verbose version 0123456789ABCDEFGHIJKLMNOPQRSTWXYZabcdefghijklmnopqrstuvwxyz ; ` @@ ` @ @ p ` 0 P P PH zR x 4 X AGCD0 T 8 AAD E t F AAD E (u AGG@ & AJCI , BEFB A(CA0F 4 ( BCBCF CB(A0A8CDP 4 < BCBB B(CE0A8CG@ , t Ȣg BCBDB GA(JA0C $ BRA G@E $ BJRA G@S ha ACD 4 BCBB B(A0A8CG@ 4 L | BSB B(A0A8GAE 4 Ȱ BSB B(A0A8GBE , p BBCA A(D@E P> b@Y 4 p BMBB B(CF0CF8GH4 D - BBB CG(A0A8Gk 4 | % BBB B(A0A8GLG 4 D
BCBB B(A0A8GAG $ Q_@F $ 7
o `
U Ь 0 X @ o o o o o 7 7 7 7 8 8 .8 >8 N8 ^8 n8 ~8 8 8 8 8 8 8 8 8 9 9 .9 >9 N9 ^9 n9 ~9 9 9 9 9 9 9 9 9 : : .: >: N: ^: n: ~: : : : : : : : : ; ; .; >; N; ^; n; ~; ; ; ; ; ; ; ; ; < < .< >< N< ^< n< 0 8 @ p x | 0k T g q w g ? a В O 0 Q X P ӡ M @ R h T Д
S 8
N d Y C c P L J 8 K < # B c ( N T X Y F x c Z j e @ @ q h v i 8 [ ` x y ؘ C ( ͢ ? p آ p ș P ( p p V P 8 8 X U ؚ 0 0 W + X q s ț " S h h ) - ! x 4 " ? H # S H [ a p r u w v V h .shstrtab .interp .note.ABI-tag .note.gnu.build-id .gnu.hash .dynsym .dynstr .gnu.version .gnu.version_r .rela.dyn .rela.plt .init .text .fini .rodata .eh_frame_hdr .eh_frame .ctors .dtors .jcr .data.rel.ro .dynamic .got .data .bss 8 8 T T ! t t $ 8 4 o l > F ` ` U N o [ o j X X @ t 0 0
~ 7 7 y 7 7 < < M = , p p 0 Ь Ь 0 @ @ @ @