随笔分类 - MySQL_Tuning
摘要：今天看了篇帖子，被几个地方转载，但是性能不太好，因为不能评论，所以把优化思路写在这里。1.确定需求: 根据部门来分组,显示各员工在部门里按薪水排名名次.2.来创建实例数据:drop table if exists heyf_t10;create table heyf_t10 (empid int ,deptid int ,salary decimal(10,2) );insert into heyf_t10 values(1,10,5500.00),(2,10,4500.00),(3,20,1900.00),(4,20,4800.00),(5,40,6500.00),(6,40,14500.0
阅读全文
摘要：淘宝商品库MySQL优化实践 View more presentations from Feng Yu笔记：11页：的调优工具不错13页：大数据量下的binlog参数配置14页：InnoDB的参数配置27页：最后的优化成果确实给力：QPS36000（读32800，写3200）
阅读全文
摘要：
Table size 30G, Ram size 16G
Solutions:
1. Partition: split program_id into different partitions
2. Split tables: split table into smaller tables
3. select * from program_access_log where id between 1 and 500000 and program_id between 1 and 15000000;
阅读全文
Table size 30G, Ram size 16G
Solutions:
1. Partition: split program_id into different partitions
2. Split tables: split table into smaller tables
3. select * from program_access_log where id between 1 and 500000 and program_id between 1 and 15000000;
阅读全文
摘要：MySQL Performance BlogParexample, on vais creater une table pour noter le traffic de l'Internet,il y a une table avec le traffic et le numero de package de le port etl'IP de address.la table comme:Cre...
阅读全文
摘要：mysql> SELECT whatstheweatherlike(5);+----------------------------------------------------------+| whatstheweatherlike(5) |+----------------------------------------------------------+| Its 5°C,...
阅读全文
