• About
  • Bookmarks
  • RSS

Rick's code

HTML, CSS and JavaScript

MySQL

October 30, 2012 by Rick

How to Optimize your MySQL tables from the command line

All the MySQL tables have the be optimized once in a while. Ideally, once a week perhaps. You can do that by either going to your phpMyAdmin or, if you’re a badass command line user, run the following command…

Posted in Linux, MySQL
Tagged Ubuntu
How to Optimize your MySQL tables from the command line
October 26, 2011 by Rick

Optimize MySQL turning Off InnoDB

If your MySQL databases uses MyISAM instead of InnoDB you should turn the last one Off. It should free memory and optimize your MySQL performance.

Posted in Linux, MySQL
Tagged Ubuntu
Optimize MySQL turning Off InnoDB
November 12, 2010 by Rick

How to select Random with MySQL

Select random rows from a database base with MySQL

Posted in MySQL
March 24, 2010 by Rick

How to Delete Post Revisions WordPress

Following yesterday’s post about Turning Off Post Revisions today I’m going to show you how to delete those revisions from the data base.

Posted in MySQL, WordPress

Categories

  • Apache (14)
  • bbPress (4)
  • CodeIgniter (5)
  • CSS (41)
  • HTML5 (17)
  • JavaScript (55)
  • Linux (24)
  • Mac (9)
  • Magento (52)
  • MySQL (4)
  • News (19)
  • Node.js (4)
  • Other (22)
  • PHP (22)
  • Vue.js (2)
  • WordPress (111)

RSS Ricard Torres Blog

  • I’ve started a podcast!
  • Review: The Ghost Brigades
  • Rick and Morty is back and the universe is no longer in chaos
  • Review: Old Man’s War
  • 32

RSS Ricard Torres Radio

  • Episode 7: Overkill
  • Episode 6: Night train
  • Episode 5: Vitamin D
  • Episode 4: Unplugging
  • Episode 3: Do I look Korean?

Sharing code since 2010

@ricard_dev

@ricard_dev@mastodon.social

5.008.113 post views so far. This page needed 39 queries to load.

© Rick's Code - 2019