實驗數(shù)據(jù)庫性能監(jiān)視與優(yōu)化實驗

實驗 數(shù)據(jù)庫性能監(jiān)視與優(yōu)化實【實驗5-1】使用SHOW語句查詢設(shè)備吞吐量Questions>Com_SelectComJnsertCom_update>Com_delete【實驗5-2］訪問Performance_schema中的events_statements_summary_by_digest表，獲取有關(guān)的延遲、錯誤和查詢量信息的性能指標(biāo)。5-3SHOW語句查詢連接檢查指標(biāo)Threads_connected>Threads_running>Connection_errors_internal、Aborted_connects和Connection_errors_max_connectionsG【實驗5-4］使用SHOW語句查詢Innodb緩沖區(qū)指標(biāo)lnnodb_buffer_pool_pages_total、Innodbbufferpoolreadrequests>InnodbbufferpoolreadSo【實驗5-5］使用SHOW語句獲取與查詢緩沖有關(guān)的指標(biāo)：Qcache_free_blocks、 Qcache_not_cached>Qcache_queries_in_cache、Qcache_total_blocks。、5-6］SHOWCreated_tmp_disk_tables、5-7］SHOWOpen_tablesOpened_tables5-8SHOWPROCESSLIST5-9mysqldumpslow5-10］EXPLAINEXTENDEDUNIONSELECT5-11］EXPLAINEXTENDEDSELECT*FROMtlWHEREal<10AND(EXISTS(SELECTa2FROMt2WHEREt2.a2<5ANDt2.b2=l)OREXISTS(SELECTa2FROMt2WHEREt2.a2<5ANDt2.b2=2));5-12EXPLAINEXTENDEDSELECT*FROMtl,(SELECT*FROMt2WHEREt2.a2>10)v_t2WHEREtl.al<10AND5-13c5-14］PROCEDUREANALYSE5-15lnet_ATONIP192.128.1.1IP5-16］5-17］SQL5-1SHOWQuestions、Com_Select、Com_insert、Com_update、Comdelete5-2］Performance_schemaevents_statements_summary_by_digest獲取有關(guān)的延遲、錯誤和查詢量信息的性能指標(biāo)。5-3SHOWThreadsconnected、Threadsrunning、Connectionerrorsinternal、Abortedconnects和Connectionerrorsmaxconnectionsc5-4SHOWInnodblnnodb_buffer_pool_pages_total、Innodbbufferpoolreadrequests>InnodbbufferpoolreadSo【實驗5-5 ］使用SHOW語句獲取與查詢緩沖有關(guān)的指標(biāo)：Qcache_free_blocks、Qcache_free_memory、Qcache_hits、Qcachejnserts、Qcache_lowmem_prunes、5-6SHOWCreated_tmp_disk_tablesCreated_tmp_files、5-7］SHOWOpen_tablesOpened_tables5?8SHOWPROCESSLIST5?9mysqldumpslow5-10］EXPLAINEXTENDEDUNIONSELECT5-11EXPLAINEXTENDEDSELECT*FROMtlWHEREal<10AND(EXISTS(SELECTa2FROMt2WHEREt2.a2<5ANDEXISTS(SELECTa2FROMt2WHEREt2.a2<5ANDt2.b2=l)EXISTS(SELECTa2FROMt2WHEREt2.a2<5ANDWHEREtl.al<10AND5-1