Twitter

What I've Been Up To Lately

  • To optimize your MySQL database. 12) Apache creates many child proc's that's why persistent conn's do not work very well in this environment 2013-6-5
  • To optimize your MySQL database. 11) Avoid big DELETE or INSERT queries, that might take long time to clear or even crash web server 2013-6-5
  • To optimize your MySQL database. 10) Use Vertical Partitioning, smaller tables perform faster 2013-6-5
  • To optimize your MySQL database. 9) Unbuffered Queries saves considerable amounts of memory with queries that produce large result sets 2013-6-5
  • To optimize your MySQL database. 8) Prepared statements are transmited in a native binary form, thats more efficient & reduces network delay 2013-6-5
  • To optimize your MySQL database. 7) Use NOT NULL. NULL columns require additional space in the row to record whether their values are NULL 2013-6-5
  • To optimize your MySQL database. 6) If you have a field that will contain only a few different kinds of values, use ENUM instead of VARCHAR 2013-6-5
  • To optimize your MySQL database. 5) Always specify which columns you need when you are doing your SELECT 2013-6-5
  • To optimize your MySQL database. 4) If your application contains many JOIN queries, make sure that the columns are indexed on both tables 2013-6-5
  • To optimize your MySQL database. 3) If there are any columns in your table that you will search by, you should almost always index them 2013-6-5
  • To optimize your MySQL database. 2) Use LIMIT 1 when getting a unique row, this way the engine will stop scanning after it finds just 1 2013-6-5
  • To optimize your MySQL database. 1) Use EXPLAIN and/or DESCRIBE insight on what happening in your SELECT queries 2013-6-5
  • IBM MQ vs RabbitMQ. Winner? 2013-6-5
  • Now Android is the most popular smartphone operating system in the US http://t.co/HvmPOFgqrW 2013-6-3
  • RT @alesifuentes: LOL si no quieren saludar a sus amigos cuando andan ligando, les recomiendo no ir a los lugares que los llevan sus amigos. 2013-6-2
  • ¿Realmente es tan difícil disfrutar sin comparar? 2013-6-2
  • Para el siguiente curso hay template entre Puppet y Chef, necesitamos un ganador http://t.co/w0z243t2AW 2013-6-2
  • Hay quien no se entera que somos los mismos vestidos de novedad... 2013-6-2

Follow Me on Twitter

Hacker Garage
Tlalokes framework
PHP México
The Personal Site of...
About Freedom, UNIX, Web Programming, among other stuff

Browsing all 4 posts in Sysadmin.

10/01/12

Easy and simple guide to create your own Vagrant box (Ubuntu-12.02-64 server bridged) from VirtualBox

Leave a Comment
Easy and simple guide to create your own Vagrant box (Ubuntu-12.02-64 server bridged) from VirtualBox

An easy and simple guide to create your own Vagrant box (Ubuntu 12.02 64 Server) from VirtualBox. This can be usefull if you have specific needs not provided by the “official” Vagrant boxes.

Continue reading...

12/14/11

Execute a Git hook by branch

6 Comments
Execute a Git hook by branch

Many times I’ve been working in several projects when deployment of different webs according to a branch are necessary. Finally I just wrote a tiny Git hook script that helps me out with this matter, I hope it could help you as it does to me.

Continue reading...

04/04/11

Interview with LoadStorm

Leave a Comment
Interview with LoadStorm

This week LoadStorm, a nice website about Load Testing and Performance, interviewed me. I want to use this post to thank Scott Price for the interview, and recommend their blog and to know about the great tools they have.

Continue reading...

03/18/11

PostgreSQL vs MySQL

3 Comments
PostgreSQL vs MySQL

Uno de los errores más comunes al momento de seleccionar un RDBMS libre es basarse en la popularidad, lo que “todos usan” o que “todos sugieren” por las razones que “todos comentan”, en vez de realizar un análisis personal. Pues bien, como han sido tantos los casos que he visto, me he dado a la tarea de escribir este post que deseo ayude en la selección del RBMS que realmente necesitas.

Continue reading...