Hi,
I am Using MySQL for GIS Data.I have to getting response time of each
threads for retrival data by a JDBC Program with connection Polling .
Here Initail Connection was 15.
Maximum Connection was 50.
My problem is that on 200 threads there response time is increasing
abnormally ?. While
- Original Message -
From: mos [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Monday, February 18, 2008 6:48 PM
Subject: Re: Best way to combine MYISAM to MERGE tables ...
At 11:33 AM 2/18/2008, you wrote:
Hi All,
I am working with MYISAM tables split by year, like:
data2003,
Hi!
SQL Maestro Group announces the release of AnySQL Maestro - a freeware, but
powerful tool for all the database engines accessible via ODBC driver or OLE
DB provider (Access, SQL Server, Firebird, Oracle, MySQL, PostgreSQL,
SQLite, etc).
http://www.sqlmaestro.com/products/anysql/maestro/
At 01:55 PM 2/19/2008, Mário Gamito wrote:
Hi,
Is it possible to call from within MySQL an external PHP script ?
I've read MySQL Stored Procedure Programming from O'Reilly but found
nothing :(
How can I do this ?
Any help would be appreciated.
Warm Regards,
Mário Gamito
Mário,
Looks like you're missing a comma after comm_id, before
the @num := line?
andy
Santosh Killedar wrote:
I am trying the following code on 4.1.2 and getting a
syntax error that I could not figure out. It works
fine on 5.x. Any suggestion/alternate
CREATE TEMPORARY TABLE Temp
(Node INT,
comm_id
Hello,
This time I'm rearly not sure if this is possible to do. I've got two
queries that I would like to bring together to make only one query ...
I've got a list of users
And also a login table
I would like to list all users and show the number of times they have
logged in.
So to get
Richard,
Can I do something like this :
SELECT a.username, a.first_name, a.last_name,b.(SELECT COUNT(*) AS count
FROM login_table b WHERE a.username = b.username) FROM user_list a
Try ...
SELECT a.username, a.first_name, a.last_name,COUNT(b.username) AS count
FROM user_list a
JOIN login_table
Hi Pierre -
You're correct, mysqlhotcopy will no longer work when you switch to InnoDB.
One option you could pursue is using mysqldump instead, which will write out
full SQL files needed to restore your databases. It will write these to a
filesystem.
It is generally slower than mysqlhotcopy to
I'm trying to change the definition of a field and getting 1025 errors
when I try. Here's a simplified reproducible test case, on MySQL 5.
CREATE TABLE `Users` (
`UserId` int(11) NOT NULL,
PRIMARY KEY (`UserId`)
) ENGINE=InnoDB;
CREATE TABLE `Actions` (
`ActionId` int(11) NOT NULL
Hi, and thankyou for trying to help me out! I've tried this and it does
not work. Here are the problems :
1) If a user has never logged in he doesn't show the user in the list
2) It doesn't count if it is 0 it's not on the liste and if the user
has logged in more than once the result is 1
I am new to MySQL, and wonder if I have done something terribly stupid. I
have an InnoDB table with 27 million rows. Without thinking very much, I
issued the following command through the GUI administration tool:
ALTER TABLE `wyky`.`externallinks` ADD COLUMN `el_p2` BLOB NOT NULL AFTER
Sorry it's me again, I made a mistake, it counts the number of logins
correctly, but does not show members with 0 logins !
Any idea how to do this?
Thanks :)
Peter Brawley a écrit :
Richard,
Can I do something like this :
SELECT a.username, a.first_name, a.last_name,b.(SELECT COUNT(*) AS
Try
SELECT a.username, a.first_name, a.last_name, SUM(case when b.username is
null then 0 else 1 end) as count
FROM user_list a
LEFT OUTER JOIN login_table b ON a.username = b.username
GROUP BY a.username,a.first_name,a.lastname;
Donna
Richard [EMAIL PROTECTED]
02/19/2008 05:29 PM
To
Actually, this works too:
SELECT a.username, a.first_name, a.last_name, Count(b.username) as count
FROM user_list a
LEFT OUTER JOIN login_table b ON a.username = b.username
GROUP BY a.username,a.first_name,a.lastname;
__
Try
SELECT a.username, a.first_name, a.last_name,
Try this one:
SELECT a.username, a.first_name,
a.last_name,COALESCE(COUNT(b.username), 0) AS count
FROM user_list a
LEFT JOIN login_table b ON a.username = b.username
GROUP BY a.username,a.first_name,a.lastname;
The LEFT JOIN will ensure you still get a result row even if there are
no
We need to replicate a table to a third part. The information in the table is
pretty much public, with the exception of one column. Is it possible to
replicate all of the tables with the exception of one column?
What I was thinking was to replication it to a 2nd machine that will limit it
Richard,
1) If a user has never logged in he doesn't show the user in the list
2) It doesn't count if it is 0 it's not on the liste and if the user
has logged
in more than once the result is 1 (because of the group by ...).
Do you mean by #1 that you want to list all users whether they have
Hi,
On Feb 19, 2008 2:55 PM, Mário Gamito [EMAIL PROTECTED] wrote:
Hi,
Is it possible to call from within MySQL an external PHP script ?
I've read MySQL Stored Procedure Programming from O'Reilly but found
nothing :(
How can I do this ?
You may be interested in this:
Hi Wayne,
On Feb 19, 2008 4:52 PM, Waynn Lue [EMAIL PROTECTED] wrote:
I'm trying to change the definition of a field and getting 1025 errors
when I try. Here's a simplified reproducible test case, on MySQL 5.
CREATE TABLE `Users` (
`UserId` int(11) NOT NULL,
PRIMARY KEY (`UserId`)
)
Hi,
On Feb 19, 2008 5:20 PM, Mike Spreitzer [EMAIL PROTECTED] wrote:
I am new to MySQL, and wonder if I have done something terribly stupid. I
have an InnoDB table with 27 million rows. Without thinking very much, I
issued the following command through the GUI administration tool:
ALTER
Hi,
On Feb 19, 2008 7:17 PM, Gary W. Smith [EMAIL PROTECTED] wrote:
We need to replicate a table to a third part. The information in the table
is pretty much public, with the exception of one column. Is it possible to
replicate all of the tables with the exception of one column?
What I
Thanks, Baron. Yes, the table is bigger than memory. It took about 2.5
days to create the table, inserting about 7,000 rows at a time; this
column and index addition has been running for about a day now. I notice
you did not say it was terribly stupid to create this index before putting
the
And that is a hack at best, but it does give me some ideas. I really only need
two fields out of that table anyhow so I might actually migrate the columns
that I care about into a new table and update the corresponding SQL statements
that I use to update them (i.e. split the source data).
Hm, ok. Then one more followup question, if dropping the FKs is
necessary, is there any way to figure out how long such an operation
will take? SHOW PROCESSLIST usually just has copying to tmp table
or some such, does SHOW INNODB STATUS or any other commands give
insight into how long it will
24 matches
Mail list logo
