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 w...@singerwang.com wrote: From: Singer X.J. Wang w...@singerwang.com Subject: Re: ERROR 2013

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
kenmy...@icarz.com Subject: Re: What OS is the best platform for MySQL ? To: Dan Nelson dnel...@allantgroup.com Cc: Blog Tieng Viet blogtiengv...@yahoo.com, 'Carlos Williams' carlosw...@gmail.com, mysql@lists.mysql.com, Jerry Schwartz jschwa...@the-infoshop.com Date: Wednesday, July 8, 2009, 11:10 PM

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

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