January 17, 2014 0 Comments

I did some research about MySQL’s query cache. Some people said it will speed up page load times by 5-15%. Query cache is used to cache SELECT results and later return them without

January 16, 2014 0 Comments

Try to execute show processlist;, maybe there are some long lasting threads that were not killed for some reason. Similarly execute SHOW SESSION STATUS LIKE 'Created%'; to check if mysql hasn't created to

December 18, 2013 0 Comments

Do not do this, since it might screw up encoding: mysqldump -uroot -p database > utf8.dump # this is bad Better do: mysqldump -uroot -p database -r utf8.dump Note that when your MySQL

November 14, 2013 0 Comments

This class is very useful for small projects, it easy and fast to connect mysql with php script. Thank you Ciprian Mocanu to provide this document. The Class:

August 14, 2013 1 Comment

UPDATE! Code moved to bitbucket: https://bitbucket.org/markoshust/syncdb/src Often times, you need to pull down an up-to-date version of Magento from your production server to your development or staging servers. This involves: Executing a mysqldump

July 21, 2013 0 Comments

Game link: http://www.maning.ca/ats/memory-game/ Download Demo: http://www.maning.ca/ats/memory-game/memory-game-Demo.zip "Memory game is a card game in which all of the cards are laid face down on a surface and two cards are flipped face up over

February 15, 2012 0 Comments

Innodb Buffer Pool is by far the most important option for Innodb Performance and it must be set correctly. I’ve seen a lot of clients which came through extreme sufferings leaving it at

February 7, 2012 0 Comments

1. tar all folder tar cvfz filename.tar.gz folder 2. backup mysql DB $ mysqldump -u root -p dbname >~/db_name.sql 3.scp files from ssh to another server scp -r filename username@ 4. restore the

February 6, 2012 0 Comments

1. Back-up the original database that you want to "clone" In case you you have a mysql password for user root you need to use mysql(dump) -u root -p dbname and you will

January 7, 2012 0 Comments

MySQL 5.1 Event Scheduler, Conceptually, this is similar to the idea of the UNIX crontab (also known as a “cron job”) or the Windows Task Scheduler. What is “Event Scheduler” event is an

  • 1
  • 2