June 8, 2013
by dhoytt
0 comments

Cleaned Up MySQL On Server

I did some cleanup of MySQL last night and this morning. Basically the forum database based on phpBB was out of control  and had grown huge along with the MySQL files in /var/lib/mysql/ for that database along with the “ibdata1” file and log files also in that directory.

I ended up taking the following steps:

  • Cleared some file space since I was @ 100% by uninstalling some unneeded packages
  • Insured that all the databases were error free:
    • “mysqlcheck –repair –all-databases
  • Dumped the databases to another directory in my home directory where I keep backup files using “Webmin”.
  • Dropped all of the databases
  • Stopped MySQL using “systemctl”:
    • “systemctl stop mysqld.service”
  • Copied the ibdata1 file and accompanying log files to my backup directory just in case I needed to recreate the environment.
  • Restarted MySQL service:
    • “systemctl start mysqld.service”
  • Restored all of the individual database schemas using MySQL Workbench not having anything to do with phpBB forums
  • Decided I would try to keep the current database schema for the phpBB forums but since I had done little decided it would be a waste of time.
    • Dropped the forum phpBB database again after I had restored it and it continued to take up  lots of space and there were no tools I found in phpBB to prune the database
    • Stopped MySQL
      • “systemctl stop mysqld.service”
    • This time deleted/var/lib/ibdata1 and associated log files
    • Started MySQL
      • “systemctl start mysqld.service”
  • Reinstalled phpBB using my current customized config files but with new database I created.

April 10, 2013
by dhoytt
0 comments

Favorite Rose Bush in Full Bloom Early

Well one of my rose bushes with long stem red roses is in ful bloom already this year and looking great! This is my favorite rose bush because it blooms the whole year is not a hybrid so thus it smells as great as it looks! My other rose bushes have one or two flowers and I anticipate them bloomimg very soon but none are usually as nice looking as this bush!

2013-04-09_15-21-22_930.jpg

March 31, 2013
by dhoytt
0 comments

Getting the Flower Garden Ready For 2013 & Vegetable Garden Mostly Planted

Well I trimmed up the existing flowers, roses and pulled weeds from the front flower beds, planted some new rose bushes and also planted most of my vegetable garden this weekend. I almost forgot I also pulled a bunch of weeds from the narrow corridor behind the house Now I just have a bit of touch up on all the garden beds plus some clean-up and pressure washing of the concrete in the back and toss a few more items then I start inside of the house & garage!

This year in the vegetable garden so far I have planted, jalapeno peppers, habanera peppers, Portugal hot peppers, green, red & orange bell peppers, beef steak tomatoes, yellow pear tomatoes, red cherry tomatoes, pumpkin, yellow straight squash, zucchini squash, red okra, green okra, black beauty egg plants, collard greens, black eyed peas, cucumbers, lettuce salad mix of seeds, snap peas, bush beans and some items I am sure I have forgotten. I just hope it will be a productive year after last year letting the raspberry & grape vines over run everything!

As far as the flower garden I added some nice variety of roses since I’m tired of doing different annuals each year. I added a Black Baccara rose bush, a White Honey rose bush and a Twilight rose bush that has dark violet hues. The Black Baccara will have red buds with heavy black tinting, while the White Honey will have a snow white looking flower along with the Twilight nice additions to the gardens with my other pink, red and orange roses!

A few pictures show below show current progress but once everything is in full bloom watch out vegetable & flower gardens will be rocking this year!

2013-03-31_12-44-27_192.jpg2013-03-31_12-58-26_541.jpg2013-03-31_13-13-22_767.jpg

2013-03-31_14-28-38_432.jpg2013-03-31_15-43-45_855.jpg2013-03-31_15-43-56_797.jpg

March 30, 2013
by dhoytt
0 comments

Lightning and Thunder Show in Sacramento

Silly me I really thought that someone was outside taking pictures when it was a good old fashion lightning storm outside the windows and now the thunder is starting to boom as well!

I hope this blows over so that I can finish my yard tomorrow even though they predict rain tomorrow!

Another update really to come on the yard as I get it into shape but for tonight will look at the lightning & thunder storm hoping for a respite tomorrow!

March 24, 2013
by dhoytt
0 comments

2013 Vegetable Garden Laid Out

Well I have several truckloads of compost rototilled into the soil for my vegetable gardens in the backyard. Placed some already nicely composed compost from the Horse Association off of Longview drive here in Sacramento along with compost from my normal outlet Longer’s landscape.

I had to really break up the roots from the raspberry and grape vines I let run wild last year that really compacted the clay soil in one garden. In the other garden I had to break up the roots from the neighbor’s trees and some mint plants roots that were running wild and deep.

After the initial rototilling to break up the soil I mixed in the two different types of compost and now the soil is very aerated and looking and feeling rich. I can’t wait to see what the results will be. I plan on placing some mulch on top of the soil this year too to slow water evaporation.

I also put back the initial placements of my drip system back in place and made some repairs for damaged attachments.

.2013-03-24_19-00-51_461.jpgThumbnail image for 2013-03-24_19-00-34_518.jpg

February 26, 2013
by dhoytt
0 comments

Cleaned up Some Issues on Site Web Server

There were some system administration issues with some files on the web server filling up some partitions. I cleared up those issues and everything seems a bit better at this time. Bear with me as I am doing some major hardware upgrades behind the scenes that will make things ultimately perform better in the long run.

After those hardware updates I have slated some additional software/application updates as well as some settings and software to load web pages much faster and ever more updates!

I also had some issues with the music streaming that I have corrected but will find the root cause later. I recently updated the software so hopefully that did not have a hand in the issues.

More to come!!

January 5, 2013
by dhoytt
0 comments

Web Server Back Up

Well opened up the web server to pull out the dual NIC cards and they were the PCI-x interface not what I wanted to go with the dual NIC card I had pulled out of another system. The reason I want dual NIC cards is that I tend to build systems in twos and with identical hardware and I want identical NICs in my two new storage appliances I am building.

Enhanced by Zemanta