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
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
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
>
-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
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
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]]
>
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
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
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?
&
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
. 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
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
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
---
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 ...
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&
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
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
--
.."
-- 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
---
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
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
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
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
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
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
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
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
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
--
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
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
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:
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
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 |
+-
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
/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
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
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?
36 matches
Mail list logo