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

沒有留言:

Obsidian 插件介紹:Text Generator

Text Generator 是 Obsidian 的一個插件,它可以根據給定的提示自動生成文本。這個插件使用 GPT-3 語言模型,能夠產生類似人類的文本,非常適合編寫故事、文章、電子郵件和其他類型文本。 主要功能: **生成文本:**根據提示生成各種長度的...