I try to detect using MC (Midnight Commander) and found that after
;/data4/ibdata25:1802M
it won't write anymore...
I remove these data file and add /ibdata1/ibdata10:1500M and /data1/ibdata11:1500M
I believe, All data below is empty but corrupt :(
data file defintion --
Since the recent thread with Innodb table space, I
have had a concern for a while.
First, I use Navicat to administer mysql. This
includes table creation.
I don't notice this using a myisam table but when I
set up an innodb I find this item:
InnoDB free: 10240 kB
Does this mean the actual
Hello can anyone help me with this,
i have a table, like the one below,
i need to find the time difference between the Start and Stop from a
particular CallingStationId to particular CalledStationId.
++--++---+--
In my web design I have a side bar to provide quick
info and links to account information.
Examples would be account basics:
Welome : Name, Company, Last Visit , ..
One idea that brings me to this question:
In the side bar I list out how many resumes member has
on file, so:
Title1 - Then
Hi,
This is the free space left in the InnoDB file. InnoDB will claim all the
space that it is configured for and if autoextend is turned on it will use
additional space when needed until the file limit is reached.
For example my current configuration is
innodb_data_file_path
Hi Y'All
Is it possible to have undeletable/unmodifiable records in a table of otherwise
modifiable
deleteable createable records?
At present I do it at the Update/Delete level where I have clauses which prevent
certain records
being changed. I suppose I could also have an extra boolean
Hi all,
Does MySQL support fetch-on-demand of resultsets?
And if so, does it support multiple cursors fetching on the same time
using the same connection?
If so, is it thread safe?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL
Server.
If it were all in one row, you may be able to compare datetime fields.
I do not know if you can do this with 2 rows, and the query will probably
be rough.
Did you design the table? Can you create it so that your row has start and
stop times, instead of creating another row?
-Original
Ady,
- Alkuperäinen viesti -
Lähettäjä: Ady Wicaksono [EMAIL PROTECTED]
Vastaanottaja: Ady Wicaksono [EMAIL PROTECTED]; Heikki Tuuri
[EMAIL PROTECTED]
Kopio: [EMAIL PROTECTED]
Lähetetty: Friday, September 03, 2004 10:41 AM
Aihe: Re: Problem on InnoDB - Tablespace enough but engine said
* Brian Menke
[...]
When I update one table on one machine, the other table of the
same name on the other machine also gets updated.
Sounds like replication... are you sure the machines are not set up as
master/slave?
--
Roger
--
MySQL General Mailing List
For list archives:
- Original Message -
From: Martijn Tonies [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, September 03, 2004 7:15 AM
Subject: Fetch-on-demand
Hi all,
Does MySQL support fetch-on-demand of resultsets?
And if so, does it support multiple cursors fetching on the same time
Hi,
Does MySQL support fetch-on-demand of resultsets?
And if so, does it support multiple cursors fetching on the same time
using the same connection?
If so, is it thread safe?
What do you mean fetch-on-demand? I've never heard this term before.
Since
every fetch takes place when
* Karma Dorji
i have a table, like the one below,
i need to find the time difference between the Start and Stop from a
particular CallingStationId to particular CalledStationId.
++--++---+
--
+---+
|
Hi,
The only way I can think of is to join the table to itself. It should look
something like this:
select unix_timestamp(concat(s.date,' ',s.time)) -
unix_timestamp(concat(e.date,' ',e.time))
from table s left join table e on
( s.CallingStationId=e.CallingStationId and
Hi Martijn,
Perl certainly allows you to have multiple statement handles going on a
single connection. I'm not sure on the C API as I tend to stay with
Perl, this is with the proviso that I understand your email correctly
8-)
Regards
David Logan
Database Administrator
HP Managed Services
139
Have you considered creating another table to store your array elements?
It would look something like
CREATE TABLE arrayFields (
origtable_PK int,
set_index int,
array_index int,
value int,
PRIMARY KEY (origtable_PK, set_index, array_index)
)
This is the
Mauricio,
040901 18:45:26 InnoDB: Assertion failure in thread 11272203 in file
row0upd.c line 713
InnoDB: Failing assertion: len == dfield_get_len(dfield)
It might this bug that was fixed in 4.1.2:
Fixed a bug: If you created a column prefix secondary index and updated it
so that the last
Hi,
I have a main query which can reads a record tbl_development
This has a varying number of the following fields
IDurl1
IDurl2
...
IDurln
The fields contain indexes into another table tbl_urldetails where each record
contains details
about each URL eg hyperlink, description
Currently I
I think that's a good question. If you are worried about load, you
obviously want to make the queries run as quick as possible and/or only
when needed. If you don't have a high load on your system, then it
really doesn't matter to much about the side queries since MySQL
probably isn't doing
I want to copy data from one table to another. However I need to do this
carefully because I haven't got much of space left. I was thinking of
maybe
selecting data from every 10 rows of the old table, inserting it into
the new table, then deleting those rows from the old table.
Could
You say you have a table that changes how many columns it has? Please post
the results of:
SHOW CREATE TABLE tbl_developent\G
SHOW CREATE TABLE tbl_urldetails\G
so I can see it too. :-D
Actually, it sounds like you have a normalization problem. Posting those
two table structures will give
Hello all,
We had a power outage this morning and before we could shut down our
main MySQL server, power to it was lost. Bad UPS battery. Long
story.
We replicate this server to two others. On one I get the following
error...
Jeff McKeon
IT Manager*** 1. row
Hi,
I have a table that looks like this:
table events:
id : INT
remoteid: INT
type : enum ('a','b','c')
value: INT
when: DATE
For each 'remoteid' and 'when', there are 3 rows with type=a,b,c
respectively. (Bad table design that is...) I would like to shorten this
table so it will look like this:
You will normally get better responses if you always CC the list in each
of your replies (unless you are intentionally going off-list).
Yes, it sounds like you are talking about a relationship to me, too. If
the we had your existing table structures in front of us we could help you
to
Hy Csongor,
You can write this in pure Mysql.
1. First you create a temporary table from your original table events with
group by remoteid and when;
2. Create your new table with the fields value_a, value_b and value_c;
3. Populate your new table from your temporary table with 0 in value_*
Hi,
Thank you Laercio.
Hy Csongor,
You can write this in pure Mysql.
1. First you create a temporary table from your original table events with
group by remoteid and when;
2. Create your new table with the fields value_a, value_b and value_c;
3. Populate your new table from your temporary table
I think you can do this in pure SQL. Here is my attempt:
CREATE TABLE newTable (
`id` INT
, `remoteid` INT
, `value_a` INT
, `value_b` INT
, `value_c` INT
, `when` DATE
)
SELECT
`id`
`remoteid`
, MAX(IF(`type`='a', `value`,
Hi there,
I have been using mysql 3.23.58, and I want to upgrade to 4.0.20. My question is
this: after I run the script to upgrade the grant tables to support the new
privilgeges, can I then revert back to 3.23.58 seamlessly or will I need to readjust
the grant tables. Thanks in advance.
I don't understand what do you mean by trim out the irrelevant? If
certain columns aren't important then why are they in your tables? I don't
need any data, only the structures. You do know that you don't need to
post to an actual NG to get your message to the list, right?. You only
need
Hopefully, this is ONLY about the administrator, not MySQL in general.
Our log file (the one with all the connects and queries) has reached about
1.3Gb in size (33272 pages). Whilst trying to view the last-but-one - or
indeed any except the last page of the log in Administrator - a sudden
David-
Think of A join consists of one circle of records per table
An INNER JOIN only gets the results that are in common between 2 tables or
all the rows
(where the circles intersect)
i.e.
In an Inner Join both columns of Both Tables MUST have Non Null identical
values and Must be =
An OUTER JOIN
I have some data that is stored by the year it is related to. So I have one
table that stores the Year the data is related to, among other things. At any
given time, 1 year is considered the 'active year', and the rest are
considered inactive.
The table is something like:
CREATE TABLE
Hi,
I don't mean to abuse, but could someone give me some help on how to
upgrade from 4.1.1 Alpha to 4.1.4 gamma
Any help gratly appreciated
Mauricio
On Thu, 2004-09-02 at 10:34, Heikki Tuuri wrote:
Mauricio,
please send the FULL .err log to me. Do not cut anything off.
[EMAIL
I've got a history table that performs a similar function. except in my
case I can have more than 1 active row. I put in an is_active column
and defined the type as a bool. an enum is actually a String in mysql,
which i didn't want to deal with. This table has only a few thousand
rows, so
On Fri, 3 Sep 2004 13:06:45 -0400, wrote:
I don't understand what do you mean by trim out the irrelevant? If
certain columns aren't important then why are they in your tables? I don't
need any data, only the structures. You do know that you don't need to
post to an actual NG to get your
After upgrade from 4.1.2 to 4.1.4 I can't start mysqld
error log:
040902 21:47:53 mysqld started
040902 21:47:53 [ERROR] Warning: Asked for 196608 thread stack, but got
126976
/usr/sbin/mysqld: Can't create/write to file '/root/tmp/ibezxsoi' (Errcode:
13)
040902 21:47:53 InnoDB: Error: unable
Igor Zinkovsky wrote:
After upgrade from 4.1.2 to 4.1.4 I can't start mysqld
error log:
040902 21:47:53 mysqld started
040902 21:47:53 [ERROR] Warning: Asked for 196608 thread stack, but got
126976
/usr/sbin/mysqld: Can't create/write to file '/root/tmp/ibezxsoi' (Errcode:
13)
mysql does not have
Let me see if I can summarize what I know so far:
A. Any record in tbl_development can be associated with up to 8 URLs that
represent virtual tours of the dwelling types in that particular
development.
B. tbl_urldetails is a table acting as a master list of the virtual
tours you have ready to
I would assume that you can since mysql probably does an internal
select col, col1 to get the grant information and the new tables
contain everything that the old ones do plus some extra privileges.
The only thing I would worry about would be passwords changing. Make a
small test case and let
I am not sure that this is the correct list. I did not
see any list that seemed more appropriate.
I have RedHat 8:
gcc-3.2-7
I run ./configure --prefix=/usr/local/mysql
which according to the log exited with code 0
Then when I run make I get the following errors. My
question is what is the
At 10:57 -0700 8/16/04, John Mistler wrote:
I have written an application for MAC OS X.3 that interfaces with MySQL
through the Client/Server approach. I would like to simplify the
installation process of the application by using the embedded MySQL server
instead. However, I am having trouble
Does anyone know mysql handles duplicate key handling during multi inserts?
INSERT INTO test values(1,2),(3,4),(4,5),(1,6),(6,7);
Now the above statement fails and gives duplicate key error and exits.
Is there a way for it to ignore the key violation and continue
processing the batch?
--
MySQL
Before I post it as a bug, perhaps someone can explain why
this query is not optimized to use the index (it has to examine all 287k rows).
mysql explain SELECT MAX(changed) FROM archived_stats where changed0;
At 17:03 -0700 9/3/04, Mir Islam wrote:
Does anyone know mysql handles duplicate key handling during multi inserts?
INSERT INTO test values(1,2),(3,4),(4,5),(1,6),(6,7);
Now the above statement fails and gives duplicate key error and exits.
Is there a way for it to ignore the key violation and
It would help if you would say how many entries do you have for changed =0
and how many are greater than 0.
Since changed is a timestamp you should never get an entry of 0. So the
query of changed0 will always do a full table scan. This is definitely not
a bug.
Donny
-Original
In the event that mysql has to scan the entire table it will ignore
the index because it's faster to read straight through the datafile
than it is to seek on the index.
-Eric
On Fri, 3 Sep 2004 19:39:38 -0500, Donny Simonton [EMAIL PROTECTED] wrote:
It would help if you would say how many
INSERT IGNORE INTO as Paul said will skip the duplicate values an
continue inserting, with a mutli row insert mysql will only skip the
duplicate values as the below example shows.
mysql create table t (t int not null, unique index (t));
Query OK, 0 rows affected (0.02 sec)
mysql desc t;
At 05:39 PM 9/3/2004, Donny Simonton wrote:
It would help if you would say how many entries do you have for changed =0
and how many are greater than 0.
Since changed is a timestamp you should never get an entry of 0. So the
query of changed0 will always do a full table scan. This is definitely
MySQL is using the index in both of those. The first query
where changed 7890; should be very fast since explain says it
only has to find one row. The second query, after mysql does a range
scan on the index has to still examine 11551351 rows to find a max
value.
The last query SELECT
In the last episode (Sep 03), Dave Dyer said:
At 05:39 PM 9/3/2004, Donny Simonton wrote:
It would help if you would say how many entries do you have for
changed =0 and how many are greater than 0.
Since changed is a timestamp you should never get an entry of 0. So
the query of changed0
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 3.0.15, a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
Version 3.0.15 is a bugfix release for the stable tree that is
suitable for use with any MySQL version including MySQL-4.1 or MySQL-5.0.
It
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 3.1.4, a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
Version 3.1.4 is the second (and last planned before GAMMA) BETA release
of the 3.1 series that is suitable for use with either MySQL-4.1 or
52 matches
Mail list logo