Browsing articles tagged with " MySQL"
四月
23
2014

MySQL使用AWS SSD效能測試

AWS某些instance有提供SSD,下面是使用m3.medium,並且將MySQL安裝在SSD上面的測試數據

[[email protected] ssd]# time sysbench --test=oltp --mysql-table-engine=innodb --mysql-user=$dbUser --mysql-password=$dbPassword --db-driver=mysql --mysql-db=test --oltp-table-size=1000000 --oltp-table-name=t1 --oltp-nontrx-mode=insert --mysql-socket=/mnt/ssd/mysql/mysql.sock run
sysbench 0.4.12: multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 1

Doing OLTP test.
Running mixed OLTP test
Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases)
Using "BEGIN" for starting transactions
Using auto_inc on the id column
Maximum number of requests for OLTP test is limited to 10000
Threads started!
Done.

OLTP test statistics:
queries performed:
read: 140000
write: 50000
other: 20000
total: 210000
transactions: 10000 (169.49 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 190000 (3220.29 per sec.)
other operations: 20000 (338.98 per sec.)

Test execution summary:
total time: 59.0009s
total number of events: 10000
total time taken by event execution: 58.8980
per-request statistics:
min: 2.65ms
avg: 5.89ms
max: 111.90ms
approx. 95 percentile: 15.02ms

Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 58.8980/0.00

real 0m59.107s
user 0m4.027s
sys 0m9.246s
七月
13
2007

MySQL Certifications: CMA – Exams Available July 18

我剛剛收到MySQL寄來的mail,內容是關於MySQL認證的訊息.我自己是還蠻想要去考的,將信件內容貼上來,有需要的朋友可以參考一下.

The Certified MySQL Associate (CMA) certification will be available
in all Pearson VUE testing centers as of Wednesday, July 18 2007.

For those that haven’t heard about this certification before: It’s a
beginner’s type certification that will not impress hard-core DBAs
with years of experience, but we expect quite a lot of this
certification none the less. The Developer and DBA certifications
are pretty tough, and in many cases go beyond what you need, at
least for an entry-level position. With the Associate certification,
you get good proof that you know the basics of MySQL without
straining yourself or your wallet. At the same time, you get an
excellent stepping stone into the rest of the MySQL certification
program.

The single exam has 50 questions, and lasts for one hour. It’s also
somewhat less expensive than the other exams. Unlike other MySQL
certifications, the Associate exam does not carry a version number
and is regarded as perpetually valid once you have obtained it (we
do, however, expect you to be at home on at least a MySQL v. 4.1
version).

There will not be a separate study guide for this exam. If you
already have the MySQL 5.0 Certification Study Guide (ISBN:
0672328127), you have all you need to study for this exam. The MySQL
Certification Candidate Guide* will tell you just what parts of the
study guide pertain to the Associate certification (as well as all
other practical details you need to know).

If you took part in the Associate Beta exam at the User’s Conference
and passed, your certificate will arrive in a few weeks. We’re still
waiting to have them delivered from the printer.

As always: If you have any questions, feel free to ask on the MySQL
Certification Forum** or drop us an email on [email protected]

Best regards,

/ Carsten

* http://www.mysql.com/certification/candguide#t25
** http://forums.mysql.com/list.php?6


Your company can get volume discounts on MySQL Certification exams:
http://www.vue.com/vouchers/

Carsten Pedersen, Certification Manager
MySQL AB, http://www.mysql.com