MySQL vs MSSQL Updating Based On Two Tables
In most cases, MySQL code and MSSQL code is fairly similar. If you have a website running on MSSQL you can reconnect it to a […]
SQL Commands
Tuning Your MySQL my.ini File for High Website Traffic
If you’ve got high website traffic on your MySQL blog or site, you can quickly find that MySQL bogs down and slows. You’ll need to […]
MySQL Tuning – increasing thread_cache_size to allow more simultaneous users
As your website gets more traffic, you’ll find that you run into problems where MySQL slows down. One of the values to work with is […]
MySQL Tuning – increasing max_connections to allow more simultaneous users
As your website gets more traffic, you’ll find that you run into problems where MySQL slows down. It has to wait for existing users to […]
WordPress Featured Image Permissions Problem on IIS
If you are using WordPress on a Microsoft Windows server, using IIS to manage your website, then you can easily run into permissions problems as […]
MySQL Workbench – Increasing Connection Time
If you do a lot of work with MySQL, you’re probably using MySQL Workbench to manage your databases and schemas. Once you start working with […]
MySQL Schema Inspector Reporting Wrong Row Counts
When you use reports in MySQL, you expect them to be accurate. Let’s take, for example, the MySQL Schema Inspector. When you use the schema […]
Comparing MySQL Data Across Schema
There are all sorts of reasons you might want to compare data between two tables in different schema. A common situation is that you’re moving […]
MySQL Dump Not Exporting All Rows
This example is a lesson in double-checking what you think you’re seeing. I just invested a half hour in trying to solve a problem which […]
Changing a MySQL Schema Name
You’ve got your MySQL database up and running. Everything is going smoothly. But then for some reason you need to change your MySQL schema name. […]