Consultant,Security Researcher, Entrepreneur, Senior Linux Admin

1 Şubat 2016 Pazartesi

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';
  

Etiketler