-
Notifications
You must be signed in to change notification settings - Fork 1
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
MySQL #5
Labels
Comments
mysql 报错 root@localhost 不能启动的问题
|
切换mysql目录到 /home/data
|
sysbench 安装
最终解决方案
|
CentOS mysql test
windows mysql testcmd -> MySQL cmdline
|
1 登录及管理
|
2 查询结构生成xml或者html文档
|
3 perl DBI
|
4 python DB
|
sysbench 测试1 cpu 性能测试
cpu测试主要是进行素数的加法运算,在上面的例子中,
2 线程测试
3 磁盘IO性能测试,随机读写和删除
上述参数指定了最大创建16个线程,创建的文件总大小为3G,文件读写模式为随机读。
4 内存测试
上述参数指定了本次测试整个过程是在内存中传输 4G 的数据量,每个 block 大小为 8K。
5 mysql 性能测试prepare data
run test
clean data
以上测试内容参考 MySQL 中文网, 结果为一台1核1G主机测试 |
testing for record table size
statistics the report
|
|
For whole aggregate
|
|
A 数据表大小查询
|
Perl DBI
|
Python DBI
|
OSX mysql cannot load
Then I do with this:
|
|
|
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
安装MySQL
The text was updated successfully, but these errors were encountered: