Netzflut

Webdesign, Webentwicklung, Drupal & Zeuchs

Mysql Performance tuning

Webdevelopment

Drupal

Betriebssysteme

Design

Sonstige

So., 01/07/2012 - 20:40

Video

http://videos.cpanel.net/mysql-optimization/

Drupal Module

http://drupal.org/project/db_maintenance http://drupal.org/node/1722250

Basis Check aller tabellen

mysqlcheck -o -p -all--databases

EXPLAIN

Nutze EXPLAIN um die prüfen was genau vor sich geht

https://opensource.com/article/17/5/speed-your-mysql-queries-300-times

Slow query log

Aktiviere slow query log

  1. long_query_time = 0.2
  2. slow_query_log = 1
  3. log_output = FILE
  4. slow_query_log_file = /var/log/mariadb-slow.log
  5. log_queries_not_using_indexes

Stelle ich z.B. fest, dass eine wachsende Tabelle anfangs schnelle Querys hat und dann immer langsamer wird......untersuchen

Webdevelopment
Datenbanken
Add new comment
The content of this field is kept private and will not be shown publicly.
About text formats

Plain text

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <drupal-entity data-*>
  • Web page addresses and email addresses turn into links automatically.
  • Lines and paragraphs break automatically.

User Menu

Flag List

Last Edit