On Fri, Sep 26, 2008 at 4:15 PM, Dan Nelson <[EMAIL PROTECTED]> wrote:
> In the last episode (Sep 26), Ian Monroe said:
>> On Fri, Sep 26, 2008 at 1:55 PM, Ian Monroe <[EMAIL PROTECTED]> wrote:
>> > On Fri, Sep 26, 2008 at 9:37 AM, Ian Monroe <[EMAIL PROTECTED]> wrote:
>> >> So we're using MySQL Em
In the last episode (Sep 26), Ian Monroe said:
> On Fri, Sep 26, 2008 at 1:55 PM, Ian Monroe <[EMAIL PROTECTED]> wrote:
> > On Fri, Sep 26, 2008 at 9:37 AM, Ian Monroe <[EMAIL PROTECTED]> wrote:
> >> So we're using MySQL Embedded in Amarok, it works fine for most of us
> >> that use 5.1, including
On Fri, Sep 26, 2008 at 1:55 PM, Ian Monroe <[EMAIL PROTECTED]> wrote:
> On Fri, Sep 26, 2008 at 9:37 AM, Ian Monroe <[EMAIL PROTECTED]> wrote:
>> So we're using MySQL Embedded in Amarok, it works fine for most of us
>> that use 5.1, including myself. However the following backtrace is
>> from the
On Fri, Sep 26, 2008 at 1:55 PM, Ian Monroe <[EMAIL PROTECTED]> wrote:
> On Fri, Sep 26, 2008 at 9:37 AM, Ian Monroe <[EMAIL PROTECTED]> wrote:
>> So we're using MySQL Embedded in Amarok, it works fine for most of us
>> that use 5.1, including myself. However the following backtrace is
>> from the
On Fri, Sep 26, 2008 at 2:27 PM, Martin Gainty <[EMAIL PROTECTED]> wrote:
> 2 items-
>
> check that the my.cnf file cannot be found on your path
Yea its right, plus we tried switching to --no-defaults instead of
specifying an (empty) file. That didn't work either.
> or your server groups are (usu
2 items-
check that the my.cnf file cannot be found on your path
or your server groups are (usually just server, client) are incorrect
Martin
__
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the offici
On Fri, Sep 26, 2008 at 9:37 AM, Ian Monroe <[EMAIL PROTECTED]> wrote:
> So we're using MySQL Embedded in Amarok, it works fine for most of us
> that use 5.1, including myself. However the following backtrace is
> from the second person to have this issue. Its repeatable, happens at
> startup.
>
>
Hi all:
I read in mysql documentation that searches are case-insensitive by
default but this default behaviour can be changed using a latin1_bin
collation. But, is there any way to make searches sensitive or
unsensitive to accents, umlauts, etc.?
I suppose that queries are accent sensitive by def
Hi Eric-
the immediate challenge is to fic the join statement so
make sure products.id is indexed
make sure browse_nodes_to_products.product_id is indexed
make sure browse_nodes_to_products.browse_node_id is indexed
make sure browse_nodes.amazon_id is indexed
there seems to be mapping/relations
On Friday, 26. September 2008, Tim Carty wrote:
| I would like to combine multiple tables into a single table. I can create a
| UNION between tables with similar columns cols A, B, and C from table_1
| with cols A, B, and C from Table_2. What I can¹t figure out is how to add
| additionals column
Use null (or custom text) to replace the missing columns
A quick ex:
Select a,b,c,null,d from table1
Union all
Select d,'test valid',e,f,g from table 2
This e-mail, including any attachments, may be confidential, privileged or
otherwis
Good morning everyone,
I've got a sql statement that is running quite slow. I've indexed
everything I can that could possibly be applicable but I can't seem to
speed it up.
I've put up the table structures, row counts, the sql statement and
the explain dump of the sql statement all in pas
I would like to combine multiple tables into a single table. I can create a
UNION between tables with similar columns cols A, B, and C from table_1
with cols A, B, and C from Table_2. What I can¹t figure out is how to add
additionals columns (D, E, F) from table_2 if the columns don¹t exist in
T
So we're using MySQL Embedded in Amarok, it works fine for most of us
that use 5.1, including myself. However the following backtrace is
from the second person to have this issue. Its repeatable, happens at
startup.
Is there something about how their MySQL is setup on their system that
could cause
On Fri, Sep 26, 2008 at 1:54 AM, Aaron Blew <[EMAIL PROTECTED]> wrote:
> Hi Michael,
> Overall and most of the time, SANs are a good thing. They have several
> advantaged over dedicated directly attached storage arrays:
> 1.) They're generally a lot smarter about how and when they write and read
Hi,
ok i got it working. it was a typo(lol), i missed from in the initial select
statment
Wrong
###
select * db_users where db_id=(SELECT id FROM data_bases where
dom_id=(SELECT id FROM domains where name='abc.com'));
Correct
##
select * from db_users where db_id=(SELECT id
--
>
> ---
>
> (SELECT id FROM domains where name='abc.com');
>
> gives a result of 124
>
>
> i am also able to use and get proper results for the following query:
>
> select * from domains where id=(SELECT id FROM domains where name='abc.com
> ');
>
IO also depends on how many DISK controllers are used. The more controllers,
better would be IO distribution among spindles
On 9/26/08, Aaron Blew <[EMAIL PROTECTED]> wrote:
>
> Hi Michael,
> Overall and most of the time, SANs are a good thing. They have several
> advantaged over dedicated direct
Yes, mysql by default sets the socket file in the below directory
/var/lib/mysql/mysql.sock.
But why does it refer to /tmp/mysql.sock file then, as that was the error
which was given when i tried to login to mysql.
Is that hard-coded for MySQL5.1 source code, which is what i wanted to know
?
Th
Hi Michael,
Overall and most of the time, SANs are a good thing. They have several
advantaged over dedicated directly attached storage arrays:
1.) They're generally a lot smarter about how and when they write and read
to the disks. Often they understand what's going on down at the head level,
and
what is the issue ur facing.
Any syntax error or something else.
trying usin "IN" instead of "="
On 9/26/08, Madan Thapa <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
>
> -
>
> (SELECT id FROM domains where name='abc.com');
>
> gives a result of 124
>
>
please check your my.cnf for the location of mysql.sock file.
If i am not wrong mysql by default creates the mysql.sock file
/var/lib/mysql.
On 9/26/08, Sudhir Menon <[EMAIL PROTECTED]> wrote:
>
> Hello,
>
> I have mysql-5.0.22-2.1.0.1.rpm version installed on RHEL5.1 system. I have
> been tryin
Hi,
-
(SELECT id FROM domains where name='abc.com');
gives a result of 124
i am also able to use and get proper results for the following query:
select * from domains where id=(SELECT id FROM domains where name='abc.com
');
--
Hello,
I have mysql-5.0.22-2.1.0.1.rpm version installed on RHEL5.1 system. I have
been trying certain benchmarking tools and
found that MySQL5.1 has inbuilt benchmarking tool known as "mysqlslap".
Since the tool is not available
for MySQL5.0, i have downloaded the source rpm
MySQL-community-5.1.2
24 matches
Mail list logo
