May 27

When checking system records today,See MariaDB has a lot of error messages,Follows:

InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade

Continue browsing »

Apr 29

SQL Server will run out of operating system memory by default,And on the server dedicated to SQL Server,In general, it is also recommended to use the memory as much as possible for SQL Server,One to improve efficiency,Secondly, it also reduces the IO loss of the hard disk。However, if there are specific circumstances that need to control the memory limit of SQL Server,SQL Server Management Studio (SSMS) To achieve。

Continue browsing »

Sea 14

  一直以來都把網誌的圖片放在Dropbox,但最近收到Dropbox通知,3/15準備把Public的公開資料夾功能拿掉,雖然還是可以用”分享連結”The way,讓圖片可以外連,但這個轉換工作太浩大,且難保未來不會再調整一次,Therefore, assessment of the picture altogether moved to a more stable space。

Continue browsing »