Re: Finding gaps

On 18 Sep 2008, at 07:45, Joerg Bruehe wrote: Stut schrieb: On 17 Sep 2008, at 22:12, Jerry Schwartz wrote: I have records that should be sequentially (not auto-increment) numbered, but there are gaps. Is there any elegant way of finding the gaps? Why do they need to be sequential? When

Re: Finding gaps

mbers to be in the database. -Stut -- http://stut.net/ -Original Message- From: Stut [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2008 5:17 PM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: Finding gaps On 17 Sep 2008, at 22:12, Jerry Schwartz wrote: I have re

Re: Finding gaps

asons. -Stut -- http://stut.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL crash on FreeBSD 7

ery thing without any issues. The server is running FreeBSD 7.0-RELEASE #0 amd64 with an unchanged kernel and mysql-server-5.0.45_1 installed from ports. If anyone has any idea what caused this or steps I should take to prevent it happening again I'd be eternally grateful. Thanks. -Stut

Re: Incorrect information in file: './maindb/users.frm'

Sorry, should've sent an update last night. That was indeed the problem. It's fixed now. Thanks to everyone who helped. -Stut -- http://stut.net/ On 5 Jun 2008, at 09:04, Ben Clewett wrote: It could be the size of your InnoDB log files. Or something else which stops InnoDB ru

Re: Incorrect information in file: './maindb/users.frm'

aits | 0 | | Innodb_rows_deleted | 0 | | Innodb_rows_inserted | 0 | | Innodb_rows_read | 0 | | Innodb_rows_updated | 0 | +---++ 44 rows in set (0.00 sec) Anyone have any ideas? T

Re: Incorrect information in file: './maindb/users.frm'

On 4 Jun 2008, at 23:10, Stut wrote: HELP!! Our database just died. SHOW TABLE STATUS shows the message in the status line for every table except the one that's MyISAM - the rest are InnoDB. Is there any way to rebuild the .frm files for the InnoDB tables? Can anyone help? I k

Incorrect information in file: './maindb/users.frm'

HELP!! Our database just died. SHOW TABLE STATUS shows the message in the status line for every table except the one that's MyISAM - the rest are InnoDB. Is there any way to rebuild the .frm files for the InnoDB tables? -Stut -- http://stut.net/ -- MySQL General Mailing List For

Re: Show indexing status

inuously. Load is hovering just over 2 (2 CPUs in there). Config file is probably a little different - we didn't have a copy of it before the DB HDD's went belly up. Stut wrote: Hi, I just finished restoring a 22gig SQL dump but the server is not performing anywhere near where

Show indexing status

s got? Thanks. -Stut -- http://stut.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: PHP Question

sult) { $message = 'Invalid update: ' . mysql_error() . "\n"; $message .= 'Whole query: ' . $result; die($message); mysql_close($link); ?> 1) What are you trying to do with "use election"?? 2) Missing } - opened for the last if. -Stut -

Re: MySql at 100% CPU

15 0 1662m 1.5g 4956 S 99.9 19.3 116418:22 mysqld Any help would be appreciated. -Stut -- http://stut.net/ | back_log| 50 | basedir | /usr/ | bdb_cache_size | 8388600

Re: Incrementing a "Private" Integer Space

David T. Ashley wrote: On 11/25/07, Stut <[EMAIL PROTECTED]> wrote: David T. Ashley wrote: I have a table with two integer fields (call them p and q). When I insert a record with a known p, I want to choose q to be one larger than the largest q with that p. What is the best an

Re: Incrementing a "Private" Integer Space

into test1 set p = 2, q = (select max(q) + 1 from test1 as tmp where p = 2) Probably not very efficient, but it works. -Stut -- http://stut.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Index help

Hi Rob, Thanks for your reply. Rob Wultsch wrote: On Nov 8, 2007 4:08 PM, Stut <[EMAIL PROTECTED]> wrote: Hi all, I've inherited a PHP app that uses a MySQL database. The following query is extremely slow and I've been battling for a couple of days on an off to try and get

Index help

dge of MySQL indexes led me to add an index with ad_catid, ad_status, ad_renewed and id, but explain only says it's a possible key, it doesn't actually use it. Any tips appreciated. -Stut -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Re: Query not returning Data

n on board_action_date in the query but this is a very bad idea and will lead to extremely slow queries. Your best option is to either alter board_action_date to a date field, or add a new field for it. -Stut [1]http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_str-to-d

Re: Removed ibdata1

sn't exist this erro in all tables type innodb # ls -la /var/lib/mysql/intranet/ list all files .frm OK I'm no expert, but I believe the data in InnoDB tables is stored in ibdata1. Game over I'm afraid. -Stut -- http://stut.net/ -- MySQL General Mailing List For list archive

Lots of queries doing "statistics"

ysqld.log pid-file=/var/run/mysqld/mysqld.pid Thanks. -Stut -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]