Thanks for the all answers !!!
It's ok,
even if I have three different my.cnf for my three instances,
my general my.cnf is:
[mysqld_multi]
mysqld = /opt/local/mysql50/bin/mysqld_safe
mysqladmin = /opt/local/mysql50/bin/mysqladmin
user = root
password = mysys2008srv
log =
Hi,
If anyone could point me in the right direction, I'd be most grateful.
Thanks !
Neil
On Mon, Dec 22, 2008 at 9:55 AM, Tompkins Neil neil.tompk...@googlemail.com
wrote:
Hi
I'm having trouble trying to figure this out. Any help/example would be
grateful.
Thanks
Neil
On Sun, Dec
OK, I've made further progress by changing GROUP BY ProductTB.ProductID,
MasterTB.MasterID to GROUP BY MasterTB.MasterID.
However ProductTB.Supplier is showing the incorrect Supplier. Why is this ?
Thanks
Neil
On Mon, Dec 22, 2008 at 11:45 AM, Tompkins Neil
neil.tompk...@googlemail.com wrote:
prajapat...@gmail.com (Krishna Chandra Prajapati) writes:
You are running three mysql instance on single server. You can have three
my.cnf say my.cnf, my1.cnf, my2.cnf with different port and socket and other
information in them. In this way you can set the prompt for different
instance.
On Fri, Dec 19, 2008 at 1:03 PM, Tompkins Neil
neil.tompk...@googlemail.com wrote:
Hi,
I've the following query which I'm having problems with. Basically I have
a 5 tables as follows :
MasterTB - Contains list of master records
LookupTB - Contains relationship between MasterTB to ProductTB
Hi,
I've the following query which I'm having problems with. Basically I have
a 5 tables as follows :
MasterTB - Contains list of master records
LookupTB - Contains relationship between MasterTB to ProductTB
ContentTB - Contains description of product, and location of data files
PriceTB -
On Fri, Dec 19, 2008 at 7:03 PM, Tompkins Neil wrote:
Basically each product is listed in the master table, and can have a number
of suppliers linked to it (ProductTB). The query above will show me a list
of products for all suppliers for a particular product. However I want to
be able to
13:19
To: chaim.rie...@gmail.com
Cc: BAJAJ POOJA; mysql@lists.mysql.com
Subject: Re: MYSQL startup problem
can you check the output of netstat -n or netstat -an and find if port
3306 is listening?
Regards,
Chandru
www.mafiree.com
On Fri, Dec 12, 2008 at 1:12 PM, chaim.rie...@gmail.com wrote
-
From: chaim.rie...@gmail.com [mailto:chaim.rie...@gmail.com]
Sent: 12 December 2008 13:13
To: BAJAJ POOJA; Chandru
Cc: mysql@lists.mysql.com
Subject: Re: MYSQL startup problem
When you do the following
Mysql -h localhost -u root.
What do you get ?
Sent via BlackBerry from T-Mobile
POOJA; Chandru
Cc: mysql@lists.mysql.com
Subject: Re: MYSQL startup problem
When you do the following
Mysql -h localhost -u root.
What do you get ?
Sent via BlackBerry from T-Mobile
-Original Message-
From: BAJAJ POOJA pooja.ba...@alcatel-lucent.com
Date: Fri, 12 Dec 2008 08:43
: 12 December 2008 13:40
To: BAJAJ POOJA
Cc: chaim.rie...@gmail.com; mysql@lists.mysql.com
Subject: Re: MYSQL startup problem
Hi,
I think you may have to get me the output of netstat -an (this only
tells the ports that are all listening). sorry for the confusion.
can you connect using mysql
%3apooja.ba...@alcatel-lucent.com
Phone:+124-413-3078 | Onnet: 2721-3078
--
*From:* Chandru [mailto:chandru@gmail.com]
*Sent:* 12 December 2008 13:40
*To:* BAJAJ POOJA
*Cc:* chaim.rie...@gmail.com; mysql@lists.mysql.com
*Subject:* Re: MYSQL startup problem
Hi
, if more than ten are in the process of handshaking (e.g. SYN_SENT
state). In theory this is to limit SYN floods and other connection attacks. To confirm
if this is your problem, check your windows event viewer for system events with event id
4226: TCP/IP has reached the security limit
Your ten
From: Chandru [mailto:chandru@gmail.com]
Sent: 12 December 2008 12:50
To: BAJAJ POOJA
Cc: mysql@lists.mysql.com
Subject: Re: MYSQL startup problem
Hi,
By default you can find them in the datadirectory ( the place where you
have all your databases stored)
Regards,
Chandru
Hi,
I am using wamp server version 1.1.
When I try to start wamp server, It starts apache only, and does not
starts mysql service.
I tried to start mysql service independently, even that is not possible.
Pls. let me know if any solution available.
--
Thanks Regards
Pooja Bajaj
Alcatel-Lucent,
Hi,
can you please look at the mysql error logs? if you are not able to figure
out the reason, please paste the error log.
Regards,
Chandru
www.mafiree.com
On Fri, Dec 12, 2008 at 11:52 AM, BAJAJ POOJA
pooja.ba...@alcatel-lucent.com wrote:
Hi,
I am using wamp server version 1.1.
When
11:58
To: BAJAJ POOJA
Cc: mysql@lists.mysql.com
Subject: Re: MYSQL startup problem
Hi,
can you please look at the mysql error logs? if you are not able to
figure out the reason, please paste the error log.
Regards,
Chandru
www.mafiree.com
On Fri, Dec 12, 2008 at 11:52 AM, BAJAJ POOJA
@lists.mysql.com
Subject: Re: MYSQL startup problem
Hi,
can you please look at the mysql error logs? if you are not able to
figure out the reason, please paste the error log.
Regards,
Chandru
www.mafiree.com
On Fri, Dec 12, 2008 at 11:52 AM, BAJAJ POOJA
pooja.ba...@alcatel-lucent.com wrote
POOJA
*Cc:* mysql@lists.mysql.com
*Subject:* Re: MYSQL startup problem
Hi,
can you please look at the mysql error logs? if you are not able to
figure out the reason, please paste the error log.
Regards,
Chandru
www.mafiree.com
On Fri, Dec 12, 2008 at 11:52 AM, BAJAJ POOJA
startup problem
Hi,
By default you can find them in the datadirectory ( the place where you
have all your databases stored)
Regards,
Chandru
www.mafiree.com
On Fri, Dec 12, 2008 at 12:42 PM, BAJAJ POOJA
pooja.ba...@alcatel-lucent.com wrote:
Hi Chandru,
Can you pls. help where can i search
, India
Email:pooja.ba...@alcatel-lucent.com
Phone:+124-413-3078 | Onnet: 2721-3078
From: Chandru [mailto:chandru@gmail.com]
Sent: 12 December 2008 12:50
To: BAJAJ POOJA
Cc: mysql@lists.mysql.com
Subject: Re: MYSQL startup problem
Hi,
By default you can
problem
Hi,
Pls find logs attached below in mail:
080605 15:28:08 InnoDB: Started
c:\wamp\mysql\bin\mysqld-nt.exe: ready for connections.
Version: '4.0.18-nt-log' socket: '' port: 3306
080606 9:32:18 c:\wamp\mysql\bin\mysqld-nt.exe: Normal shutdown
080606 9:32:18 InnoDB: Starting
[mailto:chaim.rie...@gmail.com]
Sent: 12 December 2008 13:02
To: BAJAJ POOJA; Chandru
Cc: mysql@lists.mysql.com
Subject: Re: MYSQL startup problem
It says that is started mysql
Can you telnet to port 3306 ?
Sent via BlackBerry from T-Mobile
-Original Message-
From: BAJAJ POOJA pooja.ba...@alcatel
@lists.mysql.com
Subject: RE: MYSQL startup problem
Hi,
It doesn't allows me to telnet port 3306.
If I ping that port I receive Request timed out.
--
Thanks Regards
Pooja Bajaj
Alcatel-Lucent, India
Email:pooja.ba...@alcatel-lucent.com
Phone:+124-413-3078 | Onnet: 2721-3078
-Original Message
-Mobile
-Original Message-
From: BAJAJ POOJA pooja.ba...@alcatel-lucent.com
Date: Fri, 12 Dec 2008 08:43:45
To: chaim.rie...@gmail.com; Chandruchandru@gmail.com
Cc: mysql@lists.mysql.com
Subject: RE: MYSQL startup problem
Hi,
It doesn't allows me to telnet port 3306.
If I
To: chaim.rie...@gmail.com; Chandruchandru@gmail.com
Cc: mysql@lists.mysql.com
Subject: RE: MYSQL startup problem
Hi,
It doesn't allows me to telnet port 3306.
If I ping that port I receive Request timed out.
--
Thanks Regards
Pooja Bajaj
Alcatel-Lucent, India
Email:pooja.ba...@alcatel
I am trying to develop an db app w/ OO base as the front end to mysql
db that is running on the web in a shared hosting environment using
jdbc as the connector.
The problem is if I let OO base sit for a few minutes it looses the
connection to the db and I have to restart OO base to get
environment using
jdbc as the connector.
The problem is if I let OO base sit for a few minutes it looses the
connection to the db and I have to restart OO base to get it to
reconnect.
Not only is this a major pain but if I can't fix it I can't expect my
client to constantly be restarting the OO
For the curious: As usual select is not broken.
Lesson learned: Always watch out for warnings:
http://bugs.mysql.com/bug.php?id=41007
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Gautam
nope yours is not a bug. That's all fine. Hex numbers are 64 bit
unsigned.
So for -1 you have to insert cast(0x as signed).
Cheers,
Daniel
Hi Daniel,
I can see the problem without using update. However, I am a newbie
at
mysql,
so can't say for certain if it's
Hi everybody -
I'm experiencing some really weird update behaviour (mysql 5.0) when
or'ing results from subselects using Long.MIN_VALUE.
But before I post a bug report I wanted to ask if I'm missing something.
drop table if exists foo;
drop table if exists bar;
create table foo (fooid int,
Hi Daniel,
I can see the problem without using update. However, I am a newbie at
mysql,
so can't say for certain if it's a bug:
mysql drop table if exists foo;
mysql create table foo (id int signed, val bigint signed);
mysql insert into foo values (0x, 0x), (-1, -1
alter table tablename modify id int not null auto_increment primary key;
On Sat, Oct 25, 2008 at 2:48 AM, Paul [EMAIL PROTECTED] wrote:
Anybody know if there's a way to change a primary key field that is not
auto-incremented, turning on auto-increment but preserving the values that
are
Anybody know if there's a way to change a primary key field
that is not auto-incremented, turning on auto-increment but
preserving the values that are currently in it?
TIA,
Paul W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
hi all...
i have a strange problem with a simple script that is doing select into
outfile...
the thing just does that. it does a select into an outfile. if i print
the query that's passed to mysql_result in the script and then copy it
and paste it z`into the mysql client it works fine
Timestamp is the best bridge between java and mysql,I think.
On Sun, Oct 19, 2008 at 4:48 PM, Rama [EMAIL PROTECTED] wrote:
DATE TIME ZONE SENSITIVE
DATETIME NOT SENSITIVE TO TIME ZONE
TIMESTAMP TIMEZONE SENSITIVE
iam getting the above problem as date is timezone sensitive.i resolved
iam sorry iam facing same problem with the datetime iam confused and
working/investigating on it.
Problem is :
Java Program MYSQL
- --
-
Default timezone : GMT
Learnt!
On Wed, Oct 15, 2008 at 5:28 PM, philip [EMAIL PROTECTED] wrote:
Date: Tue, 14 Oct 2008 16:55:11 +0300
From: Olexandr Melnyk [EMAIL PROTECTED]
To: [EMAIL PROTECTED], mysql@lists.mysql.com
Subject: Re: Problem with GROUP BY
http://jan.kneschke.de/projects/mysql/groupwise-max
hi martin,Thanks,
But my problem is Why it is printing wrong date ( 2008-10-20 06:23:09 ) instead
of ( 2008-10-20 12:23:09 )
what is going wrong here?
On Tue, Oct 21, 2008 at 7:33 AM, Martin Gainty [EMAIL PROTECTED] wrote:
look at the MySQL doc to figure out whats going on
default MySQL
2008/10/19 Rama [EMAIL PROTECTED]
hi,
iam using java,hibernate,mysql
i am storing *19-10-2008 (*of type java.sql.Date) (TIMEZONE GMT) to
mysql
DATE field.
when i retrieve the same date from mysql to java it is being displayed as
*18-10-2008 18:30:00 GMT *
i could not able to
i figured out the root cause of the problem.
1) Java TIME ZONE is GMT --- storing DATE (2008-10-19
which is in GMT )
2) storing the above date in GMT to mysql
3) MYSQL TIME ZONE IS GMT+05:30
4) as mysql time zone is GMT+05:30 it is viewing the date as (2008-10-19
. (timezone sensitive)
On Sun, Oct 19, 2008 at 1:27 PM, Rama [EMAIL PROTECTED] wrote:
i figured out the root cause of the problem.
1) Java TIME ZONE is GMT --- storing DATE (2008-10-19
which is in GMT )
2) storing the above date in GMT to mysql
3) MYSQL TIME ZONE
SK wrote:
2008/10/19 Rama [EMAIL PROTECTED]
hi,
iam using java,hibernate,mysql
i am storing *19-10-2008 (*of type java.sql.Date) (TIMEZONE GMT) to
mysql
DATE field.
when i retrieve the same date from mysql to java it is being displayed as
*18-10-2008 18:30:00 GMT *
i could not
DATE TIME ZONE SENSITIVE
DATETIME NOT SENSITIVE TO TIME ZONE
TIMESTAMP TIMEZONE SENSITIVE
iam getting the above problem as date is timezone sensitive.i resolved it
by changing the field type from date to string.
YOu can use any method to fill the DATE field of mysql .which method we
use
hi,
iam using java,hibernate,mysql
i am storing *19-10-2008 (*of type java.sql.Date) (TIMEZONE GMT) to mysql
DATE field.
when i retrieve the same date from mysql to java it is being displayed as
*18-10-2008 18:30:00 GMT *
i could not able to figure out what is going wrong . can any one
Date: Tue, 14 Oct 2008 16:55:11 +0300
From: Olexandr Melnyk [EMAIL PROTECTED]
To: [EMAIL PROTECTED], mysql@lists.mysql.com
Subject: Re: Problem with GROUP BY
http://jan.kneschke.de/projects/mysql/groupwise-max
2008/10/14 Peter Brawley [EMAIL PROTECTED]
Philip
mysql SELECT number
Philip
mysql SELECT number, MAX(event), name FROM info GROUP BY number;
For discussion examples see Within-group aggregates at
http://www.artfulsoftware.com/queries.php.
PB
-
philip wrote:
I created a table with,
CREATE TABLE info (
number INTEGER UNSIGNED,
event INTEGER
http://jan.kneschke.de/projects/mysql/groupwise-max
2008/10/14 Peter Brawley [EMAIL PROTECTED]
Philip
mysql SELECT number, MAX(event), name FROM info GROUP BY number;
For discussion examples see Within-group aggregates at
http://www.artfulsoftware.com/queries.php.
PB
-
philip
I created a table with,
CREATE TABLE info (
number INTEGER UNSIGNED,
event INTEGER UNSIGNED,
name VARCHAR(2000) NOT NULL,
PRIMARY KEY (number, event)
);
and populated it with data to produce this,
++---+---+
| number | event | name |
++---+---+
|
So with skip-name-resolve in my.cnf (and MySQL restarted), it should
be okay to have [EMAIL PROTECTED] in the GRANT table since localhost
resolves without DNS lookup? Or do I need to specify [EMAIL PROTECTED]
Sorry, just need to clarify this bit before changing a few things.
Thanks again.
Presently, I'm only using localhost for MySQL database user
privileges, e.g., :
[EMAIL PROTECTED] -- for all privileges on all databases
Do I need to change the above if I add skip-name-resolve to my.cnf?
(Since localhost is, I thought, not really part of DNS but just an
alias for
from http://dev.mysql.com/doc/refman/5.1/en/connecting.html
On Unix, MySQL programs treat the hostname |localhost| specially, in a
way that is likely different from what you expect compared to other
network-based programs. For connections to |localhost|, MySQL programs
attempt to connect to
Thanks. I've read those links, and they sound like my problem.
On each connection, MySQL calls gethostbyname() to resolve the
hostname in the connection string into 127.0.0.1 -- e.g.,
mysql_connect(localhost, user, password) - 127.0.0.1. Because
FreeBSD 4.0's (and Mac OS X's) DNS lookups
distribution to any party other than intended recipient. Sender does
not necessarily endorse content contained within this transmission.
CC: [EMAIL PROTECTED]; mysql@lists.mysql.com
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Ancient, unsolved high-CPU problem -- vmstat, top
links, and they sound like my problem.
On each connection, MySQL calls gethostbyname() to resolve the
hostname in the connection string into 127.0.0.1 -- e.g.,
mysql_connect(localhost, user, password) - 127.0.0.1. Because
FreeBSD 4.0's (and Mac OS X's) DNS lookups aren't thread-safe, bad
intended recipient.
Sender does not necessarily endorse content contained within this
transmission.
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Ancient, unsolved high-CPU problem
Date: Mon, 22 Sep 2008 19:41:25 +0200
For the longest time, I've had a strange problem
and Sender does not endorse distribution to any party other
than intended recipient. Sender does not necessarily endorse content
contained within this transmission.
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Ancient, unsolved high-CPU problem
Date: Mon, 22 Sep 2008 19:41:25
) to complete then the
rest build up quickly. Something else could be locking the table
that your cron queries are trying to access, causing the stacking that
never recovers.
Once the problem occurs I'd be using 'show processlist' in mysql, and
vmstat and ps to check the system resources
else could be locking
the table that your cron queries are trying to access, causing the
stacking that never recovers.
Once the problem occurs I'd be using 'show processlist' in mysql,
and vmstat and ps to check the system resources. Is it definitely
mysql, or php/apache, a slow disk
longer (especially if the queries are the same) to complete
then the rest build up quickly. Something else could be locking
the table that your cron queries are trying to access, causing the
stacking that never recovers.
Once the problem occurs I'd be using 'show processlist' in mysql
nothing on a server is weird, just not understood yet :-)
so, 'show processlist' comes up with nothing. Does 'ps auxw' show
any php processes still active? Does 'netstat -atp' show any
established connections to mysql?
How long does it take to re-create the problem? You've restarted
, causing the stacking that
never recovers.
Once the problem occurs I'd be using 'show processlist' in mysql, and
vmstat and ps to check the system resources. Is it definitely mysql,
or php/apache, a slow disk, etc..
In terms of your stats below, I have (on a fairly average spec
server) 500
For the longest time, I've had a strange problem with MySQL.
Basically, after a certain amount of time--sometimes a few days,
sometimes a couple weeks--its CPU usage will go from a steady 20-30%
to 80-90%. Actual load and number of queries is the same, nothing else
changes.
If I shutdown
problem
Date: Mon, 22 Sep 2008 19:41:25 +0200
For the longest time, I've had a strange problem with MySQL.
Basically, after a certain amount of time--sometimes a few days,
sometimes a couple weeks--its CPU usage will go from a steady 20-30%
to 80-90%. Actual load and number of queries
- Original Message -
From: Darryle Steplight [EMAIL PROTECTED]
To: MySql [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, September 09, 2008 6:59 PM
Subject: Re: Weird problem with mysql_query
Hi G,
There is nothing weird about your results. When you do a Count
I don't have that much experience with MySQL having mostly worked with
MSSQL, but I'm sure the logic is still the same. I believe the query
select count(*) as 'count' from logins GROUP BY dawiz will fail
because dawiz is not a column, it's a value within the table.
If I'm not mistaken, a
We are running MySql version 5.0.45-Debian_1ubuntu3.1-log Debian etch
distribution under Ubuntu.
If I submit the following query via mysql_query it acts as if the where is not
there:
select count(*) as 'Count' from logins where player = 'aqwert';
this returns:
Count
143578160
Submitting
Hi G,
There is nothing weird about your results. When you do a Count(*)
without a GROUP BY(someColumn) you are essentially asking MySQL how
many rows are present in the table. But when you do use Group By
someColum , you are asking MySql how many rows do I have of
someColumn . It's just a
Well, for your simple example, you can use query variables to add the
counters.
SET @cntr:=0, @lastVal:='A'
INSERT INTO tableB LOC,DATA SELECT CONCAT(LOC,
CONCAT( IF(@lastVal=LOC, @cntr:[EMAIL PROTECTED], @cntr:=0),
IF(@lastVal:=LOC,'',''))) LOC, CONCAT(DATA, @cntr) FROM tableA ORDER
BY
Thanks for the tip. I am looking at just making 16 separate queries.
It will be easier to manage and faster to run.
Dan
On Sep 6, 2008, at 9:37 PM, Brent Baisley [EMAIL PROTECTED] wrote:
Well, for your simple example, you can use query variables to add
the counters.
SET @cntr:=0,
I have an existing data set - here is an example (the real one is more
complex than this)
LOC DATA
-
A 1
B 2
C 3
D 4
E 5
F 6
...
and I am looking to run some sort of INSERT ... SELECT on this to make
a new table like this:
LOC
Hi.
I setup two masters to replicatin with each other, say A and B.
A's server id is 1, B's id is 2.
then because of some reason, I must change A's server id to 11. I do
it by changing options in my.cnf and restaring mysql sever.
but a problem happened: A and be make up a LOOP.
that is, when
Hi all:
I need to set a cursor for doing a SELECT (using the C API)
According the documentation I did in order to setup the cursor.
---
const unsigned long cursor_type = CURSOR_TYPE_READ_ONLY;
if (mysql_stmt_attr_set (mysql_stmt, STMT_ATTR_CURSOR_TYPE,
(void *) cursor_type)) {
Hi all:
I need to set a cursor for doing a SELECT (using the C API)
According the documentation I did in order to setup the cursor.
---
const unsigned long cursor_type = CURSOR_TYPE_READ_ONLY;
if (mysql_stmt_attr_set (mysql_stmt, STMT_ATTR_CURSOR_TYPE,
(void *) cursor_type)) {
Hi All,
I am facing a particular problem which i have explained here. Can
you please let me know a solution for this.
From my web application, I am trying to connect the MySQL server by
using the IP address as the server name, and it says the following
error:
Host 'abc.def.com
me know if there is any other way out.
Regards
Ahmad
-Original Message-
From: Parikh, Dilip Kumar [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2008 3:26 PM
To: Ahmadbasha Shaik (WT01 - E-ENABLING); Raghavendra Hosabettu (WT01 -
Innovation Group)
Subject: FW: Problem - Host
make sure to FLUSH PRIVILAGES;
- Original Message
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Sent: Monday, 14 July, 2008 10:59:35 AM
Subject: RE: Problem - Host 'abc.def.com' is not allowed to connect
- E-ENABLING); Raghavendra Hosabettu (WT01 -
Innovation Group)
Subject: FW: Problem - Host 'abc.def.com' is not allowed to connect to
this MySQL server, Please advice..
Ok It means that DNS not configured so better give the IP address
instead of hsostname and check using in mysql as
Show grants
)
Subject: FW: Problem - Host 'abc.def.com' is not allowed to connect to
this MySQL server, Please advice..
Ok It means that DNS not configured so better give the IP address
instead of hsostname and check using in mysql as
Show grants for [EMAIL PROTECTED];
This should show u the grants
On Wed, Jul 9, 2008 at 9:37 AM, Phil [EMAIL PROTECTED] wrote:
Is it possible to do an insert into with subselect and group by with an
additional on duplicate insert ?
CREATE TABLE NEW_TABLE (
`a` varchar(10),
`b` double
) engine=MyISAM;
INSERT INTO NEW_TABLE (select old.x,sum(old.y)
Hi
while testing an upgrade from 3.23.58 to 4.1.22 on an FC3 test box
SELECT * FROM Contacts WHERE Categories=Services and BusinessCodes REGEXP
^R and gold_id=2 ORDER BY Company ASC
on mysql server3.23.58 i get company result in ASC order.
on mysql server4.1.22 i get non ASC order for
BY Company ASC
-Original Message-
From: Obantec Support [mailto:[EMAIL PROTECTED]
Sent: Friday, July 11, 2008 9:29 AM
To: mysql@lists.mysql.com
Subject: ORDER BY problem
Hi
while testing an upgrade from 3.23.58 to 4.1.22 on an FC3 test box
SELECT * FROM Contacts WHERE Categories=Services
- Original Message -
Subject: RE: ORDER BY problem
Try your query with either back quotes around Company
SELECT * FROM Contacts WHERE Categories=Services and BusinessCodes
REGEXP
^R and gold_id=2 ORDER BY `Company` ASC
Or no quotes around Company
SELECT * FROM Contacts WHERE
Is it possible to do an insert into with subselect and group by with an
additional on duplicate insert ?
CREATE TABLE NEW_TABLE (
`a` varchar(10),
`b` double
) engine=MyISAM;
INSERT INTO NEW_TABLE (select old.x,sum(old.y) from OLD_TABLE old group by
old.a)
on duplicate key
update
I think that you need to select old.a otherwise you cannot group by it.
Arthur
On 7/9/08, Phil [EMAIL PROTECTED] wrote:
Is it possible to do an insert into with subselect and group by with an
additional on duplicate insert ?
CREATE TABLE NEW_TABLE (
`a` varchar(10),
`b` double
)
you should say group by old.x and not old.a
On 7/9/08, Arthur Fuller [EMAIL PROTECTED] wrote:
I think that you need to select old.a otherwise you cannot group by it.
Arthur
On 7/9/08, Phil [EMAIL PROTECTED] wrote:
Is it possible to do an insert into with subselect and group by with an
Sorry, that was just a typo,
should have been
INSERT INTO NEW_TABLE (select old.x,sum(old.y) from OLD_TABLE old group by
old.x)
on duplicate key
update b=sum(old.y);
but this gives
ERROR (HY000): Invalid use of group function
INSERT INTO NEW_TABLE (select old.x,sum(old.y) from
at the end of a batch file.
Has anyone else had this problem, and more especially, does anyone
know a useable workaround for it? I'm at my wits' end, and
downgrading to 5.0.51 isn't a viable option for my environment; this
isn't a production system and I'm using some 5.1-specific features
as of my
Hello,
Thanks for you help. You can see the results in the .err file below. I've
run it twice while the algorithm was running, but my knowledge in MySQL is
still too poor to identify any problem here. Beside these locks that I do
not know what they are.
This is the third release
to identify any problem here. Beside these locks that I do
not know what they are.
This is the third release of the algorithm. The first release used stacks.
In a tree with 10 levels and an average of 2 children per node, it used to
take about 2 minutes since everything was running sequentially. When
:
Re: Performance problem with more than 500 concurrent queries
Hi,
Could try your script with the key_buffer set to 0 ?
Regards,
Jocelyn Fournier
[EMAIL PROTECTED] a écrit :
Hello,
Thanks for you help. You can see the results in the .err file below.
I've
run it twice while the algorithm
,
but the second table is not involved in the problem. The father-children
table has around 10 rows.
What the code does is simple. It starts in the root and it navigates the
tree up to the leafs. The first thread takes the root and runs a select to
get all the children. Then it triggers new threads per
. The application is
reading one table that has two columns (Father, Children). As you might
suspect, this is a tree. The fields are foreign keys to a second table,
but the second table is not involved in the problem. The father-children
table has around 10 rows.
What the code does is simple. It starts
:30
Subject:
Re: Performance problem with more than 500 concurrent queries
do this
mysqladmin -uroot -p debug
and check the error.log, see if there are any locks on the tables.
On 6/26/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hello guys,
I am new to this list and also kind of new
Sorry about the long signature in the email. I forgot to remove it...
Guillermo
From:
[EMAIL PROTECTED]
To:
mysql@lists.mysql.com
Date:
26.06.2008 17:39
Subject:
Re: Performance problem with more than 500 concurrent queries
Hello,
thanks for the answer.
Where is the error.log stored? I
:39
Subject:
Re: Performance problem with more than 500 concurrent queries
Hello,
thanks for the answer.
Where is the error.log stored? I run the mysqladmin, it requires the
password and it exits immediately. But I cannot find any error.log.
Thanks,
Guillermo
---
Guillermo Acilu
At 10:39 AM 6/26/2008, you wrote:
Hello,
thanks for the answer.
Where is the error.log stored? I run the mysqladmin, it requires the
password and it exits immediately. But I cannot find any error.log.
Thanks,
Guillermo
Guillermo,
Look in the \MySQL\Data\*.err file.
Also I don't
this problem, and more especially, does anyone
know a useable workaround for it? I'm at my wits' end, and downgrading
to 5.0.51 isn't a viable option for my environment; this isn't a
production system and I'm using some 5.1-specific features as of my
upgrade.
-- Gwynne, Daughter of the Code
Hi,
Here is the simplest test case I could boil this down to. I'm running
this in 5.0.51a on RHEL4.
Preconditions:
- mysql.user only contains root user
- mysql.db is empty
- mysql.tables_priv is empty
- mysql.host is empty
I login as root, and run the following:
CREATE TABLE test.foo (
-
From: Gwynne Raskind [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2008 2:58 AM
To: mysql@lists.mysql.com
Subject: Problem with CREATE TABLE/DROP TABLE
I'm having the issue with CREATE TABLE described by Bug #30513
(http://bugs.mysql.com/bug.php?id=30513
). To summarize, a table which previously
501 - 600 of 8646 matches
Mail list logo