Nov 05 2009

Synchronize The date On a Linux Server

Categoria: Linux=IceBurn= @ 18:53 — 34 visualizações

Is your server’s clock ahead in time? Or is it in the past?

Well, here is the right time to set your date correctly, but how? It’s fairly easy in fact, just use rdate command.

rdate is a Linux command for immediate date and time setup from another machine.

Continuar a ler o artigo…

Etiquetas:


Out 15 2008

MySQL Data Types – Benchmarking The Perfect Database

Categoria: MySQL=IceBurn= @ 15:45 — 267 visualizações

When benchmarking your database, you have several options of data types, you must concentrate in all the possible data that you may have to store in a specific field.

Choosing the right data type will make all the difference when in production environment, the right MySQL structure will have the maximum performance, which means that your applications will run faster, however bad data types for certain data will kill your application.

If you are one of those persons that use VARCHAR for everything (or almost), you’ve been missing all the MySQL power.
Continuar a ler o artigo…

Etiquetas: , , , ,


Out 10 2008

Easily Load Your Pages Faster With Compressed CSS

Categoria: PHP=IceBurn= @ 12:16 — 671 visualizações

CSS brought us so many possibilities! Luckily, I’ve started my first HTML pages, back in 2004, using style sheets, so the old table based layout that old school designers still use these days simple because they stopped in time 10 years ago, are history.

Now that the possibilities are almost infinite, we started using more and more CSS in web design/(X)HTML structure. But most people forget the essentials, the page loading time and bandwidth spent.
Continuar a ler o artigo…

Etiquetas: , , , , , , , ,


Out 05 2008

Speed Up MySQL: Replace or On Duplicate Key Update?

Categoria: MySQL=IceBurn= @ 17:57 — 608 visualizações

It comes to a time when you need to optimize your code to the maximum. Usually most people do not worry to much about code performance or speed, this is a big mistake.

However, when you have your own server and less performance means more memory usage, you will get to the point the hard way. Most of the time, more memory usage means more hardware failure and server slow downs and down times.
Continuar a ler o artigo…

Etiquetas: , , , , , ,


Out 02 2008

Count & Display The Total Number of MySQL Queries

Categoria: PHP=IceBurn= @ 18:42 — 869 visualizações

It’s quite often to see at the end of some boards like SMF for example, the total number of the total queries made to the MySQL database.

I understand that some people believe that those queries are retrieved by an extra MySQL query, but the reality is that there is no query for that, so we have to do some extra PHP code.
Continuar a ler o artigo…

Etiquetas: , , , , , , , , , , ,


Out 01 2008

Change The Time Zone For an Entire Directory

Categoria: Apache=IceBurn= @ 23:06 — 404 visualizações

Usually just because you have your site hosted on a server located in the other side of the globe, does not mean that you have to relay on the server’s time zone.

There are several methods, I’ve used a couple of them myself in the early days when developing my first scripts.

Most of them consisted in setting the time zone in runtime, but sometimes it’s not an easy task, especially when you have a code that is not ready or is not well organized. That means you had to edit each file, setting the time zone.
Continuar a ler o artigo…

Etiquetas: , , , , , , , ,


Set 30 2008

Install ffmpeg, PHP and eAccelerator on Dreamhost

Categoria: Linux=IceBurn= @ 20:45 — 1.743 visualizações

I recently had to install ffmpeg on a Dreamhost VPS client, but I’m sure that as long as you have shell access, you will be able to install it on any host. You don’t even need to have root access.

If you are looking for a way to install ffmpeg, follow the steps bellow and you will have no problems, as this is an exact transcription of what I did, and I had no problems.
Continuar a ler o artigo…

Etiquetas: , , , , , , , , , , , ,