2013/06/11 12:59 -0700, Daevid Vincent
Also, just for S&G this is how we are currently implementing it, but we feel
the REGEXP is killing our queries and while "clever" is a bit hacky and
nullifies any indexes we have on the genres column as it requires a
file_sort table scan to compare s
I am so, so glad that someone finally said what I think each time I see a
message from you Mr. James.
Original message
From: Rick James
Date: 06-12-2013 8:45 PM (GMT-04:00)
To: Daevid Vincent ,mysql@lists.mysql.com
Subject: RE: How do I select all rows of table that have
"I'm the ORIGINAL Rick James, B" (And, I'm still alive.) LOL
If you are using PHP, you might want to stop at 31 bits per INT/SET. PHP seems
not to yet be in the 64-bit world.
> -Original Message-
> From: Daevid Vincent [mailto:dae...@daevid.com]
> Sent: Wednesday, June 12, 2013 11
Oh! I must have misread. I didn't see how you had a solution for > 64 bits.
I may have to experiment with that!
> -Original Message-
> From: Daevid Vincent [mailto:dae...@daevid.com]
> Sent: Wednesday, June 12, 2013 11:26 AM
> To: mysql@lists.mysql.com
> Subject: RE: How do I select all ro
This idea is so fancy pants and clever I *wish* it could have worked for me.
I checked and we actually have 65 genres currently (with more to come I'm
sure) LOL *FML*. I'm almost ashamed I didn't think of this. I <3 me some
bitmasks and this solution is so elegant. It's unfortunate there isn't a wa
Hello Daevid,
On 6/11/2013 7:17 PM, Daevid Vincent wrote:
-Original Message-
From: shawn green [mailto:shawn.l.gr...@oracle.com]
Sent: Tuesday, June 11, 2013 2:16 PM
To: mysql@lists.mysql.com
Subject: Re: How do I select all rows of table that have some rows in
another table (AND, not
Thinking out of the box... (And posting my reply at the 'wrong' end of the
email.)...
Are there fewer than 64 genres? Use a SET or BIGINT UNSIGNED.
> > > AND sg.`genre_id` IN (10,38)
> > > AND sg.`genre_id` NOT IN (22,61)
-->
AND genre & ((1<<10) | (1<<38
independent how often you re-post it will not become magically
a MySQL problem if you have messed up your OS environment
Am 12.06.2013 15:27, schrieb Napster Cao:
>> BTW: Everytime I logged into system, I got:
>> -bash: warning: setlocale: LC_CTYPE: cannot change locale (UTF-8): No such
>> file o
Begin forwarded message:
> From: Napster Cao
> Subject: character set problem
> Date: June 11, 2013 11:04:18 PM GMT+08:00
> To: mysql@lists.mysql.com
>
> Hi Guys,
>
> I installed a new CentOS server (6.4 x86_64), and when I try to log into
> phpmyadmin, there's an ERROR:
> Can't initialize c
2013/6/12 walter harms
>
> Hi list,
> i am trying to understand the incredible use of filepointers in our mysql
> server (5.1.53).
> under normal condition the server reports 10k-15k open files pointer.
> I run a 'flush tables' every 2h to avoid problems, the number of
> users/connections is cons
Am 12.06.2013 12:03, schrieb walter harms:
> i am trying to understand the incredible use of filepointers in our mysql
> server (5.1.53).
> under normal condition the server reports 10k-15k open files pointer
harmless :-)
[root@localhost:~]$ lsof | grep mysqld | wc -l
471206
nobody but oracle
11 matches
Mail list logo
