Mysql Day1 outline

Mysql

mysql_upgrade

dev.mysql

tar˙安裝只要五分鐘

rmi:

release candicate

dataschema design

Default storage engine:

 Msql 51. myisam

• Myisam is advnced fisam
• Table level locked
• No relationship
• No rockback
• No Crash  recover
• No transcation

• Partiontion

5.5 innodb

• Raw lv lock
• Condition control
• Performance schema: look up mutex, resource lock

5.6

• More rollback segment

• Semi-join replace sub-query

• Batch key access ?
• ibd
• Flash table
• Export tablespace
• Create same table
• Drop tablespace
• Import tablespace

• Explain plan

Mysql dual core:

• Translate commercial license
• Fixed In internal company: still gpl
• Subscription:
• Enterprice monitor
• Enterprice backup
• 4 plug-in
• Secriut
• Scability
• Aduit
• Scurite
• Remote support
• On on-site
• Java applet
• Perface turening
• Sc

• No subscription
• GPL core

• Physical : 4 socket per server: USD$ 5000 = 16W NTD
• Vm: depends

C lang

• C: user defined engine

exam

• Mysql dba ->

• Mysql cluster

• Mysql perface tuning

Hpux, aix No supported > 5.5

Can be compiled with source code

Linux , windows best supported