资源描述：
《mysql enterprise 介绍》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。
1、MySQL企业版KevinDing丁雪峰ISV/OEM,GreatChina第17期：《ORACLE–MYSQL技术专场》www.LAMPER.cnhttp://weibo.com/lampercnAgendaMySQL企业版：技术概要与商务分析MySQL企业监控器（MEM）MySQL企业备份工具（MEB）MySQL工作台（Workbench）MySQL企业版商用扩展特性MySQL企业版：总结与展望Q&A©2012OracleCorporationTheWorld
2、’sMostPopularOpenSourceDatabase3MySQLEnterpriseEdition•PerformanceMySQLDatabase•Reliability•EaseofUse•Online“Hot”BackupMySQLEnterpriseBackup•Full,Incremental,PartialBackups•PointinTimeRecovery(PITR)•GlobalMonitoringofAllServersMySQLEnterpriseMonitor•AdvisorswithBestPracti
3、ceAdvice•MySQLQueryAnalyzer•DatabaseDesign&ModellingMySQLWorkbench•DatabaseAdministration•SQLDevelopment•OnlineKnowledgeBaseOraclePremierSupport•24x7ProblemResolution•ConsultativeSupport©2012OracleCorporationTheWorld’sMostPopularOpenSourceDatabase4MySQL企业版技术概要与商务分析MakingM
4、ySQLBetterToday©2012OracleCorporationTheWorld’sMostPopularOpenSourceDatabase5MySQLServer架构MySQLServerConnectorsNativeCAPI,JDBC,ODBC,.Net,PHP,Ruby,Python,VB,PerlClientsandAppsEnterpriseManagementServicesandUtilitiesConnectionPoolAuthentication–ThreadReuse–ConnectionLimits–
5、CheckMemory–CachesBackup&RecoverySecurityReplicationSQLInterfaceParserOptimizerCachesClusterDDL,DML,StoredQueryTranslation,AccessPaths,GlobalandEnginePartitioningProcedures,Views,ObjectPrivilegesStatisticsSpecificCachesandInstanceManagerTriggers,Etc..BuffersInformation_Sc
6、hemaMySQLWorkbenchPluggableStorageEnginesMemory,IndexandStorageManagementInnoDBMyISAMClusterEtc…PartnersCommunityMore..Filesystems,FilesandLogsRedo,Undo,Data,Index,Binary,Error,QueryandSlow©2012OracleCorporationTheWorld’sMostPopularOpenSourceDatabase6StorageEngines-MyISAM
7、©2012OracleCorporationTheWorld’sMostPopularOpenSourceDatabase7StorageEngines-InnoDB©2012OracleCorporationTheWorld’sMostPopularOpenSourceDatabase8StorageEngines-Memory•FastFacts–Contentislostonpowerfailure–HashandB-treeindexonly–Table-levellocking–Fixed-lengthrows•EmptyVAR
8、CHAR(200)columnsstilltakeupalotofspace–Themax_heap_table_sizesystemvariableslimitsthesizeofindiv
