Assertion

Assertion is a technique you can use to debug JavaScript code. You use assertion to ensure that an expression evaluates to true during script execution. This means that if any expression evaluates to false, there is possibly a bug in your code. There is no inbuilt assert function in JavaScript, but it is simple to…

MySQL Tips and Tricks

The most popular open-source database engine in the world, MySQL is a powerful database engine known for its high performance, reliability and ease of use. Many large internet companies use MySQL to power their databases and applications based on the LAMP stack (Linux, Apache, MySQL, PHP/Perl/Python). MySQL is platform-independent and runs on more than 20…

Secure your MySQL Server

It does not matter what data is stored in your database, you want to prevent unauthorized access. If the data is not secure, then anyone with the time and motivation can potentially access it over the internet. Once they are in your database, they can take all your data or delete it if they want….

Partition Tables in MySQL

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 found that poor database design is a major factor in poor database performance and unscheduled system downtime. One great way to improve the performance of your MySQL database is to…

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 effect on any other processes running on the server and can have a significant effect on performance. In an ideal world, you could just increase the resources available to the…