Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

2012-03-07 Thread Blog Tieng Viet
If you did not work directly on mysql server (login by mysql command), please try this. Using script (PHP, ...) may lose connection, as my experience. Best --- On Mon, 3/5/12, Singer X.J. Wang wrote: > From: Singer X.J. Wang > Subject: Re: ERROR 2013 (HY000): Lost connection to MySQL server d

How to get a specific number of entries per one key ?

2011-12-03 Thread Blog Tieng Viet
Hellow everybody. I have a problem difficult for me, please give me an advice. I want to get a specific number of entry (rows) from a table by each Key. If the number is 1, I can use "select dinstinct", but the number is not 1, I don't know how to select. For example: Key 0 | data 0-0 Key 0 |

Re: What OS is the best platform for MySQL ?

2009-07-09 Thread Blog Tieng Viet
is the best platform for MySQL ? To: "Dan Nelson" Cc: "Blog Tieng Viet" , "'Carlos Williams'" , mysql@lists.mysql.com, "Jerry Schwartz" Date: Wednesday, July 8, 2009, 11:10 PM Dan Nelson wrote: > In the last episode (Jul 06), Blog Tieng V

What OS is the best platform for MySQL ?

2009-07-06 Thread Blog Tieng Viet
Dear All,   I have been using MySQL on FreeBSD for 3 years and encounterd a lot of problems related to thread management. And 1 year ago, I found that my FreeBSD box does not go well with any MySQL revision after 5.1.17-beta, because the MySQL thread does not end although complied with LINUX_THR

How to tune my Mysql server ?

2009-07-03 Thread Blog Tieng Viet
Dear all,   I am running mysql server sharing with apache web server in a box of freebsd 6.4. Hardware spec is roughly as bellow: CPU: Xeon 3.06GHz x 2 Mem: 4GB   The version of Mysql is 5.1.17_beta, a pre-complied binary package for FreeBSD.   Recently the apache request raises quickly, sometime