Lock Wait Timeout Exceeded; Try Restarting Transaction – SQL Error 1205
If you work with really large tables (or, I suppose, a really slow server), you are eventually going to risk hitting this error. Lock wait […]
SQL Commands
You Are Using Safe Update Mode / SQL Error 1175
Have you ever had this happen? You’re just trying to run a SQL script to update a table. Suddenly the SQL system balk at you. […]
Lost Connection to MySQL Server During Query – Fixing a SQL Error Message
It’s probably happened to every SQL developer at least one time during their coding projects. They are running queries. Suddenly they get the error message […]
Query Execution was Interrupted in ASP
It’s one of the more frustrating errors you can get in ASP coding against a SQL database. Query execution was interrupted, maximum statement execution time […]
MySQL Notifier Error Cannot Initialize Main Application
What do you do when you get the error from MySQL Notifier that says: Error – Cannot initialize main application. Root element is missing. If […]
MySQL Bin Files Adding Taking Up Disk Space
MySQL is a database built on underlying files. What happens if you look into your MySQL data directory and realize that huge BIN extension files […]
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 […]
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 […]