MySQL Performance: MySQL/MariaDB Indexes

Reading Time: 6 minutes

Data in a MySQL/MariaDB database is stored in tables. A simple way of thinking about indexes is to imagine an extensive spreadsheet. This type of system is not always conducive to quick searching; that’s where an index becomes essential. If there is no index, then the database engine has to start at row one and browse through all the rows looking for the corresponding values. If this is a small table, then it is no big deal, but in larger tables and applications where there can be tables with millions and even billions of rows, it becomes problematic. As you can imagine, searching through those rows one by one will be time-consuming, even on the latest hardware. The solution is to create an INDEX (or more than one) for your data.

Continue reading “MySQL Performance: MySQL/MariaDB Indexes”

Searching Through a Database with phpMyAdmin

Reading Time: < 1 minute

This tutorial assumes you’ve already logged in to phpMyAdmin.  Now let’s learn how to use the Search feature.

  1. Click the database you wish to search here.phpma-search-frame03_1
  2. Then click the Search tab and enter words or values to search for in the database.
  3. There are several options you can use to refine your search. This database only has one table (details), but if there were more, you could limit your search to specific tables here.phpma-search-frame05_1
  4. When ready, click Go to perform the search. This search found one match. Click Browse.phpma-search-frame06_1
  5. We can now make changes to the record that was found.phpma-search-frame10_1
  6. Click Go when finished.