Skip to main content

Mysql Quota

I installed a forum, and forget about it.

After several months, I received a Mysql Quota warning, and found that the forum has got thousands of registered users and posts. All of those usernames are randomly generated and posts are ads with many links, fortunately there are no adult photos and videos.

Here is the Mysql Quata warning email:

Dear Valued Customer
We are mailing you to let you know your free account has exceeded its mysql quota of 50mb.
The ability for your user to add new data to your databases has been revoked (denied) due to the quota breach.
You will be able to log into phpmyadmin (or possibly use tools in your script) to remove data from mysql.
If you are unable to reduce your database usage to under 50mb, we would ask you to upgrade.
Best Regards
Besides of the restriction of SQL usage, there are disk usage quota, bandwidth usage quota and daily CPU usage quota.

Comments

Popular posts from this blog

How to Input Phonetic Symbols (IPA) in Google Docs

You can insert special characters by clicking "Insert" on the menu, then click the "Ω Special Characters", the choose "Latin" category from the drop-down menu, and then Phonetics (IPA) sub-category. Insert Special Characters in Google Docs There is a short-cut for inputting some IPA symbols which you use them frequently. Automatic Substitution in Google Docs similar to Auto Correct in MS Word. You can replace common acronyms, misspellings and other symbols. So you can set auto-replace for your IPA symbols, for example, "e<" for "ɛ", "o/" for "ø", "o>" for "ɔ" etc. Automatic Substitutions in Google Docs

Vodafone Router Configuration for Incoming Connection and other Services

This post is about specific Vodafone Home Broadband Router configuration for Incoming Connection and other service on your home computer. This is not a tutorial, and will not be going into details of the services and router configuaration, I just want to point out couple of points you need to pay attention to. 1. Port Forwarding. Vadafone Router has its own name for Port Forwarding, it's called Port Mapping under Port Management category.The picture below shows that I set up web server on my desktop, I map my local address on port 80; and I set up PPTP incoming connection by mapping local address on port 1723. Port Forwarding 2. Exposed Host. If you have set up Port Mapping, you still can't get what you want, then you have to put your device outside the Firewall, i.e. bypass Vodafone Connects (means Router) firewall, in a Demilitarised Zone (DMZ), using it's Exposted Host Function. Static NAT (Network Address Translation) means the Router will translate publi...

Pricing information is missing or not applicable

One of Google Play Books "Needs Action" issues is "Pricing information is missing or not applicable",  this is caused by the payment settings, you have to set up "Payment Profile", "Sale Territories", and "Currency Conversion" if you sell your book to the "WORLD". Some authors or publishers spend hours to tweak the Prices setting when they add new books, and feel very confused and frustrated, this happened to me too. Then I realized that you have to set up your Payment Method first, adding bank account for your payment profile. After that you wait for Google to deposit some cents to verify the bank account. You have to add sales territories as well, if the territory is WORLD, you have to TURN ON currency conversion, too. You have also to specify the On-Sale Date, although its help tips (when hover mouse on the question mark ? ) says "Leave this field blank if the book can be made available for sale on Google Play ...