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
沒有留言:
張貼留言