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
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
');
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 trying
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
i am also able
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,
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
?
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 directly
--
---
(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
');
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
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
to
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
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
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
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
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
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
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
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.
Is
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
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 (usually
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 second
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 myself.
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 Embedded in
23 matches
Mail list logo