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
# mysql -u[username] -p [database]
— rock out our nodes:
mysql> create index node_level on jz_nodes(level);
mysql> create index node_hidden on jz_nodes(hidden);
mysql> create index node_featured on jz_nodes(featured);
mysql> create index node_leaf on jz_nodes(leaf);
— rock out our tracks:
mysql> create index track_level on jz_tracks(level);
mysql> create index track_hidden on jz_tracks(hidden);
— these are mostly for charts:
mysql> create index node_viewcount on jz_nodes(viewcount desc);
mysql> create index node_dateadded on jz_nodes(date_added desc);
mysql> create index node_dlcount on jz_nodes(dlcount desc);
mysql> create index node_playcount on jz_nodes(playcount desc);
mysql> create index node_lastplayed on jz_nodes(lastplayed desc);
mysql> create index node_rating on jz_nodes(rating_val desc);
— not sure if this does anything:
mysql> create index node_art on jz_nodes(main_art);
I also made the following changes to the mysql configuration file /etc/mysql/my.cnf
# * Fine Tuning
#
#key_buffer = 16M
#thread_stack = 128K
#thread_cache_size = 80
key_buffer = 64M
max_allowed_packet = 16M
table_cache = 1024
join_buffer_size = 2M
sort_buffer_size = 4M
read_buffer_size = 2M
read_rnd_buffer_size = 768K
myisam_sort_buffer_size = 64M
thread_concurrency = 2
#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
These settings have speed up Jinzora a lot.