Written on December 27th, 2009
.
After 4 months trying to fix my laptop finally with success, yesterday I installed Ubuntu 9.10 (Karmic Koala) on my MacBook (2,1). Actually, rather than write a “OMG it’s so great!”-post, I turned it out a howto fix some issues of Ubuntu 9.10 (Karmic Koala) on a MacBook 2,1.
First Impressions
First of all, kernel devs has been hardly working on the Intel 945GM video driver, lame wonders like the civilizations or something, I’m talking OMFGWTF!?!11-sized wonders!
Using wildly unreliable readings from glxgears:
– 8.10 (Intrepid Ibex): ~1100 fps
– 9.04 (Jaunty Jackalope): ~900 fps (and I’m being generous here)
– 9.10 (Karmic Koala): ~3200 fps!
I’ve got 3x more frames per second than I did in 8.10. Now graphics feel smoother and I think I could almost run a 3D accelerated game on it. Read the rest of this entry »
Written on December 9th, 2009
.
A huge used database reverberate on a more fragmented database even if you delete any large data. The data base admin should optimize and take care of this especially if dealing with a lot of varying characters (VARCHAR).
At this article I will explain how to opmimize MySQL databases with tools that mysql provides. I will separate on two cases:
- Optimizing just one table
- Optimizing all the tables on a database
The main disvantage is that you can only optimize MyISAM, InnoDB, and ARCHIVE tables.
Read the rest of this entry »
Written on December 8th, 2009
.
With memcached and mod_memcache_cache we can use the memcached server as a content cache. This allows us share content of cache between different servers.
Into Apache is available the mod_cache module, that allows to realice this task throw different storage modules. Apache has 2 built in:
- mod_disk_cache: stores and fetchs cached content in hard disk
- mod_mem_cache: cache’s data in the running httpd process memory
But at this article I want to introduce mod_memcache_cache, that uses an memcached server to store data, so the available memory is the sum of all the nodes this daemon has. Thus, by increasing the memory size of Memcached server, Apache will has more memory to cache contents. The main topic is that this Memcache server can be placed on other machine with a lot of memory and serving contents to more than 1 server, acting as a central repository of cached content listening to clients that want to store something in key-value structure.
Read the rest of this entry »
