Focus On Oracle

Installing, Backup & Recovery, Performance Tuning,
Troubleshooting, Upgrading, Patching

Oracle Engineered System


当前位置: 首页 » 技术文章 » MySQL

MySQL and Oracle Enterprise Manager

用Oracle Enterprise Manager来监控MySQL还是不错的。Oracle网站有个demo的虚拟机,有兴趣的可以点击下载


模拟MySQL压力的脚本

#!/bin/bash
FREQUENCY_SECS=30
DURATION_MINS=3
TOTAL_TIMES=$(((60*DURATION_MINS)/FREQUENCY_SECS))
ROUNDS=6
SLEEP_BETWEEN_ROUND=150

for i in `seq 1 $ROUNDS`;
do
echo "round $i/$ROUNDS"
echo "stressing db every $FREQUENCY_SECS seconds... (for $DURATION_MINS minutes)."

for j in `seq 1 $TOTAL_TIMES`;
do
        echo "stress $j/$TOTAL_TIMES"
mysqlslap --concurrency=35 --iterations=20 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --protocol=tcp --host=localhost --port=3306 --user=root --password=welcome1
echo "sleeping... $FREQUENCY_SECS seconds"
        sleep $FREQUENCY_SECS
done
echo "finished round $i, sleeping... $SLEEP_BETWEEN_ROUND seconds"
sleep $SLEEP_BETWEEN_ROUND
done
echo "finished." 


Reference

https://dev.mysql.com/doc/mysql-em-plugin/en/
http://www.oracle.com/technetwork/community/developer-vm/mysql-oem-vm-2355166.html
http://www.oracle.com/technetwork/cn/community/developer-vm/mysql-oem-vm-2355166-zhs.html

关键词:em mysql 

相关文章

MySQL and Oracle Enterprise Manager
MySQL Tools for performance, backup, monitor
MySQL Multi-Master Single-Slave Replication
MySQL and GPL
MySQL monthly report from alibaba
MySQL备份
MySQL配置文件my.cnf
MySQL数据类型
MySQL字符集
MySQL入门
MySQL的基本架构
关于MySQL,你需要了解的

联系我们

韩朝阳



    Phone:186-9589-1286

    E-mail:ohsdba@qq.com

    微  信: ohsdba


电话(186-9589-1286)

QQ(375349564)

微信(ohsdba)


常用链接

Oracle Database Upgrade

Oracle

eDelivery
My Oracle Support

Exadata 12.1 Document

Exadata 12.2 Document

Oracle 11gR2 Document

Oracle 12cR1 Document

Oracle 12cR2 Document

GoldenGate 12c

Oracle Fusion Middleware

Mysql Document

PostgreSQL

Python

github

sourceforge



Top
Cell186-9589-1286
QQ 375349564
E-mail ohsdba@qq.com