Back to MySQL tuning

Running MySQL Tuner we get:

[!!] Temporary tables created on disk: 65% (640 on disk / 973 total)
Variables to adjust:
tmp_table_size (> 32M)
max_heap_table_size (> 16M)

[OK] InnoDB buffer pool / data size: 128.0M/1.8M
[OK] InnoDB buffer pool instances: 1
[!!] InnoDB Used buffer: 6.45% (528 used/ 8192 total)

I’ll continue tweaking the tmp-table size and double it, whilst I’m here we’re only using 6% of the InnoDB pool so we are pretty safe to cut it into half. Doubling the tmp-table-size should bring the 640 on disk number down by half.

Bug Fix to Minecraft Warden

After deploying the Minecraft Warden to my friend’s server we found some issues with placing it into production. I think I missed a commit->push because the same use-case was working fine on my system. Having said that, there was an issue with how the software would handle the case where the server wasn’t running and should start it up again.

Basically, the code had determined that the system should be started but wouldn’t flow to the place where the startServer() function was called. That has been fixed and has also been working just fine.

Repo Here: Warden Repo

Tire Weather Website

For some time now, I’ve been thinking about building a quick website to help my fellow enthusiasts in Canada to decide on whether or not they should install their high-specification summer tires. So far, this is what I’ll use to represent the idea/basic logic/basic design spec. I think that I’ll be doing this in C# since I am familiar with .NET but I’m pleasantly surprised at just how similar Ruby on Rails is to .NET MVC. Something tells me that it isn’t an accident ;).

– Threshold is 7C
– Outlook is 14 days
– Minimums are used to determine outdoor-overnight parking
– High is used to determine indoor-overnight parking

Location object
– City (String)
– Province (String)
– Country (String)

Parking Object
– Location

Weather Data Object
– City (String)
– Province (String)
– Country (String)

Days Object
– Minimum Temperature (Integer)
– Maximum Temperature (Integer)
– Rain (boolean)

Tire Object
– Class
– Lowest Temperature

UPDATE: Added Tire Object to allow support for different tire classes. Also, cleaned up some of the entities so they are more like a real UML.