I just managed to get two identical test-servers running, both being
slaves of my production system replicating a few databases including two
of the heavy-use tables.
One server uses heap-tables, on the other one i changed the table-format
to innodb.
I've had some problems wit
ff" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.myodbc
> Sent: Tuesday, January 31, 2006 1:09 PM
> Subject: Re: Performance of MEMORY/HEAP-tables compared to mysql-cluster?
>
>
> > Hi,
> >
> > I am currently experiencing trouble getting my new mysql
also backs up MyISAM
tables
http://www.innodb.com/order.php
- Original Message -
From: "Jan Kirchhoff" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, January 31, 2006 1:09 PM
Subject: Re: Performance of MEMORY/HEAP-tables compared to mysql-cluster?
Hi,
I am currently experiencing trouble getting my new mysql 5-servers
running as slaves on my old 4.1.13-master.
Looks like I'll have to dump the whole 30GB-database and import it on
the new servers :( At this moment I
do no see any oppurtunity to do this before the weekend since the
longest
sheeri kritzer schrieb:
No problem:
Firstly, how are you measuring your updates on a single table? I took
a few binary logs, grepped out for things that changed the table,
counting the lines (using wc) and then dividing by the # of seconds
the binary logs covered. The average for one table was
No problem:
Firstly, how are you measuring your updates on a single table? I took
a few binary logs, grepped out for things that changed the table,
counting the lines (using wc) and then dividing by the # of seconds
the binary logs covered. The average for one table was 108 updates
per second.
Kirchhoff
Cc: mysql@lists.mysql.com
Subject: Re: Performance of MEMORY/HEAP-tables compared to mysql-cluster?
Why are you using a heap table?
My company has tables with much more information than that, that get updated
much more frequently. We use InnoDB tables, with very large buffer sizes
and
sheeri kritzer schrieb:
Why are you using a heap table?
We started out with a myisam-table years ago when the table was much
smaller und less frequently updated. We tried innodb about 2 or 3 years
ago and couldn't get a satisfying result. We then changed it to HEAP and
everything was fine.
cally we've set it up
so everything is in memory anyway.
Perhaps a similar setup would help for you?
Sincerely,
Sheeri Kritzer
On 1/27/06, Jan Kirchhoff <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Did anybody ever benchmark heap-tables against a cluster?
> I have a table with 900.000
may be a good option, but you can also use
replication and have multiple slaves and distribute the load, if you
have the resources to do that ..
Kishore Jalleda
On 1/27/06, Jan Kirchhoff <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Did anybody ever benchmark heap-tables against a clus
Hi,
Did anybody ever benchmark heap-tables against a cluster?
I have a table with 900.000 rows (40 fields, CHARs, INTs and DOUBLEs,
Avg_row_length=294) that gets around 600 updates/sec (grouped in about 12
extended inserts a minute inserting/updating 3000 rows each).
This is currently a HEAP
icht-
Von: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 7. Juli 2005 10:35
An: mysql@lists.mysql.com
Betreff: Re: Locks on Heap tables
Hello.
Are you sure that your server doesn't swap? Providing output
of 'SHOW STATUS', 'SHOW VARIABLES' and your table definiti
session management. We are using a heap for that =
> case
> as well as for instance phpbb does.=20
> Lately we are experiencing long lasting table locks due to deletes or
> updates on the session table. I know that heap tables only support table
> wide locking, but shouldn&#x
experiencing long lasting table locks due to deletes or
updates on the session table. I know that heap tables only support table
wide locking, but shouldn't those locks be gone quite fast? I have already
checked the obvious reasons for this kind of behaviour like swapping but I
couldn't find anyt
ay next week, but I guess I'll just give all options a try on our
development-system afterwards. I guess if something works with 2GB of
RAM, it should also work with 6GB (Opteron). Or is mysql's behaviour
changing with very big heap-tables or key_buffers?
Jan
--
MySQL General M
Hi,
A few questions for you.
On Friday, August 6, 2004, at 06:17 AM, Jan Kirchhoff wrote:
I was just wondering if anybody has been using very large HEAP-tables
and if there are ways to have mysql use the memory more efficient:
(I have no experience with all heap-tables but using them as
Philippe Poelvoorde wrote:
Hi,
I changed a few columns, bidsize and asksize are integer now, and i
changed ticknumber to smallint unsigned.
At first I used the ticknumbers by the feedserver, now I count up to
65,000 and then reset the counter back to 0. I need that additional
column to handle mu
Hi,
I changed a few columns, bidsize and asksize are integer now, and i
changed ticknumber to smallint unsigned.
At first I used the ticknumbers by the feedserver, now I count up to
65,000 and then reset the counter back to 0. I need that additional
column to handle multiple ticks within one sec
Philippe Poelvoorde wrote:
Maybe you should try to normalize your table,
'symbol' could have its own table, that would reduce data and index.
And then try to reduce the size of your rows, bidsize and asksize
should be in integer I think. Maybe 'float' would be enough.
What represents the 'quelle'
Maybe you should try to normalize your table,
'symbol' could have its own table, that would reduce data and index.
And then try to reduce the size of your rows, bidsize and asksize should
be in integer I think. Maybe 'float' would be enough.
What represents the 'quelle' column ?
Is kurszeit necess
I was just wondering if anybody has been using very large HEAP-tables
and if there are ways to have mysql use the memory more efficient:
(I have no experience with all heap-tables but using them as temporary
tables...)
I just started testing with 2 heap-tables on a development-system (p4
Mark Maunder wrote:
The table I'm using is non-critical data, so it's not really an issue
for me. But I was browsing through the mysql manual looking for a way to
rebuild an MYI file from the .frm and MYD file (is there a way?) when I
came across this:
There is:
REPAIR TABLE t1 USE_FRM
--
Sasha P
Hi Mark,
- Original Message -
From: "Mark Maunder"
Sent: Monday, February 23, 2004 4:17 PM
Subject: Re: HEAP tables vs MYISAM on ramdisk
> 411 is packed with features I'm dying to have on my production server,
> but I had it on my dev box, and I got some t
, Eric B. wrote:
> > > How are you ensuring syncronization between the ram disk and the HD? Is
> > > there a writeback / writethrough mechanism for ram disks? Are you not
> > > risking major data loss if ever you have a power failure or PC failure?
> > >
>
writethrough mechanism for ram disks? Are you not
> > risking major data loss if ever you have a power failure or PC failure?
> >
> > Thanks for the info!
> >
> > Eric
> >
> > "Mark Maunder" <[EMAIL PROTECTED]> wrote in message
echanism for ram disks? Are you not
> risking major data loss if ever you have a power failure or PC failure?
>
> Thanks for the info!
>
> Eric
>
> "Mark Maunder" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> > Since HEAP tables
wrote in message
news:[EMAIL PROTECTED]
> Since HEAP tables don't support fulltext indexes, is moving MYISAM
> tables to ramdisk an acceptable workaround?
>
> On Sat, 2004-02-21 at 18:35, Mark Maunder wrote:
> > I've noticed a 4 times insert speed improvement by moving t
Since HEAP tables don't support fulltext indexes, is moving MYISAM
tables to ramdisk an acceptable workaround?
On Sat, 2004-02-21 at 18:35, Mark Maunder wrote:
> I've noticed a 4 times insert speed improvement by moving the MYI index
> file of a myisam table to a ramdisk. The MYD
slave SQL thread apparently
> stopped and the slave IO thread continued running, but the table stopped
> getting updated. The table type again was HEAP.
Check data on slave. Does this value really exist?
Probably your master server was restarted that was the reason why data in your HEAP
tables
Hi Egor,
Thanks for the reply. My responses below -
"Vinod Panicker" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Had a query regarding replication with HEAP tables. It seems like I
> cannot use LOAD DATA FROM MASTER to update the stopped slave with data
> from
"Vinod Panicker" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Had a query regarding replication with HEAP tables. It seems like I cannot
> use LOAD DATA FROM MASTER to update the stopped slave with data from the
> master since it apparently works only for MyISAM tables.
Hi,
Had a query regarding replication with HEAP tables. It seems like I cannot
use LOAD DATA FROM MASTER to update the stopped slave with data from the
master since it apparently works only for MyISAM tables. Any other way of
updating the slave with a snapshot of the data? Since a HEAP table
ve used AWE with innodb tables with embedded MySQL on Win2K. Will this
be implemented on MySQL on Linux? Would this affect HEAP tables? If it
will be implemented, is there a timetable? Will it require something to
be done to the Linux kernel?
Thanks,
Michael
As you write your code in somewhat pseduo code format, I can't comment on the
exact syntax. You may use PERL-DBI-DBD:MySQL to implement your code. However,
it may some problems with your logic. First of all, if the quote_for_family
table already exist, the create table sql do nothing and it defi
Hi All,
After googling around and checking out the archives I still haven't found
the exact answer to my following question:
First off the goal is to give a family multiple quotes from different
companies for insurance based on several factors: age, length of coverage
and coverage limits. All the
At 11:41 -0800 3/6/03, Steve Quezadas wrote:
I have a mysql table that I refer to a lot and needs to be quick. I
set it as a HEAP table because of the speed (and HEAP tales ARE
fast. zip baaannn). Anyway, whenever I restart the server
the contents of the heap tables disappear! What the
>
Sent: Thursday, March 06, 2003 7:41 PM
Subject: heap tables keep on disappearing!
> I have a mysql table that I refer to a lot and needs to be quick. I set
> it as a HEAP table because of the speed (and HEAP tales ARE fast. zip
> baaannn). Anyway, whenever I restart the serv
Store it in another table and have a start up script that creates a heap
once the server is started ?
Jerry
- Original Message -
From: "Steve Quezadas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 06, 2003 7:41 PM
Subject: heap tables keep on di
I have a mysql table that I refer to a lot and needs to be quick. I set
it as a HEAP table because of the speed (and HEAP tales ARE fast. zip
baaannn). Anyway, whenever I restart the server the contents of
the heap tables disappear! What the hell? But I read the manual and it
seems
Cute =)
(MySQL sql query queries smallint =)
Aaron Krowne
On Thu, Jan 09, 2003 at 04:36:12PM +0100, [EMAIL PROTECTED] wrote:
>
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following w
gt; Based on this claim, I designed a database which took advantage of
non-unique keys in HEAP tables. A number of things myseriously failed to
work right, however, and problems could be shown only to surface when the
tables in question were of type HEAP rather than anything else.
>
> The below r
non-unique keys in
HEAP tables. A number of things myseriously failed to work right, however, and
problems could be shown only to surface when the tables in question were of type HEAP
rather than anything else.
The below repro script demonstrates the problem in just about the simplest cast
possi
Hi.
On Mon 2002-11-18 at 17:05:23 -0800, [EMAIL PROTECTED] wrote:
> Hello ,
> I need help with heap tables and calculating memory usage. I checked
> in the Manual and found a formula, but I need help
> deciphering it ;)
>
> " The memory needed for one row in a HEAP tab
Hello ,
I need help with heap tables and calculating memory usage. I checked
in the Manual and found a formula, but I need help
deciphering it ;)
" The memory needed for one row in a HEAP table is:
SUM_OVER_ALL_KEYS(max_length_of_key + sizeof(char*) * 2)
+ ALIGN(length_of_row+1, sizeof
From: [EMAIL PROTECTED]
Date: Tue, 24 Sep 2002 13:41:23 +0800 (WST)
I've got a problem with HEAP tables (undoubtedly the way
that I'm using them).
I'm running MySQL v.3.23.51 under Debian Linux with a
2.4.17 kernel.
If anyone can help clear some
Hi,
I've got a problem with HEAP tables (undoubtedly the way
that I'm using them).
I'm running MySQL v.3.23.51 under Debian Linux with a
2.4.17 kernel.
I've got a perl script which creates a HELP table and
controls the maximum size via the 'max_rows=' option
to &#
Victoria Reznichenko writes:
> Hi!
>
> SM> Victoria Reznichenko writes:
> >> I have a question about heap tables :)
> >>
> >> Why does MySQL allow to insert more rows in the table than is
> >> specified in MAX_ROWS ?
>
> SM> Send a t
Hello everybody,
I have two questions:
1) If I create a table with MAX_ROWS=10 and I insert 10 records. Then I
insert more 3 records. Does mysql delete older records and insert new ones??
2) I created a table using this:
CREATE TABLE a (pa VARCHAR (255) NOT NULL, pi VARCHAR (255), PRIMARY KEY
(p
At 10:15 -0500 3/20/02, Ramaraju.R.V wrote:
>Hi,
>
>Application uses Jboss server with mysql backend.
>IMDB tables (Heap tables) are created by the app. Things work on fine.
>Suddenly we miss Heap tables. We are not able to reproduce this at any
>particular event.
Is some
Hi,
Application uses Jboss server with mysql backend.
IMDB tables (Heap tables) are created by the app. Things work on fine.
Suddenly we miss Heap tables. We are not able to reproduce this at any
particular event.
It happens randomly. We could not make out the reason for this.
We set
Hi,
On Wed, 2002-03-06 at 15:50, Scalper wrote:
> If I create a temporary heap table from a select statement, does the new
> table also inherit the indexes (indices?) from the original table. Or will
I think that every CREATE [...] TABLE [...] SELECT does not inherit any
indexes (doesn't mat
If I create a temporary heap table from a select statement, does the new
table also inherit the indexes (indices?) from the original table. Or will
I have to add an index to the temporary table after it is created?
For example, if I use:
CREATE TEMPORARY TABLE tempstudents TYPE=HEAP SELECT s
server version: 3.23.47
mysql> create table myhits (
-> libid int unsigned not null,
-> begin bigint unsigned not null,
-> end bigint unsigned not null,
-> index(libid),
-> index(begin),
-> index(end)
-> ) type = heap;
Query OK, 0 rows affected (0.00 sec)
[ insert st
Hi,
At first thanks for the answer. I was wondering if my mail was precise enough.
> Your results could have a lot to do with the fact that HEAP tables
> used hashed indexes rather than the B-Tree indexes of MyISAM. The set
No, I've really used queries that take advantage of the h
size
> and other memory factors should not limit performance) and lots of
> very simple operations. I have the following observation from it :
>
> INSERTs : HEAP tables are incredibly faster than everything else.
As you'd expect.
> Then come MYISAM tables (10 to 50 times slow
ns. I have the following observation from it :
- INSERTs : HEAP tables are incredibly faster than everything else.
Then come MYISAM tables (10 to 50 times slower than HEAP), and then
the transactional tables (BDB and InnoDB). However the INSERTs were
not contained in a single transaction, so thi
> If not, are there other kinds of temporary tables that can be used?
"temporary tables" are a special table property, which several table
types can have (ISAM, MyISAM, HEAP). HEAP tables reside purely in
memory (as long as the server runs or they are explicitly deleted),
whereas TEMPOR
is it possible to insert many rows into a heap table?
I'm not sure how from the documentation.
If not, are there other kinds of temporary tables that can be used?
I need to enter 100 rows into a table and then select them with order
by.
do I need to create a table, select the records I want, ins
> =
> 45219
> 011031 2:17:41 Slave: connected to master
> '[EMAIL PROTECTED]:3306', replication started in log
> '3306_bin_log.001' at position 71445219
> ERROR: 1051 Unknown table 't'
> 011031 3:09:04 Slave: error running query 'drop table MY_SHOP.t'
> 011031 3:09:04 Err
: Replication problem (with temporary heap tables ?)
> Hi,
>
> MySQL V. 3.23.33 with binary log and replication turned on:
>
> this is what i do on the master (in a perl script):
> ===
> create temporary table TEMP_HITS ( ... ) TYPE
Hi,
MySQL V. 3.23.33 with binary log and replication turned on:
this is what i do on the master (in a perl script):
===
create temporary table TEMP_HITS ( ... ) TYPE=HEAP;
Insert several things into TEMP_HITS;
Select from TEMP_HITS and insert
Hi.
On Mon, Oct 01, 2001 at 04:53:33PM +0400, [EMAIL PROTECTED] wrote:
> Hello mysql,
>
> Could anyone tell me if heap tables are cyrrently working with
> replication.
>
> As I remember some time ago you might get problems then server
> restarts (so empty it'
Hello mysql,
Could anyone tell me if heap tables are cyrrently working with
replication.
As I remember some time ago you might get problems then server
restarts (so empty it's heap tables) there fore slave does not and
so it gets dublicate key errors on inserts to this tables,
At 10:44 PM -0700 9/16/01, Robert Peters wrote:
>We developed a site using PHP and MYSQL on an online shared server.
>We used HEAP tables extensively and everything worked fine. When we
>moved the site to our dedicated server prior to launching the site,
>the queries that shoul
We developed a site using PHP and MYSQL on an online shared server. We used
HEAP tables extensively and everything worked fine. When we moved the site
to our dedicated server prior to launching the site, the queries that
should create the HEAP tables return syntax errors (when submitting the
We developed a site using PHP and MYSQL on an online shared server. We used
HEAP tables extensively and everything worked fine. When we moved the site
to our dedicated server prior to launching the site, the queries that
should create the HEAP tables return syntax errors (when submitting the
ot;Andrew Schmidt" <[EMAIL PROTECTED]>
>Cc: <[EMAIL PROTECTED]>
>Sent: Thursday, August 16, 2001 12:50 PM
>Subject: Re: auto_increment vs. heap tables
>
>
> > Uh oh... Please NO. I want the standard _FAST_ auto_increment, not this.
> > "select max(id
#x27;" <[EMAIL PROTECTED]>
Sent: Thursday, August 16, 2001 1:02 PM
Subject: RE: auto_increment vs. heap tables
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Except, if you have a table like so:
>
> ++-+
> | id | num |
> ++-+
> |
ct the
max(sess_id).
well anyway, sorry I couldn't help more.
thanks,
-- Andrew
- Original Message -
From: "Leos Bitto" <[EMAIL PROTECTED]>
To: "Andrew Schmidt" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, August 16, 2001 12:50 PM
n table x as 1 field called id which has a
> primary key on it. and newid is the id recieved from the select.
>
> so doing it manually with heap tables seems quite feasable just a little
> extra work.
>
> thanks,
>
> -- Andrew
>
> - Original Message -
> From:
id recieved from the select.
so doing it manually with heap tables seems quite feasable just a little
extra work.
thanks,
-- Andrew
- Original Message -
From: "Leos Bitto" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 14, 2001 6:05 AM
Subject: a
y using MySQL a lot, and now I am facing an old application
written in PHP4 with PostgreSQL, and because of vacuum() it's having a big
troubles. Solution? Straightforward: replace PostgreSQL with MySQL.
Even with plain MyISAM tables, without heap tables (for storing session
information - bascic
n MySQL. Because I have read the MySQL manual (applause
> here, please!) I know that auto_increment cannot be used there.
> This hurts me a lot, and given that MySQL doesn't support sequences,
> it nearly prohibits the usage of heap tables in my application.
You do know that HEAP ta
.
This hurts me a lot, and given that MySQL doesn't support sequences, it
nearly prohibits the usage of heap tables in my application.
However, I am still not giving up, so here's the question: how difficult
would it be to get rid of that restriction for auto_increment in heap
tables?
So sprach »Fournier Jocelyn [Presence-PC]« am 2001-07-15 um 23:37:57 +0200 :
> Hi,
>
> Definitely yes :)
> But the table structure won't be lost.
Thanks to all who replied!
filter: sql
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage:
> Hello
>
> When I store some data in a table of type Heap, this data will be lost
> when the server is shutdown (and later restarted), won't it?
Correct.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
--
Hello
When I store some data in a table of type Heap, this data will be lost
when the server is shutdown (and later restarted), won't it?
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com | http://ww
Does anyone have comments about using HEAP tables to cache a real table from
a database ?
My HEAP tables has max 10 rows.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
For some strange reason, all HEAP table indexes only process WHERE clauses
with = and <=> operators ONLY. There's nothing you can do about it. I'm
pretty sure of that because I remember the MySQL mentions something like
this about HEAP tables.
-Original Message-
From
Hi, I'm not subscribed to the list so please CC: me on replies.
Why are indexes on TEMPORARY tables created with TYPE=HEAP ignored when
doing a query involving ORDER BY or GROUP BY? These indexes are used in
some selects involving a WHERE clause, so obviously the index isn't
completely worthless
I would like to know if a create and drop grants apply with no difference for all
types of tables (heap for instance) and for temporary tables, just like for ordinary
tables.
if yes, isn't it a sort of limitation, because some complicated queries may require
intermediate create and drops some
So sprach Gerhard Schmidt am Thu, Mar 01, 2001 at 04:02:54PM +0100:
> Besides the fakt tha this ID not unique. There ist the Problem that
> the ID you proposed ist an String ID and strings als Index are the
Well, but he could make a two column primary key, where the first is the
timestamp, and
So sprach Entryon Corp., Chief Technical Officer - P. Hasenfratz am Thu, Mar 01, 2001
at 02:37:30PM +0100:
> What's if you combine a timestamp with the client's IP address?
IP addresses can be easily forged, especially if you're writing some kind of
web application, so this is also not a good ch
unique
> > ID for reference with some other Tabels storing dtaa for the session.
> > All these tables are Heap tables. So there is no Probelem if the ID
> > generated by the auto_increment column is not unique when the Database
> > server is restarted.
>
> There
> All these tables are Heap tables. So there is no Probelem if the ID
> generated by the auto_increment column is not unique when the Database
> server is restarted.
There's a couple problems with that to begin with. First, you're
storing state in a HEAP table. If the m
x are the
Major Preformance killer on Databases. Wie kann calculate an intager
from the two information. totaly loosing the Uniqueness.
The question still is. Why are auto_increment columns are not supported
fuer Heap Tables.
SoLong
Es
> > Why not use a timestamp column to guarentee the order in which rows get
> > inserted into the table? You can then order on the timestamp column.
>
> Hmm, timestamp, ie. seconds as finest resolution, might be to broad
depending on
> the hits his site will get - imagine that 2+ users access the
On 01.03.2001 11:56:59 Richard Ellerbrock wrote:
> Why not use a timestamp column to guarentee the order in which rows get
> inserted into the table? You can then order on the timestamp column.
Hmm, timestamp, ie. seconds as finest resolution, might be to broad depending on
the hits his site wi
ansfer-Encoding: quoted-printable
>
> Hi,=20
>
> I wounder why there is no support for Auto_increment fields in Heap
> tables. I know there is a problem with the uniqueness of this columns=20
> but some times the uniqueness of the column is only needes as long=20
> as the heap t
Hi,
I wounder why there is no support for Auto_increment fields in Heap
tables. I know there is a problem with the uniqueness of this columns
but some times the uniqueness of the column is only needes as long
as the heap table exists.
I´m currently working on system for Managing http
Steven Roussey writes:
> Hi!
>
> Do HEAP tables use table locking?
>
> Sincerely,
>
> Steven Roussey
> Network54.com
> http://network54.com/?pp=e
>
>
Hi!
Yes, they do.
Regards,
Sinisa
__ __
Hi!
Do HEAP tables use table locking?
Sincerely,
Steven Roussey
Network54.com
http://network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
92 matches
Mail list logo
