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

沒有留言:

如何下載Facebook 相簿跟影片

影片:透過chrome plug-in : Video Downloader for Facebook<sup>TM</sup> 相簿: 透過chrome plug-in : Tampermonkey 搭配script : Facebo...