Aylar: Şubat 2016

Mysql Key_buffer_size uyarısı

MySQL shows warning Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead [mysqld] ... key_buffer = 16M aşağıdaki gibi değiştirilmeli. [mysqld] ... key_buffer_size = 16M...

Mysql Sorgu İzleme

SHOW VARIABLES LIKE "general_log%"; +------------------+----------------------------+ | Variable_name | Value | +------------------+----------------------------+ | general_log | OFF | | general_log_file | /var/run/mysqld/mysqld.log | +------------------+----------------------------+ SET GLOBAL general_log = 'ON';     kapatmak için   mysql> SET GLOBAL general_log = 'OFF';  ...