Posts tagged mysql
MySQL tables can crash quite easily, especially when your server unexpectedly shuts down or crashed, or when you're forced to copy data around when it's still being accessed.
Luckily, there's a simple command to automatically check, repair and optimize all tables in all databases when you're running a MySQL server on Linux / Unix / BSD.
mysqlcheck -u root -p --auto-repair --check --optimize --all-databases
That's all there is to it!
Are you looking to create a website and have your own webhost? It is very simple but the first step is to find a dependable webhost company. We tried over 10 webhost companies (Servage, GoDaddy, Hostmonster, Blue host and may more) in the past 8 years and found the most affordable and dependable was DreamHost
There is nothing to loose you always have your 97 days money back grantee but further if you use our promo coupon you can take 90 USD OFF just use promotional discount coupon code:
Below is a table comparing popular webhosts and any hidden limtations they have. If you have updates to this please comment.
|Price Promo 1yr||$107.4-90=$17.4 /first year||Adhoc 5.95$x12=$71.4||$6.64×12=$79.68|
|Host Unlmited Domains||Yes||Yes||Yes|
|Hosting Space||Unlimited||“Unlimited” but if high your account will be suspended||150GB|
|SSH Access||By Default||Need to send ID||Can be requested no ID needed|
|CPU Limit||No Limitation||60Sec then Site suspended||No Limitation|
|First Yr Domain Registration Free||Yes||Yes||No|
|Tech Support||Chat, Email Ticket system(response time: 1-24hours),Phone: only call back||Phone, Chat, Ticket(Response time 1-24 Hours)||Phone,Ticket(slow 1 Day response time)|
|Install Custom PHP||Yes Simple see article here||No||No|
|Max File Upload Size||7MB, unlimited with Custom PHP install||2MB, can be increased with copying php to all folders, still limited with CPU time limit||7MB|
|Can host Adult Content||Yes||No||Yes|
|Loading speed for a 64kb website size||2-3 Seconds performance is stable since dreamhost upgraded to new servers||2-3 Seconds, performance was stable||5-6 Seconds|
|Midnight Commander||Installed by default||Not installed and can not install it||Not sure|
FIREWALL[root@CentOS-56-64-minimal ~]# system-config-securitylevel-tui
WEBMIN>SYSTEM> SOFTWARE PACKAGES search for php
Solution in Centos 5 and Fedora 9:
yum search mbstring
yum install php-mbstring
INCREASE MYSQL MEMORY