mysql with latest utf-8

Hi,as per mysql-5.1 documentation, it can support one to three byte sequences for utf-8 .. but latest 6.0 code had support for one to four byte sequence, but it is not supported anymore...  do you  have any plan for supporting latest utf-8 in mysql-5.1? or atleast if it is possible to backport t

How To Clean Old Table Data

I have an application that crates a users email info in MySQL every time they login into the application. The only problem is once I remove their account from the application/Linux, their user data remains in the MySQL table and will eventually clutter the database. I don't know how I should or can

How To Clean Old Table Data

I have an application that crates a users email info in MySQL every time they login into the application. The only problem is once I remove their account from the application/Linux, their user data remains in the MySQL table and will eventually clutter the database. I don't know how I should or can

Dramatic performance problem

Hi to every body, I am newbie for mysql lists. I have a mysql server with 2GB of ram and Core2Duo cpu. Until today mysql server had very acceptable performance results. But today, server is very slow. No db change, no php code change. But I can't find the reason of this slowness. I am using MYS

RE: Dramatic performance problem

>-Original Message- >From: OKAN ARI [mailto:okan...@aribem.com] >Sent: Monday, July 06, 2009 10:54 AM >To: mysql@lists.mysql.com >Subject: Dramatic performance problem > >Hi to every body, I am newbie for mysql lists. I have a mysql server >with 2GB of ram and Core2Duo cpu. Until today my

RE: How To Clean Old Table Data

>-Original Message- >From: Carlos Williams [mailto:carlosw...@gmail.com] >Sent: Monday, July 06, 2009 10:53 AM >To: mysql@lists.mysql.com >Subject: How To Clean Old Table Data > >I have an application that crates a users email info in MySQL every time >they login into the application. The

RE: How To Clean Old Table Data

>-Original Message- >From: Carlos Williams [mailto:carlosw...@gmail.com] >Sent: Monday, July 06, 2009 9:59 AM >To: mysql@lists.mysql.com >Subject: How To Clean Old Table Data > >I have an application that crates a users email info in MySQL every time >they login into the application. The

What OS is the best platform for MySQL ?

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

Re: What OS is the best platform for MySQL ?

On Mon, Jul 6, 2009 at 11:33 AM, Blog Tieng Viet wrote: > 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, > becaus

RE: How To Clean Old Table Data

>-Original Message- >From: OKAN ARI [mailto:okan...@aribem.com] >Sent: Monday, July 06, 2009 11:39 AM >To: Jerry Schwartz >Subject: Re: How To Clean Old Table Data > >Thank you Jerry Schwartz and Blog Tieng Viet, > >To Viet: Mysql server is up alt lease 1 year, I have setup my.cnf and >qu

Re: What OS is the best platform for MySQL ?

In the last episode (Jul 06), Blog Tieng Viet said: > 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

Using RANDOM before GROUP BY technique returned only a single column

Hi, I am using a technique described here at: http://forums.mysql.com/read.php?20,227102,227102#msg-227102 To make results Random before applying the GROUP BY method. The query to my table structure is this: SELECT r.physicians_id, (SELECT r1.id FROM physicians_images r1 WHERE (r.physicians_id=r1

How to use LIKE for detecting numbers with commas?

Hi, I have numbers separated with commas saved into a TEXT Field, for example: ROW1: 10,5,2,8, ROW2: 2,7,9,65 ROW3: 99,100,55,10,88, etc... Now i want to make a query like this: SELECT * FROM table where numbers LIKE '%8%'; The above query when executed returned the following: ROW1: 10,5,2,8, R

Re: How to use LIKE for detecting numbers with commas?

It's ugly, but this should work: SELECT * FROM table where numbers LIKE '8,%' or numbers LIKE '%,8,%' or numbers LIKE '%,8' -- B - Original Message - From: "Highviews" To: Sent: Monday, July 06, 2009 6:31 PM Subject: How to use LIKE for detecting numbers with commas? Hi, I ha

Re: How to use LIKE for detecting numbers with commas?

In the last episode (Jul 06), avrom...@whyisitthat.com said: > From: "Highviews" > > I have numbers separated with commas saved into a TEXT Field, for > > example: > > > > ROW1: 10,5,2,8, > > ROW2: 2,7,9,65 > > ROW3: 99,100,55,10,88, > > etc... > > > > Now i want to make a query like this: > > SEL