PDO Driver/deadlock (no replies)

Hello,

I have some problem with PDO/mysql driver on one server.

I have a lot of deadlocks.

Is there a configuration somewhere where i can put a big timeout ?

Thanks (more…)

MySQLi missing functionality? (no replies)

Hello all,

It seems, from the docs I have available, that I cannot use mysqli prepared statements along with fetch_assoc. Is this correct? if I want prepared statements I cannot retrieve my results as an array of associative arrays? Or am I missing something? I hope I’m missing something

Thanks,

Joe (more…)

End Query with \G instead of ;

You can use \G instead of ; for tables with lots of fields.

mysql> SHOW STATUS LIKE ‘Qcache%’;
+————————-+———–+
| Variable_name | Value |
+————————-+———–+
| Qcache_queries_in_cache | 6990 |
| Qcache_inserts | 6990 |
| Qcache_hits | 3987 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 621 |
| Qcache_free_memory | 176329432 |
| Qcache_free_blocks | 1 (more…)

Credit Card Debt Calculator

This script will calculate how long it will take to pay off credit card debt. It will also calculate the total interest that will be paid over that same period. (more…)

Mac OS X Leopard Spaces Rocks! Windows Vista Needs Spaces Functionality to Help Organize Your Digital Lifestyle

At the risk of sounding like a Mac fanboy, I have to tell you that Spaces in the Mac OS X Leopard is truly needed in Windows Vista to help you manage your digital lifestyle Spaces truly rocks! (more…)