In a production environment, the database tables grow quickly and at times well beyond the initial estimates of the DBA. One of the most challenging tasks in this environment is the operation on large data sets as other concurrent processes are accessing the same data. This means that any table operation has to finish as [...]
In MySQL, you can use the SELECT … INTO OUTFILE statement to export data to an external file. Performing this export is straightforward. By adding the INTO OUTFILE clause to the standard SQL SELECT statement, you can re-direct the display of data from the computer screen to an operating system file. In certain situations, you [...]
MySQL Administrator is a graphical user interface that database administrators use to manage and monitor MySQL database servers. Aside from user management, parameter configuration, and server control, this tool includes graphs that display the current load and server health. The default installation already contains useful diagrams. However, the tool allows the DBA to create customized [...]
A very important feature of relational database management systems (RDBMS), including MySQL, is the capability to create indexes to facilitate fast and efficient access to the large amounts of data that are stored on the server. Indexes are a proven way to improve key searches on large databases. When you create an index on one [...]
Oracle SQL Developer Data Modeler is a free tool that supplies the user with a variety of data and database modeling tools and utilities. You can use it to create an Entity Relationship Diagram from scratch, forward engineer your model, and reverse engineer an existing schema. This tutorial shows you how to reverse engineer an [...]
Databases have an extensive set of security mechanisms to protect information from unauthorized database users. These mechanisms include user authentication (e.g., user name and password), privilege settings, and auditing of user actions. The database, however, still relies upon the operating system to secure the data as it resides within the physical data files to prevent [...]
Usually I write about technical topics, but this is a special post to thank the students in my SQL Server 2008 Reporting Services class. We attempted to run the class last week, but due to a technical mistake on our end, we weren’t able to. All of the students were understanding and gracious. This is [...]
MySQL Workbench is an integrated development environment used by DBAs and developers when working with MySQL servers and databases. There are three main areas of functionality: SQL Development, Data Modeling, and Server Administration. In this article, I will show you how to use the Server Administration tool to create a backup for your database.
In part one of this three-part tutorial, I presented how to manage the binary logs created by the MySQL server for backup and recovery or replication setups. In the second article, I discussed how to manage MySQL server logs that have fixed names. In this last installment, I discuss how to manage logs that are [...]
In Part I of this three-part tutorial, I presented how to manage the binary logs created by the MySQL server for backup and recovery or replication setups. In this second article, I discuss how to manage MySQL server logs that have fixed names.
