
mysql
文章平均质量分 82
拖拉机拖拉机
这个作者很懒,什么都没留下…
展开
-
InnoDB 引擎独立表空间 innodb_file_per_table
起因:zabbix数据所在的mysql server上有个文件在不断的增大m转载 2014-10-15 09:17:43 · 843 阅读 · 0 评论 -
tokudb 个人整理
Q:Has anyone used the TokuDB storage engine for MySQL?The product web site claims to have a 50x performance increase over other MySQL storage engines (e.g. Innodb, MyISAM, etc). Here are t原创 2015-01-13 22:51:35 · 1006 阅读 · 0 评论 -
MySQL performance: Impact of memory allocators (Part 2)
Last time I wrote about memory allocators and how they can affect MySQL performance in general. This time I would like to explore this topic from a bit different angle: What impact does the number o原创 2015-01-14 21:04:06 · 820 阅读 · 0 评论 -
Testing TokuDB – Faster and smaller for large tables
For the past two months, I have been running tests on TokuDB in my free time. TokuDB is a storage engine put out by Tokutek. TokuDB uses fractal tree indexes instead of B-tree indexes to improve per转载 2015-01-13 22:59:28 · 754 阅读 · 0 评论 -
mysql 有可能的优化方式
mysql 优化1.版本的更换测试一般来说新版本要优于老版本,比如5.7vs5.52.分支版本的考虑MariaDB,percona server 等分支的考虑3.根据场景尝试不同的引擎tokudb,innodb等在不同场景下的尝试使用4.内存分配方式jemalloc,tcmalloc5.读写分离6.partition的使用7.分库分表8.针对不同的业原创 2015-01-15 10:59:21 · 707 阅读 · 0 评论