A web applications like Wordpress will produce a lot of overhead on your database tables. Each overhead will make your database a little slower because more memory (RAM) is used. This PHP tutorial is for the beginning webmaster and also useful for the professional webmaster, which host his websites on a VPS or dedicated server.
Installing a web server for a production environment, with Ubuntu as operating system, is not too difficult because most of the required packages don’t need a lot of configurations. In this tutorial we create a (power) user, we install Apache, PHP and MySQL, phpMyAdmin and several other services needed to run a powerful and secure [...]
This is part two of the article “Database management with phpMyAdmin” a review of the book “Mastering phpMyAdmin” and the open source software phpMyAdmin. The PMA relational system In MySQL there is no native function to create relations between several database tables. Using the InnoDB database type makes it possible to link with foreign keys [...]
This is part one of the quick review of the book “Mastering phpMyAdmin for Effective MySQL Management” and the phpMyAdmin software. This article/review is not just another review about phpMyAdmin, but more some information about features I haven’t used during the last years of PHP/MySQL web development. About phpMyAdmin PMA is a full featured tool [...]
