April 22, 2007

RE: mysql indexes

Category: Jinzora — Josh @ 2:51 pm

I noticed when I was building indexes for the database that most of these indexes are setup by default now with v 2.7.5 the only index that was not built was the last line of. I tried building the other indexes but I received an error stating something about a duplicate index.
mysql> create index node_art on jz_nodes(main_art);

So I added it

More tweaks

Category: Jinzora — Josh @ 2:48 pm

I also edited the settings.php file in the Jinzora directory and changed the line

$enable_page_caching = “false”;

to

$enable_page_caching = “true”;

Seems to be a little better now.

Jinzora Tweaks

Category: Jinzora — Josh @ 2:13 pm

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.

April 21, 2007

Bottling finished

Category: Bitter 2 — Josh @ 9:40 pm

I finished bottling for the evening. Total bottled was 5.5 gallons. Nothing left to do but clean up. I have to say that bottles from Bass beer www.bass.com do not cap well (They Suck! and don’t always crimp well). The music from their website is really good. I will toss the other ones that I have not used yet into the recycling bin.

The hops flavor of this recipe definately shines through. Hurray for Goldings. The flavor is definately awesome and true to it’s origins. Mild, flowery and refined. The only thing I would like to change is to use less Northern Brewer hops Maybe .25 ounces less, and go all grain. Well…. maybe some Fall harvest Maris otter and goldings would be nice too.

Started bottling and FG.

Category: Bitter 2 — Josh @ 8:05 pm

I started bottling tonight. While I was siphoning, I took a FG measurement of 1.008 @ 74 F; FG is 1.009 Corrected. According to Lee’s brewery Java beer calculator, this batch came out to 4% alcohol (Almost too much for my tastes).

April 18, 2007

FG Update, Started Bottling

Category: Bob's Brown Ale — Josh @ 10:21 pm

I started bottling tonight. FG is 1.012 @ 72F. 1.013 corrected. 3.7%. 56 bottles total. This style is more of an an American brown than an American amber. The Cascade hops flavor really shines through. Very citrus like. Despite this, it tastes like it is missing something.

April 13, 2007

SG update

Category: Bitter 2 — Josh @ 8:16 pm

SG 1.009 @70F; 1.010 corrected

SG update

Category: Bob's Brown Ale — Josh @ 8:01 pm

The SG for this ale is currently 1.011 @ 70F; 1.012 corrected.

April 11, 2007

SG reading

Category: Bob's Brown Ale — Josh @ 8:50 pm

SG 1.012 @ 70F; 1.013 corrected. Sample tastes good. Nothing really spectacular. Airlock activity has almost stopped. one bubble every 20-30 seconds.

SG reading and installed airlock

Category: Bitter 2 — Josh @ 8:49 pm

I took a SG reading 1.013 @ 69 F; 1.014 corrected; I removed the blow off tube and installed and airlock. Fermentation seems to have slowed even more since this afternoon. Sulfur smell is not as strong in the sample that I tasted when taking the SG reading. It should fade in a week or so.