WMの写本

本頁是唯讀的，您可以看到原始碼，但不能更動它。您如果覺得它不應被鎖上，請詢問管理員。
======MySQL======
  * [[http://homeserver.com.tw/mysql/mysql-%E5%84%AA%E5%8C%96/|MySQL優化]]
  * [[http://homeserver.com.tw/mysql/mysql-%E6%95%88%E8%83%BD%E8%AA%BF%E6%95%B4/|MySQL效能調整]]
  * [[http://www.tocker.ca/2013/10/24/improving-the-performance-of-large-tables-in-MySQL.html|Ten ways to improve the performance of large tables in MySQL]]
  * [[http://www.hkcode.com/linux-bsd-notes/584|變更 MySQL client 的提示符號]]
  * [[http://bbs.ecstart.com/thread-7384-1-1.html|mysql資料庫的索引設計]]
  * [[http://inspire.twgg.org/c/programming/mysql/insert-the-performance-of-mysql-optimization.html|對 MySQL 的 INSERT 進行效能優化]]
  * [[http://www.mysqlperformanceblog.com/2006/05/29/insert-on-duplicate-key-update-and-summary-counters/|INSERT ON DUPLICATE KEY UPDATE and summary counters]]
  * [[http://plog.longwin.com.tw/my_note-unix/2009/04/15/mysql-binlog-recovery-range-by-date-time-2009|MySQL 使用 binary log 回復 某段時間區間 的資料]]
  * [[http://www.inote.tw/2009/04/mysql.html|讓中文依筆畫排序]]
  * [[http://inspire.twgg.org/c/programming/mysql/mysql-like-queries-are-case-sensitive.html|MySQL 的 LIKE 查詢區分大小寫]]
  * [[http://blog.24reader.com/vincentlam/2008/05/07/mysql%E4%BD%BF%E7%94%A8rand%E5%87%BD%E6%95%B8%E5%AF%A6%E7%8F%BE%E9%9A%A8%E6%A9%9F%E6%95%B8/|MySQL使用rand函數實現隨機數]]
  * [[http://blogs.msdn.com/miah/archive/2008/02/17/sql-if-exists-update-else-insert.aspx|SQL: If Exists Update Else Insert]]
  * [[http://www.ovaistariq.net/460/why-do-i-recommend-switching-over-from-myisam-to-innodb/|Why do I recommend switching over from MyISAM to Innodb!]]
  * [[http://inspire.twgg.org/c/programming/mysql/8-strokes-allows-you-to-optimize-query-performance-mysql.html|8招讓你優化 MySQL 查詢性能]]
  * [[http://blog.hinablue.me/entry/mysql-note-mysql-query-explain-optimization|[MySQL Note.] 資料庫查詢抱怨（刪除線）優化筆記]]
  * [[http://www.jaceju.net/blog/archives/116|MySQL 中文編碼徹底研究]]
  * [[http://origin2.pixnet.net/blog/post/1244682|mysql 裡 utf8_general_ci 跟 utf8_unicode_ci 連線校對的差異]]
  * [[http://www.jaceju.net/blog/archives/209|[SQL] PHP MySQL Tips]]
  * [[http://www.fromdual.ch/ranking-mysql-results|Ranking in MySQL results]]
  * [[http://www.sitepoint.com/how-to-create-mysql-events/|How to Create Scheduled Events in MySQL]]
  * [[http://tbbuck.com/a-quick-mysql-command-line-safety-tip/|A Quick MySQL Command-Line Safety Tip]]
  * [[http://huoding.com/2011/06/12/85|正確重置MySQL密碼]]
=====語法使用=====
  * <code>/usr/local/etc/rc.d/mysql-server start</code>
  * <code>cp /usr/local/share/mysql/my-large.cnf /etc/my.cnf</code>
  * 更新版本後：<code>mysql_upgrade -u wm -p</code>
  * 先停掉mysql-server，然後到/etc/my.cnf裡面將<code>#log-bin=mysql-bin</code>註解掉，就不會產生Binary Log。\\ 或是加上<code>expire_logs_days = X</code>設定保留天數。
  * <code>mysql_secure_installation</code>
  * <code>CREATE DATABASE wordpress;</code>
  * <code>SHOW DATABASES;</code>
  * 複製資料表結構<code>CREATE TABLE `新資料表` LIKE `舊資料表`</code>
  * 更改Autoindex\\ <code mysql>ALTER TABLE `table_name` AUTO_INCREMENT =value</code>
  * 批次最佳化所有資料庫中的表格\\ <code>mysqlcheck --all-databases --optimize --auto-repair</code>
  * 備份時順便rotate binary log<code>mysqldump --flush-logs -u root -p 資料庫名稱 > example.sql</code>
  * mysqldump備份(還原改方向)\\ <code>mysqldump -u [資料庫使用者] -h localhost -p[密碼] [資料庫名稱] > backup_`date +\%Y-\%m-\%d`.sql</code>
  * 另一方法還原mysqldump備份\\ <code>mysql -u [資料庫使用者] -p[密碼] [資料庫名稱] < [備份檔名].sql</code>
  * mysqldump --default-character-set=latin1
=====資源=====
  * [[http://twpug.net/docs/mysql-5.1/|MySQL 5.1參考手冊]]
  * [[http://www.mysqlperformanceblog.com/|MySQL Performance Blog]]
====技巧====
  * [[http://www.percona.com/resources/technical-presentations/advanced-mysql-query-tuning-percona-mysql-webinar|Advanced MySQL Query Tuning]]
  * [[http://www.mysqlperformanceblog.com/2013/10/16/utf8-data-on-latin1-tables-converting-to-utf8-without-downtime-or-double-encoding/|utf8 data on latin1 tables: converting to utf8 without downtime or double encoding]]
  * [[https://www.digitalocean.com/community/tutorials/how-to-measure-mysql-query-performance-with-mysqlslap|How To Measure MySQL Query Performance with mysqlslap]]
  * [[http://www.percona.com/blog/2014/12/10/recover-mysql-root-password-without-restarting-mysql-no-downtime/|Recover MySQL root password without restarting MySQL (no downtime!)]]
====管理====
  * [[http://www.mysql.com/products/workbench/|MySQL Workbench]]
  * [[http://www.sqlbuddy.com/|SQL Buddy]]
  * [[http://www.phpmyadmin.net/|phpMyAdmin]]
    * [[http://www.vixual.net/blog/archives/259|phpMyAdmin 的設定值]]
====工具====
  * [[http://sqlfiddle.com/|SQL Fiddle]]
  * [[https://github.com/rackerhacker/MySQLTuner-perl|MySQLTuner]]
  * [[http://www.day32.com/MySQL/|MySQL Performance Tuning Primer Script]]
  * [[https://proxysql.com/|ProxySQL]]
  * [[https://github.com/dolthub/dolt|Dolt]]
  * [[http://www.sequelpro.com/|Sequel Pro]]
=== Cluster ===
  * [[https://vitess.io/|Vitess]]