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 stopped
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 Backu
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 co
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 specif
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 brain
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 wa
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, an
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 ca
"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
Kittiphum Worachat <[EMAIL PROTECTED]> wrote:
> Victoria Reznichenko wrote:
>>Starts fine for me from command line:
>>
>>C:\mysql\bin>mysqld-nt.exe --default-character-set=tis620 --standalone --console
>>040122 14:36:50 InnoDB: Started; log sequence number 0 43634
>>mysqld-nt.exe: ready for connec
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 m
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.
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 Linu
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 `read
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` int(
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 linu
* [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 NUL
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 s
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 jus
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 A
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, Wisco
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_increme
* [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 o
* 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'v
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
