{"id":1517,"date":"2023-10-05T17:44:37","date_gmt":"2023-10-05T15:44:37","guid":{"rendered":"https:\/\/yellotab.se\/x056\/?p=1517"},"modified":"2023-10-06T13:13:07","modified_gmt":"2023-10-06T11:13:07","slug":"antal-tabeller-mysql","status":"publish","type":"post","link":"https:\/\/yellotab.se\/x056\/2023\/10\/05\/antal-tabeller-mysql\/","title":{"rendered":"Antal tabeller mySql"},"content":{"rendered":"<p>K\u00e4lla: <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/database-count-limit.html\">mySQL<\/a> | <a href=\"http:\/\/kiube.se.linux337.unoeuro-server.com\/\">http:\/\/kiube.se.linux337.unoeuro-server.com\/<\/a> |\u00a0 <a href=\"https:\/\/www.simply.com\/se\/controlpanel\/kiube.se\/admin\/\">Simply<\/a> |<\/p>\n<hr \/>\n<p>Generellt vad man kan s\u00e4ga \u00e4r att mysql tycker inte om databaser med m\u00e5nga tabeller (s\u00e4g n\u00e5gra miljoner), b\u00e4ttre isf med m\u00e5nga databaser med f\u00e5 tabeller, eftersom mysql f\u00f6rs\u00f6ker cacha hela databaser och inte cacha de vanligast anv\u00e4nda tabellerna. Med oracle tex, spelar detta ingen roll. Men du b\u00f6r ju sj\u00e4lvklart k\u00f6ra databas cachning p\u00e5 fil eller om du klustrar webben, b\u00f6r du k\u00f6ra en central memcached server f\u00f6r att cacha mysql fr\u00e5gor.<\/p>\n<p>&nbsp;<\/p>\n<hr \/>\n<p>MySQL has no limit on the number of databases. The underlying file system may have a limit on the number of directories.<\/p>\n<p>MySQL has no limit on the number of tables. The underlying file system may have a limit on the number of files that represent tables. Individual storage engines may impose engine-specific constraints. <code class=\"\" data-line=\"\">InnoDB<\/code> permits up to 4 billion tables.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>K\u00e4lla: mySQL | http:\/\/kiube.se.linux337.unoeuro-server.com\/ |\u00a0 Simply | Generellt vad man kan s\u00e4ga \u00e4r att mysql tycker inte om databaser med m\u00e5nga tabeller (s\u00e4g n\u00e5gra miljoner), b\u00e4ttre isf med m\u00e5nga databaser med f\u00e5 tabeller, eftersom mysql f\u00f6rs\u00f6ker cacha hela databaser och inte cacha de vanligast anv\u00e4nda tabellerna. Med oracle tex, spelar detta ingen roll. Men du [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":1525,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[138],"tags":[128,171],"class_list":["post-1517","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-wordpress","tag-kiube-se","tag-mysql"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/s3.eu-north-1.amazonaws.com\/yellotab.se\/wp-content\/uploads\/sites\/45\/2023\/10\/06131201\/2023-10-06-01.10.23-pm.png?fit=954%2C682&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/posts\/1517","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/comments?post=1517"}],"version-history":[{"count":5,"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/posts\/1517\/revisions"}],"predecessor-version":[{"id":1526,"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/posts\/1517\/revisions\/1526"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/media\/1525"}],"wp:attachment":[{"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/media?parent=1517"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/categories?post=1517"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yellotab.se\/x056\/wp-json\/wp\/v2\/tags?post=1517"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}