Tutorials
How to create an Index
This article is a fraction of a Number of Articles on MySQL, to access them click here. SQL CREATE INDEX Syntax Creates an index on a table. Duplicate values are allowed: CREATE INDEX index_name ON Read more…
Knowledgebase
MySQL Indexing
This article is a fraction of a Number of Articles on MySQL, to access them click here. MySQL Indexing MySQL documentation says: The best way to improve the performance of SELECT operations is to Read more…
Knowledgebase
MySQL Performance Tuning: The stages of Tuning
This article is a fraction of a Number of Articles on MySQL, to access them click here. Why Tune a Database? Cost-effectiveness A system that is tuned can minimize the need to buy additional hardware Read more…
Knowledgebase
MySQL: Top 10 Design Tips
This article is a fraction of a Number of Articles on MySQL, to access them click here. 1.Understand Your Technology Tools MySQL is great platform to manage your database, and to be able to Read more…
Tutorials
MySQL Replication and How to Achieve It
This article is a fraction of a Number of Articles on MySQL, to access them click here. Replication Replication is the ability to duplicate data changes that occur on one server to another. Basic components Read more…
Knowledgebase
Introduction To MySQL and How It Works
This article is a fraction of a Number of Articles on MySQL, to access them click here. INTRODUCTION Beneath all the cute animations, the smooth transactions, lies the ruins of the backend, and talking about Read more…
Knowledgebase
Types Of Servers
File Servers A file server may be dedicated or non-dedicated. A dedicated server is designed specifically for use as a file server not for other database purposes. File servers may also be categorized by the Read more…
Announcements
Introduction To Virtualization
At the beginning, before the dawn of time there was emulation.(overly exaggerated) Emulation, the virtual machine simulates the complete hardware in software. This allows an operating system for one computer architecture to be run on the Read more…
Tutorials
How to Install WAMP
WAMP, well WAMP is another variant of LAMP (the original), the difference is obvious, W for L, that is Windows OS for Linux, other than that its same, down below is a little information on Read more…
Knowledgebase
15 Most Basic Linux commands
Linux is different, I know you already know that, and if are on this article you’ve taken your first step into the amazin world of Linux OS (little exaggeration). Here I am going to provide Read more…
