Web Development

I'm up again ! After a lot of downtine I'm up again thanx to a great price on a dedicated server. The machine is incredible: Intel® Core™ i7-920 Quad-Core with Hyper-Threading 8 GB DDR3 RAM 2 x 750 GB SATA-II HDD (initiall setup in software RAID… more »

Înainte să plec în concediu trebuie să semnalez, cu întârziere totuși, două lansări foarte importante: Fedora 10 și MySQL 5.1. Fedora 10 Wireless connection sharing Setup mai ușor pentru imprimante Virtualization… more »

How much space is used by the database ? This simple question has an OS answer, so if you didn't changed the default data directory you can do: du -hs /var/lib/mysql/DATABASE_NAME But if you're a user with no or limited shell rights you will have… more »

One of the reasons MySQL is popping up in top or is eating up to much processor time... or nowdays is eating up too many processors are ORDER BY clauses. Many ORDER BY clauses will translate in temporary tables stored to disk. If you are using GROUP BY c… more »

Let's assume we have table called "Users" and that table has a filed called "UserName".As the assumptions continue... you are in charge of setting an index on that field.mysql> SELECT * FROM COLUMNS -> WHERE TABLE_SCHEMA = 'some_db' AN… more »