vBulletin / Photopost and MySQL 5

Tuesday, December 30, 2008 10:27
Posted in category Forums, MySql, VBulletin

On a few sites I run I have vBulletin and / or Photopost installed. Upgrading from MySQL 4 to MySQL 5 is simple because these programs are 100% compatible with both (as they should be).


Read the rest of this entry »

MySQL Performance Tip #1: Query Cache

Tuesday, December 30, 2008 10:26
Posted in category MySql

This tip can be done in either Windows or Linux. In Windows using the MySQL Administrator go into the Health Tab and then the Performance Tab. Look at the key_reads and key_read_requests numbers.


Read the rest of this entry »

Find Duplicate Records and the Number of Duplicates in SQL (MySQL)

Tuesday, December 30, 2008 10:23
Posted in category MySql

I have found the need to account for duplicates and the number of duplicates in many databases. I’ve come across many people who have a minimal understanding of SQL and create wild php scripts to find duplicates, when really all that is needed is a single SQL statement. Read the rest of this entry »

vBulletin / Photopost and MySQL 5

Tuesday, December 30, 2008 10:09
Posted in category Forums, PHP

On a few sites I run I have vBulletin and / or Photopost installed. Upgrading from MySQL 4 to MySQL 5 is simple because these programs are 100% compatible with both (as they should be).


Read the rest of this entry »

Delete Spam Comments in Wordpress via MySQL

Tuesday, December 30, 2008 10:06

When marking comments as “spam” in Wordpress, it doesn’t actually remove them from the database. Read the rest of this entry »

If my server has 4GB memory, how many users can support?

Monday, December 29, 2008 15:20
Posted in category Internet News

I’m trying to work out whether your are joking or really believe that. In case you are not joking…

Read the rest of this entry »

Abilitare l’estensione PAE (Physical Address Extension)

Monday, December 29, 2008 15:18
Posted in category Internet News

Per abilitare l’estensione PAE (Physical Address Extension) X86

Read the rest of this entry »

Cenni preliminari su PAE (Physical Address Extension)

Monday, December 29, 2008 15:16
Posted in category Internet News

Cenni preliminari su PAE (Physical Address Extension) X86

L’estensione PAE (Physical Address Extension) X86 consente al software di utilizzare il set di API AWE (Address Windowing Extensions) in esecuzione su un computer con processore Intel Pentium Pro o versioni successive e con oltre 4 gigabyte (GB) di memoria fisica per mappare memoria fisica aggiuntiva allo spazio di indirizzi virtuali dell’applicazione.

Read the rest of this entry »

Why can’t I see all of the 4GB of RAM in my machine?

Monday, December 29, 2008 14:57
Posted in category Internet News

I have set my boot options to /3GB /NOPAE. Even though the server has 4GB of physical memory, we see only 3.5GB of physical memory on the server after it boots up. However, when we change the boot options to /PAE, we can observe 4GB of memory. Furthermore, when I enable only /PAE, even though the physical memory is 4GB, I can see 4GB. Without /PAE, even though the physical memory is 4GB, I can see 3.5GB. What is the reason for this?


Read the rest of this entry »

How to add the senders IP address to the contact form for Joomla 1.5.8

Monday, December 29, 2008 12:57


Ever wanted to add the senders IP address when submitting a message via the contact form?  Just use our one line code hack. Read the rest of this entry »