MySQL Programmer: a plugin query locks the table while people

Mysql programmer starts with a real fault on the site you have. The usual one is this: a plugin query locks the table while people are checking out.

The failure we expect

• A plugin query locks the table while people are checking out
• The connection fails after a host move or a password change
• The site times out on one page and the rest are fine
• Two imports created duplicate products or users

The pieces we open

MySQL jobs we take are attached to a live site: WordPress, a custom PHP app, or a cart. The symptom is a slow page, a missing record, or a connection the site used to have.

• Table size against the hosting plan
• The database user, host, and whether it can connect from this account
• Indexes on the tables that page actually reads
• The slow query, not a guess about the whole server

After you call

Development on a live system is a change with a before and an after. We say which file, module, or query we are touching, and what the page should do when we are done.

If the feature does not exist yet, we still start from the page that needs it. We do not rebuild the parts that already work just to have a clean repository.

Computer Geek works from Toronto with clients in other cities. Distance does not change the check. Access to the host and a page that shows the problem does.

Call 905-426-1784. We look at the site and tell you what the work is before it starts. The service page for this is MySQL help.