InnoDB: Error: cannot allocate 3145744384 bytes of\u00a0InnoDB: memory with malloc! Total allocated memory<\/p>\n
\u00c7\u00d6Z\u00dcLD\u00dc \/ SOLVED<\/strong><\/span><\/p>\n InnoDB: Error: cannot allocate 3145744384 bytes of\u00a0InnoDB: memory with malloc! Total allocated memory \u00c7\u00d6Z\u00dcLD\u00dc \/ SOLVED innodb_buffer_pool_size=2G<\/p>\n","protected":false},"author":1,"featured_media":0,"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":[1,137,46,43,47],"tags":[198,145,197,160,196,12,551],"class_list":["post-403","post","type-post","status-publish","format-standard","hentry","category-genel","category-mysql","category-ssh","category-sunucu","category-veritabanidatabase","tag-3154744384-bytes","tag-cozuldu","tag-error-cannot-allocate","tag-mysql-error","tag-mysql-innodb","tag-solved","tag-ssh"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4sbm9-6v","jetpack-related-posts":[{"id":987,"url":"https:\/\/sahinsolmaz.com\/blog\/solved-error-1153-08s01-at-line-4147-got-a-packet-bigger-than-max_allowed_packet-bytes\/","url_meta":{"origin":403,"position":0},"title":"SOLVED – ERROR 1153 (08S01) at line 4147: Got a packet bigger than ‘max_allowed_packet’ bytes","author":"SahinSOLMAZ","date":"15 May\u0131s 2015","format":false,"excerpt":"Bir gece yaras\u0131 mysql veritaban\u0131n\u0131 import etmek istedi\u011finizde: ERROR 1153 (08S01) at line 4147: Got a packet bigger than 'max_allowed_packet' bytes hatas\u0131 ile kar\u015f\u0131la\u015f\u0131rsan\u0131z 1.se\u00e7enekteki d\u00f6rt ad\u0131m\u0131 uygulayarak bu s\u0131k\u0131nt\u0131dan kal\u0131c\u0131 olarak kurtulabilirsiniz veyahut 'max_allowed_packet' bytes hatas\u0131n\u0131 anl\u0131k olarak ge\u00e7mek isterseniz 2. se\u00e7enekteki ssh komutunu uygulayabilirsiniz. Ben MySQL dosyas\u0131n\u0131, SSH\u2026","rel":"","context":""MySQL" i\u00e7inde","block_context":{"text":"MySQL","link":"https:\/\/sahinsolmaz.com\/blog\/category\/sunucu\/mysql\/"},"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":403,"position":1},"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":435,"url":"https:\/\/sahinsolmaz.com\/blog\/ssh-ile-mysql-dosyasini-iceri-aktarmak-importing-mysql-databases-via-ssh\/","url_meta":{"origin":403,"position":2},"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":498,"url":"https:\/\/sahinsolmaz.com\/blog\/solved-internal-error-filemng-opendir-failed-permission-denied-system-error-13\/","url_meta":{"origin":403,"position":3},"title":"SOLVED Internal error: filemng: opendir failed: Permission denied System error 13","author":"SahinSOLMAZ","date":"2 Nisan 2014","format":false,"excerpt":"Hata \/ Error:\u00a0Internal error: filemng: opendir failed: Permission denied System error 13: Permission denied Message filemng: opendir failed: Permission denied System error 13: Permission denied File Agent.php Line 212 Type PleskUtilException Plesk panelin eri\u015fim izninin olmamas\u0131 sebebi ile bu hata ile kar\u015f\u0131la\u015f\u0131lmaktad\u0131r, \u00e7ok \u00f6nemli bir problemdir ancak a\u015fa\u011f\u0131daki \u00e7\u00f6z\u00fcm i\u015finize\u2026","rel":"","context":""Plesk Panel" i\u00e7inde","block_context":{"text":"Plesk Panel","link":"https:\/\/sahinsolmaz.com\/blog\/category\/sunucu\/sunucu-panelleri\/plesk-panel\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":407,"url":"https:\/\/sahinsolmaz.com\/blog\/cozuldusolved-php-configure-error-xml2-config-not-found\/","url_meta":{"origin":403,"position":4},"title":"\u00c7\u00f6z\u00fcld\u00fc\/Solved – PHP configure: error: xml2-config not found","author":"SahinSOLMAZ","date":"31 Mart 2014","format":false,"excerpt":"PHP configure: error: xml2-config not found. Please check your libxml2 installation. Are you attempting to compile PHP on Linux and running into, \u201cconfigure: error: xml2-config not found. Please check your libxml2 installation.\u201d It\u2019s easy to fix, simply install the libxml2-development package by issuing the following command on your appropriate Linux\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":403,"position":5},"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":[]}],"_links":{"self":[{"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/posts\/403","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=403"}],"version-history":[{"count":0,"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/posts\/403\/revisions"}],"wp:attachment":[{"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/media?parent=403"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/categories?post=403"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sahinsolmaz.com\/blog\/wp-json\/wp\/v2\/tags?post=403"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}innodb_buffer_pool_size=2G<\/span><\/strong><\/pre>\n","protected":false},"excerpt":{"rendered":"