Results for tag mysql

  • Next step MySQL: using views to improve performance
    Joor Loohuis, 2010-08-14
    When developers start using MySQL as a storage backend, they quickly find out how to insert, update, delete, and retrieve data. But often enough, progress tends to stop there, and problems arise when an application needs to scale. This article demonstrates how creating views may be a life saver for an underperforming application.
  • Making your servers a bit more "green" with smart system adminstration, part 4: MySQL databases
    Armijn Hemel, 2010-05-16
    "Green IT" can only work if you have a combined approach of optimization on all levels. Knowing how to get the most out of the components you are using is a must.
  • Quick and dirty MySQL optimizations
    Armijn Hemel, 2009-06-18
    Deleted data in a MySQL database often keeps occupying some space (depending on the storage engine), until the database is optimized. With a simple quick and dirty solution you can let cron do this for you.