Archive for May, 2008

mySQL Performance Issue on Remote TCP/IP Connections

Published by
admin
May 16, 2008 in mySQL. 0 Comments

mySQL is a performance devil if you’re using it on your localhost or LAN. But using it on internet as a remote storage server is not mean the performance you got will performance you got in your localhost or LAN.

If you want me to sample it with an absolute ratio i can clearly say that if you’re getting 100% performance in your localhost or LAN you’ll get 15% performance while you’re connecting remote mySQL server over tcp/ip.

There is a one configuration that you can increase performance about 5 to 15 percent. That’s to disable name resolving on mySQL. You can do this by adding a line in your mySQL config (my.cnf or my.ini) after [mysqld] line (if you’re using mysqld standart daemon) : skip-name-resolve

You can test it if you want. This will make move your remote connection performance from 15% to 20 to 30%.

But infact this performance increasement will not fit your needs. It’s still so slow for me to use it. Thus please think twice if you’re willing to use mySQL as a remote database server for your client applications. ( Yeah but still it rocks on localhost or LAN )

You can check how mySQL uses DNS resolve from this document. ( Document mirror on focus on code (16KB) )

The Worst Hosting Company Ever

Published by
admin
May 7, 2008 in Administration. 0 Comments

If you’re deep inside computer related world you have to learn one of the virtues in this world. That’s patience. Your must be keep patience everytime, every day, every hour. Because you need that. In a complex senario everything goes wrong in a second. One second before you’re all right with any kind of job but after a second everything starts to come on you.

Last 4 years i’ve managed, administrated or used hostings or dedicated hostings from many company around the world. If one is from USA the other is from Germany. I tested about more than 7 hosting companies at least.

One month ago we’ve moved our sites to a new company. Infact we do not have any idea about that we’re moving our sites to worst hosting company ever. Before move i’ve checked internet for user comments about leaseweb. Most of the comments are around the support saying that worst support ever you can find. But i did not mind that comments cause success stories are not told most but failures are always spoken.

And i did a mistake!

After one month of working with Leaseweb we’ve encountered a problem. We tried to restart server but could’t. Tried to power-cycle server but we couldn’t.

Then asked leaseweb’s worst suppor ever to examine the problem.

I waited 2 days for them to make them send me a response. They said our harddisk has a problem. Needs to change with another harddisk.

We said O.K. do it.

They done it after 6 days!. For 6 days we’re closed. We could not reach any of sites. We could not reach server through SSH. The hosted firms that we’ve could not reach their emails. So nobody could do their daily works for six days!

The nightmare is not just like simple that i’ve told.

After 6 days they’ve send us an email including SSH, Panel details. But they were fully wrong. Then restarted to send emails. They’ve respond us after 1 day saying sorry for wrong details, here your true details!

Can a harddisk may burn. We can look this process as a simple process cause we’ve learned the one virtue called patience a long time ago.

But nobody can explain that to change a disk, image it, mount old disk in 7 days! That’s all totally one hour process.

But it took 7 days if you’re working with a poor hosting company that has poor customer support. Infact we can say there are no support. There are so many people saying “hey, i inform one my colleague for your process. Keep on” but you never have a chance to find a colleague that solve your problem.

For your information i neve suggest Leaseweb for any of you including my enemies!