RE: Out of memory, but plenty of swap space left

2005-04-08 Thread Jon Wagoner
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,

RE: Query question

2005-04-07 Thread Jon Wagoner
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:

Out of memory, but plenty of swap space left

2005-04-07 Thread Jon Wagoner
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

RE: start warning

2003-11-25 Thread Jon Wagoner
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

Wrong bytesec: 0-0-0 at linkstart: 292251752

2003-11-19 Thread Jon Wagoner
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

RE: periodic corruption problem

2003-11-10 Thread Jon Wagoner
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

RE: periodic corruption problem

2003-11-10 Thread Jon Wagoner
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

periodic corruption problem

2003-11-10 Thread Jon Wagoner
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

RE: table gets corrupted often

2003-11-03 Thread Jon Wagoner
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

table gets corrupted often

2003-11-03 Thread Jon Wagoner
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

RE: "where drink is not equal to pepsi

2003-03-20 Thread Jon Wagoner
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

RE: case expression

2003-02-24 Thread Jon Wagoner
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

RE: case expression

2003-02-24 Thread Jon Wagoner
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

optimizing large InnoDB table

2003-02-24 Thread Jon Wagoner
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

RE: Unknown table in field list

2003-02-24 Thread Jon Wagoner
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