{"id":860,"date":"2014-12-17T19:04:05","date_gmt":"2014-12-17T17:04:05","guid":{"rendered":"http:\/\/sahinsolmaz.com\/blog\/?p=860"},"modified":"2014-12-17T19:04:05","modified_gmt":"2014-12-17T17:04:05","slug":"mysql-tuning-veritabani-optimizasyonu-ile-sunucu-performansinizi-yukseltin","status":"publish","type":"post","link":"https:\/\/sahinsolmaz.com\/blog\/mysql-tuning-veritabani-optimizasyonu-ile-sunucu-performansinizi-yukseltin\/","title":{"rendered":"MySQL Tuning Veritaban\u0131 Optimizasyonu ile Sunucu Performans\u0131n\u0131z\u0131 Y\u00fckseltin!"},"content":{"rendered":"

MySQL Tuning database\/veritaban\u0131 optimizasyonu ile sunucu performans\u0131n\u0131z\u0131 y\u00fckseltebilirsiniz. Bunun i\u00e7in yapman\u0131z gereken en pratik yol\u00a0Mysql Tuning<\/strong> yaz\u0131l\u0131m\u0131n\u0131n kurulumu ve \u00e7al\u0131\u015ft\u0131r\u0131lmas\u0131 neticesinde size belirtti\u011fi ayarlar\u0131 my.cnf<\/strong>\u00a0\u00fczerinden\u00a0g\u00fcncellemektir.<\/p>\n

MySQL Tuning Script<\/strong>‘i ile\u00a0veritaban\u0131 performans\u0131n\u0131z\u0131 detayl\u0131 olarak inceleyebilir, rahatl\u0131kla sunucu performans\u0131n\u0131z\u0131 artt\u0131rabilirsiniz.<\/p>\n

Script Ad\u0131:\u00a0tuning-primer.sh<\/strong><\/p>\n

Kaynak:\u00a0 http:\/\/day32.com\/MySQL\/<\/a><\/p>\n

Direkt\u00a0link: http:\/\/day32.com\/MySQL\/tuning-primer.sh<\/a><\/p>\n

MySQL Tuning –\u00a0tuning-primer.sh<\/strong>\u00a0Nas\u0131l Kurulur? \/\/How to Install MySQL Tuning?<\/h2>\n

tuning-primer.sh\u00a0<\/strong>i\u00e7in\u00a0ad\u0131m ad\u0131m SSH Kodlar\u0131:<\/p>\n

# wget http:\/\/day32.com\/MySQL\/tuning-primer.sh\r\n<\/strong>Script indirildi<\/span><\/code><\/span><\/pre>\n
# chmod u+x tuning-primer.sh<\/strong><\/span><\/pre>\n
\u0130zinler verildi<\/pre>\n
# .\/tuning-primer.sh<\/strong><\/code><\/span><\/pre>\n
\u00c7al\u0131\u015ft\u0131r\u0131ld\u0131<\/pre>\n
 <\/p>\n
\u00d6nemli Not:<\/strong>\u00a0Scripti \u00e7al\u0131\u015ft\u0131rmadan \u00f6nce MySQL<\/strong> servisinin minimum<\/span> son iki g\u00fcnd\u00fcr aktif olmas\u0131 gerekmektedir. Aksi takdirde izlemeler k\u0131sa s\u00fcreli oldu\u011funda verilen yan\u0131tlar tutars\u0131z olabilir. \u00d6rne\u011fin \u00e7ar\u015famba g\u00fcnleri sitenize ziyaret\u00e7i az geldi\u011finde ba\u011flant\u0131 limiti do\u011fru olmayacakt\u0131r.<\/p>\n
Ekran \u00e7\u0131kt\u0131s\u0131 3 renkten olu\u015facakt\u0131r. RedGreenBlue Yani k\u0131rm\u0131z\u0131, ye\u015fil ve mavi. Tahmin etti\u011finiz \u00fczere:<\/p>\n
    \n
  • K\u0131rm\u0131z\u0131lar,<\/span><\/strong> \u00f6nemli ikaz, kesinlikle d\u00fczeltmeniz gerekenler ayarlard\u0131r.<\/li>\n
  • Sar\u0131lar,<\/span><\/strong> uyar\u0131lar iyile\u015ftirmeniz gereken orta d\u00fczey puan ald\u0131\u011f\u0131n\u0131z ayarlar ve<\/li>\n
  • Ye\u015filler,<\/span><\/strong> ise do\u011fru yapt\u0131\u011f\u0131n\u0131z\u00a0ve\u00a0tam puan ald\u0131\u011f\u0131n\u0131z uyar\u0131lard\u0131r.<\/li>\n<\/ul>\n
    <\/div>\n
    <\/div>\n
    K\u0131rm\u0131z\u0131lar i\u00e7in bir \u00f6rnek vermek gerekirse:<\/div>\n
    You are using less than 10% of your configured max_connections.<\/span>
    \nLowering max_connections could help to avoid an over-allocation of memory<\/span><\/strong>
    \nSee “MEMORY USAGE” section to make sure you are not over-allocating<\/span><\/div>\n
    <\/div>\n
    MySQL OPT\u0130M\u0130ZASYON<\/h3>\n
      \n
    1. \/etc\/my.cnf<\/strong> <- dosyas\u0131n\u0131 a\u00e7\u0131n<\/li>\n
    2. max_connections<\/strong>\u00a0yani maksimum ba\u011flant\u0131 say\u0131s\u0131n\u0131n de\u011ferini d\u00fc\u015f\u00fcr\u00fcn e\u011fer b\u00f6yle bir parametre yoksa siz yazabilirsiniz \u00f6rn:\n
      max_connections = 13<\/strong><\/span><\/pre>\n<\/li>\n
    3. ssh \u00fczerinden a\u015fa\u011f\u0131daki komutu kullanarak\u00a0MySQL<\/strong> servisini yeniden ba\u015flat\u0131n ve hepsi bu kadar!\n
      # service mysqld restart<\/strong><\/span><\/pre>\n<\/li>\n<\/ol>\n
      <\/div>\n
      # .\/tuning-primer.sh<\/strong><\/code><\/code><\/div>\n
      \n
      \u00d6rnek ekran \u00e7\u0131kt\u0131s\u0131ndaki ba\u015fl\u0131klar \u015fu \u015fekildedir<\/p>\n
      SLOW QUERIES<\/p>\n
      WORKER THREADS<\/p>\n
      MAX CONNECTIONS<\/p>\n
      MEMORY USAGE<\/p>\n
      KEY BUFFER<\/p>\n
      QUERY CACHE<\/p>\n
      SORT OPERATIONS<\/p>\n
      JOINS<\/p>\n
      OPEN FILES LIMIT<\/p>\n
      TABLE CACHE<\/p>\n
      TABLE SCANS<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
      MySQL Tuning database\/veritaban\u0131 optimizasyonu ile sunucu performans\u0131n\u0131z\u0131 y\u00fckseltebilirsiniz. Bunun i\u00e7in yapman\u0131z gereken en pratik yol\u00a0Mysql Tuning yaz\u0131l\u0131m\u0131n\u0131n kurulumu ve \u00e7al\u0131\u015ft\u0131r\u0131lmas\u0131 neticesinde size belirtti\u011fi ayarlar\u0131 my.cnf\u00a0\u00fczerinden\u00a0g\u00fcncellemektir. MySQL Tuning Script‘i ile\u00a0veritaban\u0131 performans\u0131n\u0131z\u0131 detayl\u0131 olarak inceleyebilir, rahatl\u0131kla sunucu performans\u0131n\u0131z\u0131 artt\u0131rabilirsiniz. Script Ad\u0131:\u00a0tuning-primer.sh Kaynak:\u00a0 http:\/\/day32.com\/MySQL\/ Direkt\u00a0link: http:\/\/day32.com\/MySQL\/tuning-primer.sh MySQL Tuning –\u00a0tuning-primer.sh\u00a0Nas\u0131l Kurulur? \/\/How to Install MySQL Tuning? tuning-primer.sh\u00a0i\u00e7in\u00a0ad\u0131m ad\u0131m SSH […]<\/p>\n","protected":false},"author":1,"featured_media":871,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[113,137,461,46,43],"tags":[476,474,475,477],"class_list":["post-860","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-centos","category-mysql","category-performans","category-ssh","category-sunucu","tag-how-to-install-mysql-tuning","tag-mysql-tuning","tag-mysql-tuning-nasil-kurulur","tag-tuning-primer-sh"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/sahinsolmaz.com\/blog\/wp-content\/uploads\/2014\/12\/MySQL-Tuning-Veritaban\u0131-Optimizasyonu-ile-Sunucu-Performans\u0131n\u0131z\u0131-Y\u00fckseltin-MySQL-Tuning-tuning-primer_MySQL-Tuning-tuning-primer.sh-Nas\u0131l-Kurulur_How-to-Install-MySQL-Tuning.jpg","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4sbm9-dS","jetpack-related-posts":[{"id":435,"url":"https:\/\/sahinsolmaz.com\/blog\/ssh-ile-mysql-dosyasini-iceri-aktarmak-importing-mysql-databases-via-ssh\/","url_meta":{"origin":860,"position":0},"title":"SSH ile MySQL Dosyas\u0131n\u0131 \u0130\u00e7eri Aktarmak-Importing MySQL Databases via SSH","author":"SahinSOLMAZ","date":"20 Mart 2014","format":false,"excerpt":"Sunucunuzda y\u00f6netim paneli (cPanel, Plesk panel vb.) kullanm\u0131yor olabilirsiniz dolay\u0131s\u0131 ile phpMyAdmin\u00a0eri\u015fimiz de olmayacakt\u0131r\u00a0ya da y\u00fcklemek istedi\u011finiz .sql\u00a0veritaban\u0131\u00a0dosyan\u0131z\u0131n boyutu b\u00fcy\u00fck oldu\u011fu i\u00e7in time-out, bir tak\u0131m problemler ya\u015fayabilirsiniz bu ve benzeri durumlarda ssh\u00a0\u00fczerinden veritaban\u0131 dosyan\u0131z\u0131 kolayl\u0131kla import edebilirsiniz. Servers without a control panel (such as cPanel, Plesk, or Simple Control Panel)\u2026","rel":"","context":""SSH" i\u00e7inde","block_context":{"text":"SSH","link":"https:\/\/sahinsolmaz.com\/blog\/category\/sunucu\/ssh\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":432,"url":"https:\/\/sahinsolmaz.com\/blog\/change-mysql-root-password-mysql-root-sifresini-guncellemek\/","url_meta":{"origin":860,"position":1},"title":"Change MySQL Root Password – MySQL Root \u015eifresini G\u00fcncellemek","author":"SahinSOLMAZ","date":"20 Mart 2014","format":false,"excerpt":"Merhabalar, MySQL root \u015fifresini g\u00fcncellemeniz gerekirse, a\u015fa\u011f\u0131daki ssh\u00a0komutlar\u0131n\u0131 kullanman\u0131z yeterli olacakt\u0131r. Login ssh, type mysqladmin. A tip if you can not remember mysql password type \u00a0 mysql -uadmin -p`cat \/etc\/psa\/.psa.shadow` mysql> USE mysql; mysql> SELECT * FROM user; mysql> SET PASSWORD FOR 'username'@'hostname' = PASSWORD('password_here'); mysql> FLUSH PRIVILEGES; How to\u2026","rel":"","context":""SSH" i\u00e7inde","block_context":{"text":"SSH","link":"https:\/\/sahinsolmaz.com\/blog\/category\/sunucu\/ssh\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":403,"url":"https:\/\/sahinsolmaz.com\/blog\/cozuldusolved-mysql-innodb-error-cannot-allocate-3154744384-bytes\/","url_meta":{"origin":860,"position":2},"title":"\u00c7\u00f6z\u00fcld\u00fc\/Solved -MySQL InnoDB: Error Cannot Allocate 3154744384 bytes","author":"SahinSOLMAZ","date":"31 Mart 2014","format":false,"excerpt":"InnoDB: Error: cannot allocate 3145744384 bytes of\u00a0InnoDB: memory with malloc! Total allocated memory \u00c7\u00d6Z\u00dcLD\u00dc \/ SOLVED innodb_buffer_pool_size=2G","rel":"","context":""Genel" i\u00e7inde","block_context":{"text":"Genel","link":"https:\/\/sahinsolmaz.com\/blog\/category\/genel\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":381,"url":"https:\/\/sahinsolmaz.com\/blog\/change-mysql-resetupdate-password-root-ssh-kullanici-ve-sifre-islemleri\/","url_meta":{"origin":860,"position":3},"title":"Change MySQL Reset\/Update Password  – Root  SSH –  Kullan\u0131c\u0131 ve \u015eifre \u0130\u015flemleri","author":"SahinSOLMAZ","date":"25 May\u0131s 2014","format":false,"excerpt":"1. Change root password: su - root passwd 2. Mysql root password: --> ERROR 1045 (28000): Access denied for user 'root'@'localhost' service mysqld stop mysqld_safe --skip-grant-tables & mysql -u root mysql> mysql> use mysql; mysql> UPDATE user SET Password = PASSWORD ('yournewpassword') WHERE User='root'; mysql> FLUSH PRIVILEGES; mysql> quit; service\u2026","rel":"","context":""CentOS" i\u00e7inde","block_context":{"text":"CentOS","link":"https:\/\/sahinsolmaz.com\/blog\/category\/sunucu\/centos\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":401,"url":"https:\/\/sahinsolmaz.com\/blog\/mysql-stop-start-restart-unrecognized-service-error-solved\/","url_meta":{"origin":860,"position":4},"title":"MySQL – Stop, Start, ReStart Unrecognized Service Error Solved","author":"SahinSOLMAZ","date":"24 Mart 2014","format":false,"excerpt":"MySQL - Stop, Start, ReStart Unrecognized Service Error Solved mysql: unrecognized service [root@srv mysql]# service mysql stop mysql: unrecognized service [root@srv mysql]# service mysql restart mysql: unrecognized service [root@srv mysql]# service mysql restart mysql: unrecognized service \u00c7\u00d6Z\u00dcM \/ SOLVED: [root@srv mysql]# cd \/var\/lib\/mysql [root@srv mysql]# adduser mysql adduser: user mysql\u2026","rel":"","context":""Genel" i\u00e7inde","block_context":{"text":"Genel","link":"https:\/\/sahinsolmaz.com\/blog\/category\/genel\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":180,"url":"https:\/\/sahinsolmaz.com\/blog\/sunucu-mysql-versiyonunu-surumunu-ogrenmek\/","url_meta":{"origin":860,"position":5},"title":"Sunucu MySQL Versiyonunu – S\u00fcr\u00fcm\u00fcn\u00fc \u00d6\u011frenmek;","author":"SahinSOLMAZ","date":"3 Aral\u0131k 2012","format":false,"excerpt":"Merhabalar, Yine basit ama i\u015fe yarayaca\u011f\u0131n\u0131 d\u00fc\u015f\u00fcnd\u00fc\u011f\u00fcm bir SQL komutunu sizlerle payla\u015fmak istiyorum. Sunucunuzdaki MySQL versiyonunu \u00f6\u011frenmek istedi\u011finizde basit bir SQL komutu ile bu bilgiye eri\u015febilirsiniz. Bu i\u015flemi ger\u00e7ekle\u015ftirmek i\u00e7in; * phpMyadmin 'e giri\u015f yap\u0131n\u0131z ve SQL Sekmesine ge\u00e7i\u015f yap\u0131n\u0131z. * SQL sekmesine a\u015fa\u011f\u0131daki SQL komutunu yaz\u0131n\u0131z ve sa\u011f alttaki\u2026","rel":"","context":"Benzer yaz\u0131","block_context":{"text":"Benzer yaz\u0131","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/posts\/860","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/comments?post=860"}],"version-history":[{"count":0,"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/posts\/860\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/media\/871"}],"wp:attachment":[{"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/media?parent=860"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/categories?post=860"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/tags?post=860"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}