MYD files deleted

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 manual) http://lists.mysql.com

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

RE: SubSelect Problem

, 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 SELECT textid, title, description from

myismchk messages (too small length)

message.. bash-2.04# ./myisamchk -o -s -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

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 sql,query

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:[EMAIL PROTECTED]] Sent

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]] Sent: Monday

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

RE: Bugs and more Bugs.

.. 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 list. =) Eric Mayers Software

RE: off-line development tool?

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? Hello, I am a beginning

innodb table status : Why is Max_data_length NULL?

, 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/different way to do this? Thanks, Eric Mayers Software Engineer I Captus Networks query. - Before

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

: Eric Mayers [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, February 14, 2002 3:44 AM Subject: RE: Does delete from .. where (condition) use an index? Heikki, mysql EXPLAIN SELECT * FROM Syslog WHERE datestamp = 2002021310712

select then delete everything selected

this without including a unique identifier column and linking the delete statement into that? Thanks, Eric Mayers Software Engineer I Captus Networks - Before posting, please check: http://www.mysql.com/manual.php

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

Delete oldest data

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 - Before posting, please check: http

InnoDB, MySQL 3.23 inserts and deletes

semaphore or lock but I don't understand what the relationship is? Thanks, Eric Mayers Software Engineer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

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

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 wrote in message ... I haven't been able to find details about how/if MySQL (InnoDB) optimizes deletes. Does it use indexes? Can I force

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 -Original Message- From: Jim Hatridge

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 database 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

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

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, 2002 11:22 PM

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 -Original Message- From: Jim Hatridge [mailto

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:01

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 database 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

increasing InnoDB search performance

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 Mayers Software Engineer

Starting MySQL (w/ InnoDB) for the firs time

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 - Before

Overwrite oldest data?

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 manual) http

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?

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: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Table size limitations: Error Handling and Raid 0

, Eric Mayers Software Engineer Captus Networks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL

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?

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 posting, please check: http

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- From

Need to mask out data

) 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? Eric Mayers [EMAIL PROTECTED