Search


print PDF Ireland
Return to guide principal du Sql private



If you need to see your private sql logs, it is possible to add the following line in my.cnf:
slow_query_log = /home/mysql/sqlprive.log


Then, you can find all the logs of your bases in sqlprive.log file in the / home / mysql / directory of your ftp private sql.

We then recommend that you clear or delete this file regularly to avoid overloading your private sql unnecessarily.



Here is how this my.cnf:
[mysqld]

tmp_table_size=5M
query_cache_size=10M
thread_cache_size=5
max_connections=75
open_files_limit=900


skip-locking
key_buffer_size = 10M
max_allowed_packet = 1M
table_cache = 300
sort_buffer_size = 1M
join_buffer_size = 1M
read_buffer_size = 512K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K

max_binlog_cache_size = 1M
max_join_size = 12M
max_seeks_for_key = 2M
max_write_lock_count = 512K
myisam_max_sort_file_size = 1M

#####################
##Configuration Innodb##
##Uncomment the next line to disable Innodb

##skip-innodb

innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M

innodb_log_file_size = 10M
innodb_log_buffer_size = 4M

innodb_flush_log_at_trx_commit=1