m/order.php
----- Original Message -
From: ""Jon Wagoner"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, April 07, 2005 7:31 PM
Subject: Out of memory, but plenty of swap space left
> Recently I've been getting error 1041 at times,
SELECT product_lines.* FROM product_lines LEFT JOIN
manufacturer_product_line_index ON
manufacturer_product_line_index.product_line_id = product_lines.id WHERE
product_lines.id IS NULL
-Original Message-
From: Ed Lazor [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 07, 2005 11:39 AM
To:
Recently I've been getting error 1041 at times, which gives the message
to update the ulimit or add swap space.
This is a dedicated MySQL server, so I have no ulimit set for MySQL.
According to /proc/meminfo I have over 1GB of swap free.
Mem: 2118533120 2067628032 509050880 19677184 165
Assuming he is using the mysql init script from Gentoo, he just needs to run
/sbin/depscan.sh
-Original Message-
From: Bob Lockie [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 25, 2003 2:50 PM
To: MySQL Mailing List
Subject: start warning
I am posting this on behalf of a Gentoo user
I have gotten several of these errors over the last couple of months. This
has happened on two different servers. (Both are running MySQL 4.0.16 on
Red Hat 7.3)
It mainly happens in one particular table, but has happened in another one.
I have tried dropping and recreating the table, but that do
I will switch to the secondary server tonight and see if the problems clear
up. Thanks for the response.
-Original Message-
From: John Griffin [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 1:49 PM
To: Jon Wagoner; [EMAIL PROTECTED]
Subject: RE: periodic corruption problem
I
10, 2003 12:04 PM
To: Jon Wagoner
Cc: [EMAIL PROTECTED]
Subject: Re: periodic corruption problem
my experience with corrupted tables is usually followed by a failed
harddrive
aka the disk may be diing ...
--
Quoting Jon Wagoner <[EMAIL PROTECTED]>:
> I am running MySQL 4.0.16 on
I am running MySQL 4.0.16 on a Red Hat 7.3 server. I am having problems
with tables periodically getting corrupted. The one it happens most often
on is a table I use for logging various status messages. This table
receives mostly inserts, and very few selects. It is about 400MB in size,
with ab
ailto:[EMAIL PROTECTED]
Sent: Monday, November 03, 2003 2:04 PM
To: Jon Wagoner
Cc: [EMAIL PROTECTED]
Subject: Re: table gets corrupted often
Could it be getting larger than 2G on a filesystem with a 2G/file limit?
Jon Wagoner wrote:
>I have a table that tends to get corrupted and needs to be
I have a table that tends to get corrupted and needs to be repaired every
few days. It is used for logging various messages in my web app. The
structure is:
CREATE TABLE log (
log_id int(11) unsigned NOT NULL auto_increment,
log_type tinyint(1) unsigned NOT NULL default '0',
when datetime
Select * from Tablename where drinks != 'pepsi';
Got any milk with that cookie?
-Original Message-
From: Andrew Wilson [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 20, 2003 6:49 PM
To: '[EMAIL PROTECTED]'
Subject: "where drink is not equal to pepsi
Hi guys,
Hopefully have an easy q
h_year,
id
FROM wsh
-Original Message-
From: Richard Forgo [mailto:[EMAIL PROTECTED]
Sent: Monday, February 24, 2003 3:44 PM
To: Jon Wagoner; 'MySQL Mailing List'
Subject: RE: case expression
Thanks, that works fine. If I wanted to create an alias for the column,
how woul
Put the other fields after the CASE statement:
SELECT
CASE
WHEN CHARACTER_LENGTH(system) > 65
THEN
CONCAT(LEFT(system, 60), " ...")
ELSE
system
END,
wsh_year,
id
FROM wsh
The CASE statement just returns 1 field.
-Original Message-
From: Richard For
I have a couple of questions here. This table currently contains about 12 million
records. This table is mostly read from, but several times thoughout the day there
will be inserts or updates of batches of about 30,000 rows, and there are periodic
purges of old rows, which could be up to sever
Change the query to:
SELECT parcels.DXF as 'record',
building.ADDRESS as 'results1', parcels.relname as
'results2' from parcels INNER JOIN building
on parcels.DXF = building.DXF where
parcels.relname LIKE '%jones%' order by
parcels.relname desc;
For tables in the from list, the next word after a
15 matches
Mail list logo