{"id":149,"date":"2025-11-05T07:58:18","date_gmt":"2025-11-05T05:58:18","guid":{"rendered":"https:\/\/darkparrot.joton.dev\/?page_id=149"},"modified":"2025-11-05T08:01:07","modified_gmt":"2025-11-05T06:01:07","slug":"mysql-spowolnienie","status":"publish","type":"page","link":"https:\/\/darkparrot.joton.dev\/?page_id=149","title":{"rendered":""},"content":{"rendered":"\n<h4 class=\"wp-block-heading\">MySql &#8211; spowolnienie<\/h4>\n\n\n\n<p>Po pewnym czasie pracuj\u0105c z matur\u0105, tw\u00f3j serwer mysql mo\u017ce spowolni\u0107. <br>Cz\u0119sto powodem (szczeg\u00f3lnie na s\u0142abszych komputerach) b\u0119dzie ilo\u015b\u0107 baz. <br>Po prostu jest ich zbyt du\u017co i silnik bazy musi wykorzystywa\u0107 moc na ich przetwarzanie.<br><br>Wtedy warto usun\u0105\u0107 zb\u0119dne bazy danych. <br>Mo\u017cna oczywi\u015bcie wykonywa\u0107 to pojedynczo, ale szkoda czasu.<br><br>Zr\u00f3b inaczej, zr\u00f3b to p\u00f3\u0142-automatycznie.<br>Uruchom skrypt:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT CONCAT('DROP DATABASE `', SCHEMA_NAME, '`;')<br>FROM information_schema.schemata<br>WHERE SCHEMA_NAME NOT IN (<br>  'mysql','information_schema','performance_schema','sys','phpmyadmin'<br>);<br><\/pre>\n\n\n\n<p>Jako wynik, zostan\u0105 wy\u015bwietlone polecenia do uruchomienia.<br>Skopiuj je i uruchom. Uruchom ponownie phpMyAdmin.<br>W ten spos\u00f3b zostan\u0105 usuni\u0119te zb\u0119dne bazy.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySql &#8211; spowolnienie Po pewnym czasie pracuj\u0105c z matur\u0105, tw\u00f3j serwer mysql mo\u017ce spowolni\u0107. Cz\u0119sto powodem (szczeg\u00f3lnie na s\u0142abszych komputerach) b\u0119dzie ilo\u015b\u0107 baz. Po prostu jest ich zbyt du\u017co i silnik bazy musi wykorzystywa\u0107 moc na ich przetwarzanie. Wtedy warto usun\u0105\u0107 zb\u0119dne bazy danych. Mo\u017cna oczywi\u015bcie wykonywa\u0107 to pojedynczo, ale szkoda czasu. Zr\u00f3b inaczej, zr\u00f3b [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_frontis_meta_header_display":false,"_frontis_meta_footer_display":false,"_frontis_meta_site_title_display":false,"_frontis_meta_sticky_header":false,"_frontis_meta_transparent_header":false,"_frontis_meta_lazy_load":false,"_frontis_meta_transparent_bg_color":"","_frontis_meta_sticky_bg_color":"","footnotes":""},"class_list":["post-149","page","type-page","status-publish","hentry"],"fb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false},"fb_author_info":{"name":"znowiec","avatar":"https:\/\/secure.gravatar.com\/avatar\/6f04bafbb8dfaa33c54fa3b62770e50118d815bd85307845bc3577fff518179b?s=96&d=mm&r=g","bio":"","archive_url":"https:\/\/darkparrot.joton.dev\/?author=1","email":"znowiec@gmail.com","latest_post_date":"14 maj 2025"},"fb_category_info":[],"fb_post_tag_info":[],"fb_post_excerpt":"MySql &#8211; spowolnienie Po pewnym czasie pracuj\u0105c z matur\u0105, tw\u00f3j serwer mysql mo\u017ce spowolni\u0107. Cz\u0119sto powodem (szczeg\u00f3lnie na s\u0142abszych komputerach) b\u0119dzie ilo\u015b\u0107 baz. Po prostu jest ich zbyt du\u017co i silnik bazy musi wykorzystywa\u0107 moc na ich przetwarzanie. Wtedy warto usun\u0105\u0107 zb\u0119dne bazy danych. Mo\u017cna oczywi\u015bcie wykonywa\u0107 to pojedynczo, ale szkoda czasu. Zr\u00f3b inaczej, zr\u00f3b&hellip;","_links":{"self":[{"href":"https:\/\/darkparrot.joton.dev\/index.php?rest_route=\/wp\/v2\/pages\/149","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/darkparrot.joton.dev\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/darkparrot.joton.dev\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/darkparrot.joton.dev\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/darkparrot.joton.dev\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=149"}],"version-history":[{"count":2,"href":"https:\/\/darkparrot.joton.dev\/index.php?rest_route=\/wp\/v2\/pages\/149\/revisions"}],"predecessor-version":[{"id":153,"href":"https:\/\/darkparrot.joton.dev\/index.php?rest_route=\/wp\/v2\/pages\/149\/revisions\/153"}],"wp:attachment":[{"href":"https:\/\/darkparrot.joton.dev\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}