Yes, of course you can replace a string in all fields of a specific table in a specific databases by using the REPLACE function. No, you can not easily do this on an entire database… you have to script this. I have found a Brilliant script @BrillianSheep.com which I modified a little bit for readability… […]
Mysql: Replacing string in all tables of a database Read More »
Wondering which tables are big in your MySQL database? Plain and simple: run the following query on your database to calculate the table size in MegaBytes (MB) for your select MySQL database: select table_name, round(((data_length + index_length) / (1024*1024)),2) as ‘size in megs’ from information_schema.tables where table_schema = ‘db_name’;
Calculate of view the MySQL Data table size Read More »
If you ever encounter problems on your Nginx-PHP FPM server with all of the sudden increased load, very slow page load, PHP processes being filled for no particular reason… check php-fpm logs: root@webserver:~# tail /var/log/php5-fpm/php-fpm.log [19-Dec-2012 13:53:07] WARNING: [pool www] seems busy (you may need to increase pm.start_servers, or pm.min/max_spare_servers), spawning 8 children, there are
Nginx Rate Limiting Read More »