Some of the stuff that I have been looking at recently:
- Howto to Talk with GoogleTalk in Python
- Enterprises and consumers don’t buy things, they subscribe to services
- SQL Relay - SQL Relay is a persistent database connection pooling, proxying and load balancing system for Unix and Linux.
- memcached - a high-performance, distributed memory object caching system
- spread - a high performance messaging service that is resilient to faults across external or internal networks
- MySQL InnoDB Tuning
- MySQL - Restrictions on InnoDB Tables -
InnoDB does not keep an internal count of rows in a table. (This would actually be somewhat complicated because of multi-versioning.) To process a SELECT COUNT(*) FROM t statement, InnoDB must scan an index of the table, which takes some time if the index is not entirely in the buffer pool. To get a fast count, you have to use a counter table you create yourself and let your application update it according to the inserts and deletes it does.
Happy to know that the workaround is to do it myself
Popularity: 25%
Comments: (0)