My machine appears to be swapping excessively, degrading performance.
Note the high load average, combined with the mostly idle CPU and a
lot of swap space being used.
3:11am up 47 days, 2:13, 12 users, load average: 6.06, 4.79, 3.19
482 processes: 480 sleeping, 1 running, 1 zombie, 0
Matthew,
sorry, InnoDB does not support deferred constraint checking. It is in the
long-term TODO.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
Jeremiah,
if you are using a fairly recent version of MySQL, you can print with
SHOW INNODB STATUS\G
a detailed explanation of the latest foreign key error.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot
Here's a fun one to tickle your brains:
I've got a table holding the results of a bandwidth tester thingie. Its
columns hold the date and time the test was run, the fully-qualified machine
name of the computer that took it, its IP address, and the speed in
kilobits/sec. What I'd like to do is
Hi,
How do I execute the following UPDATE statements such that I can ensure
that all integrity constraints are maintained upon the completion of the
last one?
UPDATE test_parent SET id = 6 WHERE id = 1;
UPDATE test_child SET parent_id = 6 WHERE parent_id = 1;
And would specifying
try
SELECT domain,AVG(speed) FROM your_table GROUP BY domain
where domain and speed are columns of table your_table
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, January 24, 2004 10:59 AM
Subject: A fun one
Here's a fun one to tickle your brains:
On 22-Jan-2004 Michael McTernan wrote:
Hi there,
Thanks for your quick response!
Why all the locks, temp tables and updates? You can just do:
SELECT
CASE WHEN B.y IS NULL THEN A.x ELSE B.y END AS newX
FROM
A LEFT JOIN B ON A.x = B.x
Spot on - many thanks! I wasn't aware of the
On 24-Jan-2004 [EMAIL PROTECTED] wrote:
Here's a fun one to tickle your brains:
I've got a table holding the results of a bandwidth tester thingie.
Its
columns hold the date and time the test was run, the fully-qualified
machine
name of the computer that took it, its IP address, and the
Benjamin,
When MySQL does a join, it appears that it considers one table as the
primary
table and one table as the dependent table. It then selects rows from the
primary table and then, for each selected row, it fetches the corresponding
rows from the dependent table.
For an inner join, MySQL
Andrew Kuebler [EMAIL PROTECTED] wrote on 23/01/2004 17:13:13:
Can anyone explain why:
SELECT ROUND(.012345, 5)
- .01234
Why doesn't mysql round the 5 up to .01235? How do I get it to round up?
I've tried manipulating ceil, floor, round and truncate and I can't seam
to find an easy
Kittiphum Worachat [EMAIL PROTECTED] wrote:
Victoria Reznichenko wrote:
Starts fine for me from command line:
C:\mysql\binmysqld-nt.exe --default-character-set=tis620 --standalone --console
040122 14:36:50 InnoDB: Started; log sequence number 0 43634
mysqld-nt.exe: ready for connections.
in a select statement, is the order of elements in the where clause the
determining factor on what records are chosen first, second etc?
for instance...
select fname from maintable where status=1 and dob '2001-03-10';
does that mean that the records will first be checked for status creating a
I had to reload mysql 4.0.17 on to a Fedora Core machine that was previously
working in the same configuration. Now though I can't get the server to run
with the either of the following commands:
./mysql.server start - the command line reappears with no error but no
running process in the system
Which of these three joins are using temporary table?
# 1 Inner Join
# 2 Left Join
#3 Outer Join
Thanks
On Saturday 24 January 2004 02.07, DePhillips, Michael P wrote:
Thanks for the reply.
I agree with your first solution but I feel this is very limiting. I would
like be able to connect with a dns name with assurance that it will
succeed. I think this is a reasonable feature to request. I
In the last episode (Jan 24), Philip Mak said:
My machine appears to be swapping excessively, degrading performance.
Note the high load average, combined with the mostly idle CPU and a
lot of swap space being used.
You didn't say what OS you're using, but the below top output looks
like
Almost. I'm sure that'll be needed in there someplace.
here's what I've got:
CREATE TABLE `readings` (
`date` timestamp(14) NOT NULL,
`speed` float NOT NULL default '0',
`ip` text NOT NULL,
`name` text NOT NULL
) TYPE=MyISAM;
#
# Dumping data for table `readings`
#
INSERT INTO
Hi!
I want to get amount of disk space used by certain rows on disk, not a whole
table, but only some rows. Is this possible?
For example I got a table like:
CREATE TABLE `categories` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`parent_category_id`
Hello:
I have been trying to configure websphere 5 to use
mysql.
I have set up the datasource using the mysql driver
and whenever I test the connection from the websphere
admin console, I get the following:
Test Connection failed for datasource Securance
Datasource on server server1 at node
* [EMAIL PROTECTED]
* Don Read
See SUBSTRING_INDEX()
Almost. I'm sure that'll be needed in there someplace.
here's what I've got:
CREATE TABLE `readings` (
`date` timestamp(14) NOT NULL,
`speed` float NOT NULL default '0',
`ip` text NOT NULL,
`name` text NOT NULL
)
At 8:34 -0500 1/24/04, Larry Brown wrote:
in a select statement, is the order of elements in the where clause the
determining factor on what records are chosen first, second etc?
No. The optimizer examines the query to determine the most efficient
way to execute the query. You can get information
Hey Roger,
- Original Message -
From: Roger Baklund
Sent: Saturday, January 24, 2004 7:09 PM
Subject: Re: A fun one
You shouldn't use text columns for ip/name... ip addresses fits in an
unsigned int
Yeah, I want to use an INT UNSIGNED column for IPs, which is great for
the space
yes, I want output in the form I noted; the averages I typed were numbers
pulled from thin air. There will eventually be many records for many
machines, and what I'm looking to output is one line for each domain name
with the average speed for all machines on that domain. The data I listed
is
At 23:02 + 1/20/04, Mike Mapsnac wrote:
I know that. I'm lookign for mysql function that will increment the value.
Tobias gave you the correct answer. His answer achieves the objective you
stated in your original message.
Any particular reason you don't want to do what he says?
From: Tobias
At 10:33 -0500 1/24/04, Mike Mapsnac wrote:
Which of these three joins are using temporary table?
# 1 Inner Join
# 2 Left Join
#3 Outer Join
I don't understand what you're asking here. Can you be more specific
about what you want to know?
--
Paul DuBois, MySQL Documentation Team
Madison,
At 14:20 +0100 1/22/04, Frederic Wenzel wrote:
Mike Mapsnac wrote:
What is the difference between Left Join and Left Outer Join?
Thanks
If I get it right, there is none.
Greetings
Fred
You got it right. There is none.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB,
* Juan Nin
I want to get amount of disk space used by certain rows on disk,
not a whole table, but only some rows. Is this possible?
How accurate does it have to be? On the byte? On the K?
For example I got a table like:
CREATE TABLE `categories` (
`id` int(11) NOT NULL auto_increment,
* [EMAIL PROTECTED]
[...]
The fun part to which I refer is (what I perceive to be) the crux of the
problem: figuring out all (for example) adelphia.com records,
finding their average speed, and spitting out that one line.
Isn't that what my example queries are doing?
What I was thinking of
* Matt W
* me
You shouldn't use text columns for ip/name... ip addresses fits in an
unsigned int
Yeah, I want to use an INT UNSIGNED column for IPs, which is great for
the space savings... except people have brought up the issue of IPv6
addresses (128-bit; 32 hex chars IIRC). I've never
ntvdm.exe - application program error
0x0f00fa31 is reference to 0x000de002 's memory.
memory is not readed.
what is this?
? PC .
http://messenger.freechal.com/FcVaccine/FcVacMain.asp
30 matches
Mail list logo