MYD files deleted

is problem and what version you're using, even if a solution hasn't been found. Thanks, Eric Mayers Software Engineer Captus Networks - Before posting, please check: http://www.mysql.com/manual.php (the manu

encode invalid characters for mysql in c++

I'm looking for a function that will take a string or char* of 256bit ascii (or other stuff) and convert it into something that can be inserted into a varchar type in mysql. Then when the data gets pulled out it would be converted back. I know I need to convert quotes and some control characters

RE: SubSelect Problem

nto a join, or break the operation into your application. Eric Mayers Software Engineer I Captus Networks > -Original Message- > From: Alex Speed [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 18, 2002 4:13 PM > To: [EMAIL PROTECTED] > Subject: SubSelect Problem >

myismchk messages (too small length)

-e -f /usr/local/var/ccdata/*/*.MYI Found block with too small length at 56452; Skipped Can someone tell me what this means? Why can't myisamchk can't fix this (is it a problem?)? How can I fix it? I'm trying to set it up to fix itself if possible. Thanks, Eric Mayers Software E

RE: Beginner needs help

Bob, This is just a guess, but looking at http://www.mysql.com/doc/I/n/Insert_speed.html it appears that the way to do multiple inserts looks like: INSERT INTO a VALUES (1,23),(2,34),(4,33); a(col1, col2).. Perhaps multiple inserts requires that you specify all columns in the order that the t

RE: InnoDB question

problem? If so you need to be much more specific about the problem you're encountering. So, to answer your question: You can already do this. Eric Mayers Software Engineer I Captus Networks > -Original Message- > From: Demirchyan Oganes-AOD098 [mailto:[EMAIL PROTECTED]] >

RE: max_data_length?

Okay, this is clearly not what I want. I'm looking for a method to see how much space a table is using compared to the total amount of space available. Is there a way to do this (with innodb tables)? Eric Mayers > -Original Message- > From: Keith C. Ivey [mailto:[EMAI

max_data_length?

Why is the max_data_length portion of "Show table status ..." for innodb tables null? Is there a way to get this value? I want to use this and data_length to display a % of space used statistic. Eric Mayers Software Engineer I Captus Networks

RE: off-line development tool?

on if you want it to be a more automatic process. Eric Mayers Software Engineer I Captus Networks > -Original Message- > From: Marco Bleeker [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 5:59 PM > To: [EMAIL PROTECTED] > Subject: off-line development tool? &

RE: Bugs and more Bugs.

rd when you're using mysql .. so.. /usr/local/mysql/bin/mysql --password=my_password < mysql_create.sql In general I suggest you take a look at mysqladmin --help | more and mysql --help | more Having the applications themselves answer your questions will be much faster than a mailing li

innodb table status : Why is Max_data_length NULL?

. I'd like to be able to pull the "max" out of the database somehow, which brings me to my question.. Why is "max_data_length" null? And is there a way I can get to this value? Is there a better/differ

RE: data type bigint(20)

John, The number in the parenthsis tells mysql how to format the column when it goes to display it.. Here is the relevant section of http://www.mysql.com/doc/N/u/Numeric_types.html: "Another extension is supported by MySQL for optionally specifying the display width of an integral value in par

select then delete everything selected

guarantee that the items deleted are the same ones that get displayed? Is there any way I can do this without including a unique identifier column and linking the delete statement into that? Thanks, Eric Mayers Software Engineer I Captus Networks ---

RE: Does delete from .. where (condition) use an index?

PROTECTED]] > Sent: Wednesday, February 13, 2002 5:59 PM > To: Eric Mayers; [EMAIL PROTECTED] > Subject: Re: Does delete from .. where (condition) use an index? > > > Eric, > > print what > > EXPLAIN SELECT * FROM Syslog USE INDEX(ds_index) WHERE ...

RE: Does delete from .. where (condition) use an index?

log WHERE datestamp < ... > > to see how it accesses the table. > > I have tuned the optimization in 3.23.48 so that it would favor index > searches more often. Please try also with 3.23.48. > > Regards, > > Heikki > Innobase Oy > > "Eric Mayers&

Does delete from .. where (condition) use an index?

log" in a previous query). .. and its taking a very long time.. watching the innodb monitor I'm seeing a large number of reads/s (29000) and a small number of deletes/s (10) which makes me believe its not using the index.. Any way to improve this? Eri

InnoDB, MySQL 3.23 inserts and deletes

how much space is left)? What is the relationship between deleting and inserting? It seems like there is a common semaphore or lock but I don't understand what the relationship is? Thanks, Eric Mayers Software Engineer --

Delete oldest data

.." -- this was added in MySQL 4.x .. Ideally I'd use "DELETE FROM table ORDER BY datestamp ASC LIMIT 1", but of course this doesn't work. How are people doing this in 3.23.xx? Thanks, Eric Mayers ---

RE: Clear table contents

Odhiambo, Give this a try, DELETE from relay_ip where UNIX_TIMESTAMP(rei_ts) < (UNIX_TIMESTAMP(NOW()) - (10 * 60)); Eric Mayers Software Engineer Captus Networks > -Original Message- > From: Odhiambo Washington [mailto:[EMAIL PROTECTED]] > Sent: Sunday, February 10, 2

Static or Dynamic rows -- which is faster?

I have a large data set (15 mil rows) consisting of a datetime column and a char(255) column. I seem to recall seeing something about performance benefits for using static length rows with MyISAM tables, and I've heard some argument for using dynamic length rows (e.g., use varchar rather than cha

RE: Checking the Table Size

Satish: You can see how much space is used (among other things) with a query like: show table status from like 'Syslog'; Increasing the maximum table size is a little more complicated and depends on what OS and table type you're using. Eric > -Original Message- > From: Satish Santhak

RE: Hello! Date question....

Jim,=20 What you're asking about is the "timestamp" data type. =20 Look at : http://www.mysql.com/doc/D/A/DATETIME.html In a nutshell, if you assign 'null' to a timestamp column it will put in value of 'NOW()'. Eric Mayers Software Engineer > -Orig

RE: Checking the Table Size

Satish: You can see how much space is used (among other things) with a query like: show table status from like 'Syslog'; Increasing the maximum table size is a little more complicated and depends on what OS and table type you're using. Eric > -Original Message- > From: Satish Santhak

RE: MySQL won't start...

Joe, When you start mysql (presumably with safe_mysqld), you must tell it where your datafiles are. Try bin/safe_mysqld --datadir=/var/lib/mysql/mysql Eric > -Original Message- > From: FISHER,JOE (Non-HP-Roseville,ex1) > [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 08, 2002 11

RE: Hello! Date question....

Jim, What you're asking about is the "timestamp" data type. Look at : http://www.mysql.com/doc/D/A/DATETIME.html In a nutshell, if you assign 'null' to a timestamp column it will put in value of 'NOW()'. Eric Mayers Software Engineer > -Orig

increasing InnoDB search performance

And long term question: I've noticed that a fulltext index feature doesn't appear on the InnoDB todo list. From my (limited) research, it looks like this is a feature a lot of people would find very useful. Is this a long term goal, or has it been excluded for some reason? Thanks Eric

Starting MySQL (w/ InnoDB) for the firs time

How can I tell when the database is ready to go (preferably from a shell script)? And an unrelated question, is there a guide to setting up a minimal MySQL installation? Thanks, Eric Mayers Software Engineer Captus Networks --

Overwrite oldest data?

ER BY date DESC LIMIT 1 be better once the table was at capacity? (would this work at all?) Thanks, Eric Mayers Software Engineer Captus Networks - Before posting, please check: http://www.mysql.com/manual.php (the manua

Details of table read locking?

In a query like: SELECT * from log_data where log_data.id = other_table.id; Will the database lock both the log_data and assets tables, or just the log_data table? More generally, are locks applied to any table related to the query, or just data being selected? Thanks, Eric Mayers

Inserts during a long select?

re out what the syntax is (or patch I need to apply) in order to do this. Any help in this area would be appreciated. Thanks, Eric Mayers database (spam filter got me the first time) - Before posting, please check:

Table size limitations: Error Handling and Raid 0

nlimited storage? [that one is just curiosity] Thanks, Eric Mayers Software Engineer Captus Networks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list arc

Combine data from multiple tables

I have three tables, each with a single column, "data". I'd like to form a query that will combine the table columns into a common result column. When I use the query: "SELECT * from tab1, tab2, tab3" I get: +-++---+ | data| data | data | +-

Best text query implementation?

r query of some kind would be ideal. I'm not able to use MySQL 4.0.1 FULLTEXT binary mode searches because I can't use alpha code at this point. Thanks, Eric Mayers Software Engineer Captus Networks - Before

RE: 2 GB limit reached

/InnoDB_overview.html for further detail. Eric Mayers -Original Message- From: Dennis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 3:31 PM To: [EMAIL PROTECTED] Subject: RE: 2 GB limit reached We have a database that seems to have grown too large, and now any operation fails

RE: duplicating collumn

You'll likely want to use INSERT INTO .. WHERE statement to populate a new third table based on the content of the two you've mentioned, joining on the ID. Look at http://www.mysql.com/doc/I/N/INSERT_SELECT.html for details on the syntax and usage. Eric Mayers -Original Message

Need to mask out data

parate table (or database) for each user, and when the data table is updated, each users table is updated as well, as appropriate. This seems like an awful solution, especially as the number of users grows. Any suggestions?