![\"Share](\"https:\/\/static.hupso.com\/share\/buttons\/lang\/tr\/share-medium.png\")
<\/a>Bu i\u015flem , Innodb de kritik olabilecek bir i\u015flem , dolay\u0131s\u0131 ile once shutdown mode unun 1 olup olmad\u0131\u011f\u0131na bak\u0131yoruz , mysql e login olup sorgumuzu \u00e7al\u0131\u015ft\u0131ral\u0131m.<\/p>\n
mysql> show variables like ‘innodb_fast_shutdown%’;<\/p>\n
+———————-+——-+
\n| Variable_name | Value |
\n+———————-+——-+
\n| innodb_fast_shutdown | 2 |
\n+———————-+——-+
\n1 row in set (0.00 sec)<\/p>\n
G\u00f6r\u00fcld\u00fc\u011f\u00fc \u00fczere de\u011ferimiz 2 , bunu sa\u011fl\u0131kl\u0131 i\u015flem yapabilmek i\u00e7in 1 yapal\u0131m.<\/p>\n
mysql> SET GLOBAL innodb_fast_shutdown=1;<\/p>\n
Tekrar bir \u00f6nceki komuut \u00e7al\u0131\u015ft\u0131r\u0131rsak de\u011ferin 1 e d\u00f6nd\u00fc\u011f\u00fcn\u00fc g\u00f6rebiliriz.<\/p>\n
\u015eimdi mysql i stop edelim.<\/p>\n
[root@ayhanarda root]# service mysql stop<\/p>\n
\u015fimdi log dosyalar\u0131m\u0131z\u0131 silmeyelimde farkl\u0131 bir yere atal\u0131m , ne olur ne olmaz.<\/p>\n
[root@ayhanarda root]# cd \/var\/lib\/mysql\/
\n[root@ayhanarda mysql]# mv ib_logfile* \/tmp\/<\/p>\n
\u015fimdi my.cnf de ilgili de\u011feri de\u011fi\u015ftirelim.<\/p>\n
[root@ayhanarda mysql]# nano \/etc\/my.cnf<\/p>\n
innodb_log_file_size = 750M
\n(bunu kendi yap\u0131n\u0131za g\u00f6re ayarlay\u0131n , ben 24 gb ram li \u00fczerinde 2000 mysql veritaban\u0131 ko\u015fan sunucuda \u00e7al\u0131\u015ft\u0131r\u0131yorum , yapaca\u011f\u0131n\u0131z de\u011feri bulmak i\u00e7in mysqltuner kullanman\u0131z faydal\u0131 olabilir)<\/p>\n
\u015eimdi mysql i start edelim.<\/p>\n
[root@ayhanarda root]# service mysql start<\/p>\n
\u015fimdi mysql dizininde iken ls -al | grep ib_* derseniz 2 adet log dosyas\u0131n\u0131n belirledi\u011finiz de\u011fere ayarland\u0131\u011f\u0131n\u0131 g\u00f6rebilirsiniz ya da yine mysql sorgusu ile t\u00fcm innodb_log de\u011ferlerini g\u00f6rebilirsiniz.<\/p>\n
[root@ayhanarda mysql]# mysql
\nWelcome to the MariaDB monitor. Commands end with ; or \\g.
\nYour MariaDB connection id is 15108
\nServer version: 10.0.34-MariaDB MariaDB Server<\/p>\n
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.<\/p>\n
Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the current input statement.<\/p>\n
MariaDB [(none)]> show variables like ‘innodb_log%’;
\n+——————————-+———–+
\n| Variable_name | Value |
\n+——————————-+———–+
\n| innodb_log_arch_dir | .\/ |
\n| innodb_log_arch_expire_sec | 0 |
\n| innodb_log_archive | OFF |
\n| innodb_log_block_size | 512 |
\n| innodb_log_buffer_size | 8388608 |
\n| innodb_log_checksum_algorithm | innodb |
\n| innodb_log_compressed_pages | ON |
\n| innodb_log_file_size | 786432000 |
\n| innodb_log_files_in_group | 2 |
\n| innodb_log_group_home_dir | .\/ |
\n+——————————-+———–+
\n10 rows in set (0.00 sec)<\/p>\n
Ayhan ARDA<\/p>\n