Tag: mysql

All the articles with the tag "mysql".

• [mysql] 追蹤與紀錄執行過久的 SQL

  Published:Aug 6, 2022 |  at 01:45 PM (4 min read)

  Mysql 5.7 有以下兩個設定可以協助你排查 SQL 執行的狀況以及相關指標，由於這類設定可能會影響效能上的表現，預設會是關閉的，以下簡介如何開啟設定以及相關的設定檔。

• [mac] mysql2 gem: Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load

  Published:Jul 9, 2020 |  at 06:41 AM (1 min read)

  這幾天在裝 mysql2 gems 時發生如下的錯誤

• [ubuntu] Your PHP installation appears to be missing the MySQL extension which is required by WordPress

  Published:Jun 17, 2020 |  at 09:02 AM (1 min read)

  通常原因會是更新了 php 版本卻沒裝對應的 mysql package

• The 'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled: see the documentation for 'show_compatibility_56'

  Published:Jun 11, 2020 |  at 08:51 AM (1 min read)

  原因是 [email protected] `show_compatibility_56` 已經 deprecated

• [mysql] InnoDB: Table `mysql`.`innodb_table_stats` not found.

  Published:Sep 10, 2017 |  at 11:39 PM (1 min read)

  InnoDB: Table `mysql`.`innodb_table_stats` not found.

• [mysql] start: Job failed to start invoke-rc.d: initscript mysql, action "start" failed. ，完整移除並重新安裝

  Published:May 21, 2017 |  at 08:36 AM (2 min read)

  Job failed to start invoke-rc.d: initscript mysql, action "start" failed. ，完整移除並重新安裝

• [mac] 安裝 mysql, php, phpmyadmin

  Published:Apr 2, 2017 |  at 06:59 AM (2 min read)

  mysql, php, phpmyadmin 安裝

• [mysql] 新增使用者及權限設定

  Published:Feb 29, 2016 |  at 04:17 AM (1 min read)

  每次要設定 mysql 的資料庫給外面的廠商，都一直忘記指令......