2016年8月31日 星期三

MySQL read/Write very slow in a table because of long blob columns

Today I was digging a mysql performance drop issue.  The symptom is query very slow when selecting in

one table.   I tried to use explain comment, but it returns very fast.    Therefore, I just select 1 column in the 

same time to find out which column was cause.   Finally, I found it was a blob column.    Use blob and mysql

to google, there are a punch reference in there

沒有留言:

demo_article

使用 msty.app 和 Knowledge Stacks 建立個人知識庫系統 說明 嘗試利用local llm自動從文字檔轉成影音檔 利用AI自動對文件檔產生影音檔案 - YouTube 引言 在資訊爆炸的時代,我們每天接收大量的資訊,但如何有效地管理...