DevChunks

Category: MySQL

MySQL Tips and Tricks

The most popular open-source database engine in the world, MySQL is a powerful database engine that is known for its high performance, reliability and ease

Read More »

Remove Obsolete Privileges

Security is an important consideration for any computer systems and MySQL is no exception to this rule. One big security problem that administrators can often

Read More »

Control remote access

On a standard MySQL installation, remote access is disabled by default. This is great if you are sat next to your server, but inconvenient if

Read More »

Secure your Server

It does not matter what data is stored in your database, you want to prevent unauthorized access to it. If the data is not secure

Read More »

Tighten up the schema

It does not matter how good you can write queries in MySQL, if the underlying schema is not optimized it will slow your database performance

Read More »

Partition Tables

One of the big deciding factors in the performance of your database is the design of the database. Research from various parties, including Oracle has

Read More »

Isolate Slow MySQL Processes

Even the best MySQL implementation will sometimes have problems with processes taking too long and hogging the CPU and memory. This will have a knock-on

Read More »