I am installing the new version of Jinzora 2.7.5 and decided to tweak the installation to make it run a bit faster on my old celeron 1ghz linux server. I found the following information on the Jinzora forums.<\/p>\n
Information on creating mysql indexes to speed up Jinzora. I also made the following changes to the mysql configuration file \/etc\/mysql\/my.cnf<\/p>\n # * Fine Tuning key_buffer = 64M # These settings have speed up Jinzora a lot.<\/p>\n","protected":false},"excerpt":{"rendered":" I am installing the new version of Jinzora 2.7.5 and decided to tweak the installation to make it run a bit faster on my old celeron 1ghz linux server. I found the following information on the Jinzora forums. Information on creating mysql indexes to speed up Jinzora. posted by Ben August 21 2006 – 19:29 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-78","post","type-post","status-publish","format-standard","hentry","category-jinzora"],"_links":{"self":[{"href":"https:\/\/www.joshbrews.com\/index.php?rest_route=\/wp\/v2\/posts\/78","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.joshbrews.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.joshbrews.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.joshbrews.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.joshbrews.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=78"}],"version-history":[{"count":0,"href":"https:\/\/www.joshbrews.com\/index.php?rest_route=\/wp\/v2\/posts\/78\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.joshbrews.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=78"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.joshbrews.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=78"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.joshbrews.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=78"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nposted by Ben August 21 2006 – 19:29<\/span>
\n# mysql -u[username] -p [database]
\n— rock out our nodes:
\nmysql> create index node_level on jz_nodes(level);
\nmysql> create index node_hidden on jz_nodes(hidden);
\nmysql> create index node_featured on jz_nodes(featured);
\nmysql> create index node_leaf on jz_nodes(leaf);
\n— rock out our tracks:
\nmysql> create index track_level on jz_tracks(level);
\nmysql> create index track_hidden on jz_tracks(hidden);
\n— these are mostly for charts:
\nmysql> create index node_viewcount on jz_nodes(viewcount desc);
\nmysql> create index node_dateadded on jz_nodes(date_added desc);
\nmysql> create index node_dlcount on jz_nodes(dlcount desc);
\nmysql> create index node_playcount on jz_nodes(playcount desc);
\nmysql> create index node_lastplayed on jz_nodes(lastplayed desc);
\nmysql> create index node_rating on jz_nodes(rating_val desc);
\n— not sure if this does anything:
\nmysql> create index node_art on jz_nodes(main_art);<\/p>\n
\n#
\n#key_buffer = 16M
\n#thread_stack = 128K
\n#thread_cache_size = 80<\/p>\n
\nmax_allowed_packet = 16M
\ntable_cache = 1024
\njoin_buffer_size = 2M
\nsort_buffer_size = 4M
\nread_buffer_size = 2M
\nread_rnd_buffer_size = 768K
\nmyisam_sort_buffer_size = 64M
\nthread_concurrency = 2<\/p>\n
\n# * Query Cache Configuration
\n#
\nquery_cache_limit = 1M
\nquery_cache_size = 32M
\nquery_cache_type = 1<\/p>\n