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 

相关文章

OGG from MySQL to Oracle
MySQL数据库高可用实践
Install oracle products on docker
MySQL Cookbook for Oracle DBA
MySQL HA - Innodb Cluster
腾讯微信的PhxSQL数据库
MySQL Group Replication(MGR)
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
Top