On Thu, May 13, 2004 at 04:51:27PM -0700, Dathan Vance Pattishall wrote:
-Original Message-
From: Tim Cutts [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 13, 2004 7:11 AM
To: MySQL List
Subject: Re: InnoDB filesystem
On 13 May 2004, at 3:34 pm, Dan Nelson wrote
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 13, 2004 4:03 PM
To: Dathan Vance Pattishall
Cc: 'Tim Cutts'; 'MySQL List'
Subject: Re: InnoDB filesystem
On Thu, May 13, 2004 at 04:51:27PM -0700, Dathan Vance Pattishall wrote:
I think
Jeremy Zawodny wrote:
On Thu, May 13, 2004 at 04:51:27PM -0700, Dathan Vance Pattishall wrote:
-Original Message-
From: Tim Cutts [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 13, 2004 7:11 AM
To: MySQL List
Subject: Re: InnoDB filesystem
On 13 May 2004, at 3:34 pm, Dan Nelson wrote
On Wed, May 12, 2004 at 01:38:04PM -0400, Shayne Paddock wrote:
In section 16.7.5 in the mysql manual it says that you can setup
replication with InnoDB tables on the master to MYISAM tables on the
slave. While I have proven this to be true, it does not warn you that
if in your Master's
Hi there, I am aware this isnt possible. I would like the power of Innodb,
but one of my applications also requires the boolean search within blocks
of
text, how can i do this efficiently ?
I know it isn´t so efficient, but you can use:
SELECT *
FROM yourtable
WHERE text_column LIKE '%word%'
Hi there, I am aware this isnt possible. I would like the power of Innodb,
but one of my applications also requires the boolean search within blocks
of
text, how can i do this efficiently ?
I don't know what power of InnoDB you're referring to, but you can always
use InnoDB for certain parts
Tucker, Gabriel [EMAIL PROTECTED] wrote:
Victoria=20
That seemed to work well, thank you.
However, I received another error that I am not sure how to troubleshoot =
during the restore:
ERROR 1114 at line 83 in file: =
'/bb/bin/mysql/backups/archive_4320.sql': The table
Hi,
Are you creating them in the correct order ?
object_type must exist before you can create cur_reject_tk_sum otherwise the
foreign key will give errors.
Marvin
-Original Message-
From: Tucker, Gabriel [mailto:[EMAIL PROTECTED]
Sent: 04 May 2004 14:46
To: Mysql General (E-mail)
on its own port and then run from the
prompt mysql --port= --socket= -p archive_file.sql
Thanks again
Gabe
-Original Message-
From: Marvin Wright [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 04, 2004 9:59 AM
To: Tucker, Gabriel; Mysql General (E-mail)
Subject: RE: InnoDB - Foreign Key
-
From: Tucker, Gabriel [mailto:[EMAIL PROTECTED]
Sent: 04 May 2004 15:13
To: Mysql General (E-mail)
Subject: RE: InnoDB - Foreign Key - Error 150.
Marvin
I believe that is the problem with the restore. When I create the archive
file using the mysqldump command and options previously listed, I
On Tue, 4 May 2004 09:46:27 -0400
Tucker, Gabriel [EMAIL PROTECTED] wrote:
Hello All:
I am having a problem with both V4.0.16 and 4.0.18. Let me explain:
I have a database with two InnoDB tables in v4.0.16. I backup up
this database every night using the following command:
!
Best of luck,
Ken
- Original Message -
From: Marvin Wright [EMAIL PROTECTED]
To: Tucker, Gabriel [EMAIL PROTECTED]; Mysql General
(E-mail) [EMAIL PROTECTED]
Sent: Tuesday, May 04, 2004 10:22 AM
Subject: RE: InnoDB - Foreign Key - Error 150.
Hi,
I don't think mysqldump takes foreign key
Tucker, Gabriel [EMAIL PROTECTED] wrote:
Marvin
I believe that is the problem with the restore. When I create the =
archive file using the mysqldump command and options previously listed, =
I get the create table in the order listed below and thus, the foreign =
key constraint is created
, 2004 10:03 AM
To: Tucker, Gabriel
Subject: Re: InnoDB - Foreign Key - Error 150.
Put in your script:
set foreign_key_checks=0;
in the first line.
mysqldump dumps tables in alphabetical order.
Tucker, Gabriel wrote:
Hello All:
I am having a problem with both V4.0.16 and 4.0.18. Let me
To: [EMAIL PROTECTED]
Subject: Re: InnoDB - Foreign Key - Error 150.
Tucker, Gabriel [EMAIL PROTECTED] wrote:
Marvin
I believe that is the problem with the restore. When I create the =
archive file using the mysqldump command and options previously listed, =
I get the create table in the order
On Tue, 4 May 2004 11:01:59 -0400
Tucker, Gabriel [EMAIL PROTECTED] wrote:
Luciano
I am confused... As far as I can tell, the set
foreign_key_checks=0; is used with the load data infile command.
Actually, I think that it is used for all operations on the DBMS, not just load data
infile,
- Gabe
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 04, 2004 10:35 AM
To: [EMAIL PROTECTED]
Subject: Re: InnoDB - Foreign Key - Error 150.
Tucker, Gabriel [EMAIL PROTECTED] wrote:
Marvin
I believe that is the problem with the restore. When
What can I do here?
Thanks - Gabe
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 04, 2004 10:35 AM
To: [EMAIL PROTECTED]
Subject: Re: InnoDB - Foreign Key - Error 150.
Tucker, Gabriel [EMAIL PROTECTED] wrote:
Marvin
I believe
Gabriel,
First of all, sorry for my poor english (I´m just a brazilian guy - eu
quase não sei falar o portugues, imaginem o ingles então.)
Tucker, Gabriel wrote:
Luciano
I am confused... As far as I can tell, the set foreign_key_checks=0; is used with the
load data infile command. I am not
On Tue, 27 Apr 2004, Scott Switzer wrote:
Hi,
I am having a difficult time with a query. My environment is MySQL
v4.0.16 (InnoDB tables) running on Linux (latest 2.4 kernel).
Basically, I am running a query of the form:
INSERT INTO temp_tbl
SELECT c1,c2...
FROM t1,t2,t3,t4
WHERE ...
Thanks for the message. I should rephrase - the data set is millions of
rows, but the tables are indexed, and an EXPLAIN looks like it is using
indexes effectively. The query produces the exact same results both
times (with and without LOCKing). Is there a reason that by calling the
query
Sp.Raja wrote:
=
700101 20:31:59 INNODB MONITOR OUTPUT
=
Per second averages calculated from the last 39 seconds
--
SEMAPHORES
--
OS WAIT ARRAY INFO: reservation count 139, signal count 139
Mutex spin waits 0,
Message
From: Jochem van Dieten [EMAIL PROTECTED]
To: Sp.Raja [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Date: Tue, Apr-27-2004 5:03 PM
Subject: Re: Innodb running out of disk space for relatively low number of rows!
Sp.Raja wrote:
=
700101 20
Sir,
What is SAP R/3 Ver 4.6c installation procedure on PC? What is Partiontion
requirement?RAM?HardDisk total requirement? C
Can any help me for this installtion procedure?
Regards
Rahul
Sp.Raja [EMAIL PROTECTED] wrote:
Hi list,
I have 5 Databases, out of which 2 have only one table and
To: Dathan Vance Pattishall
Subject: RE: InnoDB Load Problem
I've been keeping tabs on this thread and would just
like to know how to tell what the buffer pool ratio
is. What is it a ratio of? What command do I run to
take a look at it?
Thanks,
Tripp
--- Dathan Vance Pattishall [EMAIL
, 2004 6:36 AM
Subject: RE: Innodb Hot Backup Tool
The good, bad, and the ugly of it? We're debating if we should use it
on
our INNODB tables or use a script to do a hotbackup.
On Tue, Apr 20, 2004 at 01:54:37PM -0400, McConnell, Ann M. wrote:
Does anyone have any experience with Innodb Hot
]
Subject: RE: InnoDB Load Problem
Hi,
To put the unique index on like you suggest is fine for this table but
this
table is just the top level of a hierarchy.
table a has 1 record
table b has 100's of records linked to 1 table a record
table c has 100's of records linked to 1 table b
hi
try this URL: http://www.innodb.com/ibman.php
-arun.
--- Emmett Bishop [EMAIL PROTECTED] wrote: Howdy all,
Quick question about what I'm seeing in the BUFFER
POOL AND MEMORY section...
I've configured the innodb_buffer_pool_size to be 128M
and when I do a show variables like
The good, bad, and the ugly of it? We're debating if we should use it on
our INNODB tables or use a script to do a hotbackup.
On Tue, Apr 20, 2004 at 01:54:37PM -0400, McConnell, Ann M. wrote:
Does anyone have any experience with Innodb Hot Backup Tool?
Yes.
--
Jeremy D. Zawodny |
Arun,
Unfortunately, that link contains the exact same info
as does the mysql.com page. There's almost no
explaination there of what any of the output means.
I'm sure that it's really useful stuff but I don't
have a starting point. Can someone point me in the
right direction (a book or website)
On Tue, 20 Apr 2004, Emmett Bishop wrote:
Howdy all,
Quick question about what I'm seeing in the BUFFER
POOL AND MEMORY section...
I've configured the innodb_buffer_pool_size to be 128M
and when I do a show variables like 'innodb%' I see
| innodb_buffer_pool_size | 134217728
: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
Sent: 19 April 2004 23:35
To: 'Marvin Wright'; [EMAIL PROTECTED]
Subject: RE: InnoDB Load Problem
-Original Message-
From: Marvin Wright [mailto:[EMAIL PROTECTED]
Sent: Monday, April 19, 2004 8:55 AM
To: [EMAIL PROTECTED]
Subject
PROTECTED]
Envoyé : mardi 20 avril 2004 12:45
À : Dathan Vance Pattishall; Marvin Wright; [EMAIL PROTECTED]
Objet : RE: InnoDB Load Problem
Hi,
Thanks Dathan for your response.
So far I have upgraded the mysql to 4.0.18, this supports O_DIRECT as my
4.0.13 did not.
I increased my buffer pool
Pattishall; [EMAIL PROTECTED]
Subject: RE: InnoDB Load Problem
This query is to see if there are duplicate records, I'm not sure how else
I
could do this and it only runs once every 10 minutes.
Why don't you put a unique index on locale,ggd,from,to,supplier,date so you
won't have to play that request
We're using an evaluation version right now - works great, though I've yet
to test a backup (and I need to do that soon).
David.
- Original Message -
From: McConnell, Ann M. [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 20, 2004 10:54 AM
Subject: Innodb Hot Backup Tool
On Tue, Apr 20, 2004 at 01:54:37PM -0400, McConnell, Ann M. wrote:
Does anyone have any experience with Innodb Hot Backup Tool?
Yes.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 219 days,
-Original Message-
From: Marvin Wright [mailto:[EMAIL PROTECTED]
Sent: Monday, April 19, 2004 8:55 AM
To: [EMAIL PROTECTED]
Subject: InnoDB Load Problem
Hi,
Apologies in advance for the large post but I've tried to explain my
problem
as much as I can.
I've read the
Hi Jenny,
mysql SHOW VARIABLES LIKE '%have%';
++---+
| Variable_name | Value |
++---+
| have_bdb | YES |
| have_crypt | NO|
| have_innodb| YES |
| have_isam | YES |
| have_raid | NO|
|
How do I know the table is configured by InnoDB instead of normal table ?
Do a show table status or a show create table name_of_my_table
Should I at least see some entry in the /etc/my.cnf to indicate that InnoDB
is configured?
No, but if you don't want to use innodb you can add skip-innodb in
starofframe [EMAIL PROTECTED] wrote:
Hi,
I wanna ask about InnoDB...
I've been trying InnoDB for sometimes and I found out one thing weird that is :
When I make an InnoDB tables and filled it with some records ..it took about 2 Mb of
file's capacities..
but when I delete all the
Rick,
- Original Message -
From: Rick Ellis [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, April 01, 2004 11:27 AM
Subject: InnoDB problems with 4.0.18-max
Hi Guys,
We are currently using MySQL as the backend to the RT Request Tracker
Ticketing system. The
Bryan,
- Original Message -
From: Bryan Heitman [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, April 01, 2004 1:53 AM
Subject: InnoDB Deadlock cannot find free slot for undo
Looking for some help on tuning my InnoDB settings. I received a InnoDB
deadlock.
Is InnoDB table type support included in the 5.?.? version?
Why shouldn't it?
Make sure you start the right version of MySQL though.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL
Server.
Upscene Productions
http://www.upscene.com
--
help or a point in the right direction in this situation would be
helpful
Bryan Heitman
FuseMail
- Original Message -
From: Dathan Vance Pattishall [EMAIL PROTECTED]
To: 'Bryan Heitman' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, April 01, 2004 12:15 AM
Subject: RE: InnoDB
Did you run out of disk space? If not what transaction model are you using?
Is it repeatable read? If so, are you allowing the transaction to finish
with a commit? If not your filling your transaction log and that's how your
getting this message. Call commit on the session OR SET AUTOCOMMIT=1 on
Marc,
please send the printouts to me.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Register now for the 2004 MySQL Users
Hi!
Looks like your Linux kernel makes the file read performed by ibbackup to
fail immediately, but does not set errno to anything. That is why ibbackup
says the errno is 0.
The support for O_DIRECT is rather new in Linux kernels.
For now the workaround is not to use O_DIRECT if you plan to use
Yes that makes sense, thanks Heikki.
I monitored the ib_logfiles some more and see
the cycling between pairs logfile0+logfile1 and
logfile0+logfile2.
Heikki Tuuri wrote:
John,
- Original Message -
From: John Thorpe [EMAIL PROTECTED]
I am running 4.0.4 using innodb tables on a linux box.
1. The column types must match in order to establish a foreign key
relationship. Alter the data type would invalidate the Foreign key. Therefore
the key must be dropped first.
2. You can not have a relationship on a column that does not exists. Once again
the key must first be dropped.
3-4.
Hi!
- Original Message -
From: Victor Pendleton [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, March 18, 2004 8:21 PM
Subject: Re: InnoDB - alter column
1. The column types must match in order to establish a foreign key
relationship. Alter the data type would
John Thorpe wrote:
524288000 Mar 11 11:19 ib_logfile0
524288000 Mar 3 08:59 ib_logfile1
524288000 Mar 11 11:19 ib_logfile2
I would venture a random guess that ib_logfile1 was in use until Mar 3,
then ib_logfile2 began and that around Mar 11 it switched back up to
ib_logfile0 where it
Nolan [EMAIL PROTECTED]
To: Sasha Pachev [EMAIL PROTECTED]
Cc: Cliff [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, March 09, 2004 7:14 PM
Subject: Re: InnoDB tables using 90% cpu
Sasha Pachev wrote:
Cliff wrote:
The query is running dramatically slower than the MyISAM query,
sometimes
Cliff,
- Original Message -
From: Cliff [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Saturday, March 13, 2004 11:32 PM
Subject: Re: InnoDB tables using 90% cpu
Well I recompiled with Linuxthreads with the same result. I ran explain on
both queries and the only
John,
- Original Message -
From: John Thorpe [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, March 11, 2004 7:34 PM
Subject: Innodb logfiles timestamp question
Hi,
I am running 4.0.4 using innodb tables on a linux box.
My innodb config is
: Tuesday, March 09, 2004 4:56 PM
Subject: Re: InnoDB tables using 90% cpu
The query is running dramatically slower than the MyISAM query,
sometimes
even causing mysql to freeze for a while. I searched this list and
found a
few people saying that on FreeBSD mysql should be compiled using
linux
this been resolved or is should I recompile? I am using native freebsd
threads.
- Original Message -
From: Sasha Pachev [EMAIL PROTECTED]
To: Cliff [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, March 08, 2004 9:18 AM
Subject: Re: InnoDB tables using 90% cpu
Cliff wrote:
Hi, I
Cliff wrote:
The query is running dramatically slower than the MyISAM query, sometimes
even causing mysql to freeze for a while. I searched this list and found a
few people saying that on FreeBSD mysql should be compiled using linux
pthreads if you are using InnoDB or else I would get this exact
Sasha Pachev wrote:
Cliff wrote:
The query is running dramatically slower than the MyISAM query,
sometimes
even causing mysql to freeze for a while. I searched this list and
found a
few people saying that on FreeBSD mysql should be compiled using linux
pthreads if you are using InnoDB or else
Jon Thingvold [EMAIL PROTECTED] wrote:
Description:
From error.log:
040308 9:34:00 InnoDB: Assertion failure in thread 13835301 in file row0upd.c line
713
InnoDB: Failing assertion: len == dfield_get_len(dfield)
InnoDB: We intentionally generate a memory trap.
InnoDB: Send a detailed bug
Cliff wrote:
Hi, I have a whole database I wanted to convert to InnoDB from MyISAM, but
do not want to use alter table because of the problems I had last time. I
made a whole dump of the table using mysqldump and changed all of the table
create definitions from MyISAM to InnoDB. Theoretically this
: Re: Innodb table space getting filled up without any increase in actual
rows!! - Looks like can be fixed.
FYI.
Sp. Raja,
you have 3 dangling transactions that have been active for almost 2 hours.
They prevent purge from removing those delete-marked rows.
---TRANSACTION 0 832338
Sp. Raja,
- Alkuperäinen viesti -
Lähettäjä: Sp.Raja [EMAIL PROTECTED]
Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED]
Kopio: mysql [EMAIL PROTECTED]
Lähetetty: Friday, March 05, 2004 2:28 PM
Aihe: Re: Innodb table space getting filled up without any increase in
actual rows!!
Thanks
Subject: Re: Innodb table space getting filled up without any increase in actual
rows!!
Sp. Raja,
please check with
SHOW INNODB STATUS\G
if purge is still running and removing delete-marked rows. Also check that
you do not have old, dangling transactions, which can prevent
PM
Aihe: Re: Innodb table space getting filled up without any increase in
actual rows!!
Heikki,
Thanks for your reply.
As you said I have attached trace collected for SHOW INNODB STATUS.
Please point me the things which are going wrong.
Do you mean I have to use auto-commit transactions?
What
Sp. Raja,
please check with
SHOW INNODB STATUS\G
if purge is still running and removing delete-marked rows. Also check that
you do not have old, dangling transactions, which can prevent purge from
running, as those old transactions could still see the delete-marked rows.
Best regards,
Heikki
If there's a bug in the optimiser, you'll find it's in the higher
levels of the codebase. InnoDB doesn't have any SQL optimisation code
in it, so any bugs in this area aren't in InnoDB.
Regards,
Chris
Dyego Souza Dantas Leal wrote:
The script of database are uploaded to:
Dyego,
http://www.mysql.com/doc/en/JOIN.html
LEFT JOIN means an 'outer join'. I think it does NOT force the join order.
STRAIGHT JOIN forces the join order.
Best regards,
Heikki
Innobase Oy
http://www.innodb.com
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot
perhaps you would get a better response from doing scp... which runs
over ssh... or doing the mysqldump in a cron job, so it will
already be complete for transport by ssh. I still think scp is the more
proper way to go.
dan orlic
Steve Williams wrote:
Hi,
We have a (pre-existing) disaster
PROTECTED]
Sent: Friday, February 27, 2004 3:52 PM
To: Steve Williams
Cc: [EMAIL PROTECTED]
Subject: Re: InnoDB, mysqldump/mysql timeout dropping table (disaster
recovery)
perhaps you would get a better response from doing scp... which runs
over ssh... or doing the mysqldump in a cron job, so
.
Thanks,
Steve Williams
-Original Message-
From: dan orlic [mailto:[EMAIL PROTECTED]
Sent: Friday, February 27, 2004 3:52 PM
To: Steve Williams
Cc: [EMAIL PROTECTED]
Subject: Re: InnoDB, mysqldump/mysql timeout dropping table (disaster
recovery)
perhaps you would get a better
: [EMAIL PROTECTED]
Subject: Re: InnoDB, mysqldump/mysql timeout dropping table (disaster
recovery)
perhaps you would get a better response from doing scp... which runs
over ssh... or doing the mysqldump in a cron job, so it will
already be complete for transport by ssh. I still think scp
-Original Message-
From: dan orlic [mailto:[EMAIL PROTECTED]
Sent: Friday, February 27, 2004 3:52 PM
To: Steve Williams
Cc: [EMAIL PROTECTED]
Subject: Re: InnoDB, mysqldump/mysql timeout dropping table (disaster
recovery)
perhaps you would get a better response from doing scp... which runs
Jochem,
- Original Message -
From: Jochem van Dieten [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Saturday, February 21, 2004 2:10 AM
Subject: Re: InnoDB Hot Backup + MySQL embedded?
Sasha Pachev wrote:
Heikki Tuuri wrote:
C versus object-oriented lanuguages like C
-
Von: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Gesendet: Samstag, 21. Februar 2004 09:30
An: [EMAIL PROTECTED]
Betreff: C compared to C++/Java; Was: Re: InnoDB Hot Backup + MySQL
embedded?
Jochem,
- Original Message -
From: Jochem van Dieten [EMAIL PROTECTED]
Newsgroups
should be done from skilled programmers - thats all.
mfg
Klaus
-Ursprüngliche Nachricht-
Von: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Gesendet: Samstag, 21. Februar 2004 09:30
An: [EMAIL PROTECTED]
Betreff: C compared to C++/Java; Was: Re: InnoDB Hot Backup + MySQL
embedded?
Jochem
Heikki Tuuri wrote:
From: Jochem van Dieten
Sasha Pachev wrote:
In Java is it easy to write a program that wastes large amounts of
memory, which is worse than a leak. In C, you are full from the start,
and then you leak a drop at a time until you are empty. In Java , you
are empty from the start,
]
Gesendet: Samstag, 21. Februar 2004 09:30
An: [EMAIL PROTECTED]
Betreff: C compared to C++/Java; Was: Re: InnoDB Hot Backup + MySQL
embedded?
Jochem,
- Original Message -
From: Jochem van Dieten [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Saturday, February 21, 2004 2
I prefer TCL because on my opinion it is the best of both worlds
( i never had a memleak except with a bad API written in C).
Bad...written in C...was it a SCO library?
Complex tasks should be done from skilled programmers - thats all.
Additionally, complex tasks should be decomposed into
).
Complex tasks should be done from skilled programmers - thats all.
mfg
Klaus
-Ursprüngliche Nachricht-
Von: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Gesendet: Samstag, 21. Februar 2004 09:30
An: [EMAIL PROTECTED]
Betreff: C compared to C++/Java; Was: Re: InnoDB Hot Backup + MySQL
embedded
C versus object-oriented lanuguages like C++/Java is a topic I have
discussed a lot with programmers. I believe that traditional procedural
approaches and languages, like C, are the best for 'systems programming', by
which I mean implementing anything with complex data structures and lots of
Sasha Pachev wrote:
Heikki Tuuri wrote:
C versus object-oriented lanuguages like C++/Java is a topic I have
discussed a lot with programmers. I believe that traditional procedural
approaches and languages, like C, are the best for 'systems programming', by
which I mean implementing anything with
Jochem van Dieten wrote:
Sasha Pachev wrote:
Heikki Tuuri wrote:
C versus object-oriented lanuguages like C++/Java is a topic I have
discussed a lot with programmers. I believe that traditional procedural
approaches and languages, like C, are the best for 'systems
programming', by
which I mean
Sasha Pachev wrote:
C versus object-oriented lanuguages like C++/Java is a topic I have
discussed a lot with programmers. I believe that traditional procedural
approaches and languages, like C, are the best for 'systems
programming', by
which I mean implementing anything with complex data
Sasha Pachev wrote:
Jochem van Dieten wrote:
Sasha Pachev wrote:
Heikki Tuuri wrote:
C versus object-oriented lanuguages like C++/Java is a topic I have
discussed a lot with programmers. I believe that traditional
procedural
approaches and languages, like C, are the best for 'systems
Chris,
- Alkuperäinen viesti -
Lähettäjä: Chris Nolan [EMAIL PROTECTED]
Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED]
Kopio: [EMAIL PROTECTED]
Lähetetty: Monday, February 16, 2004 1:56 PM
Aihe: Re: InnoDB Hot Backup + MySQL embedded?
Heikki,
Thank you greatly for answering my
, Heikki Tuuri wrote:
Chris,
- Original Message -
From: Chris Nolan [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, February 12, 2004 2:26 PM
Subject: Re: InnoDB Hot Backup + MySQL embedded?
Dear Heikki,
Thanks for the quick
Chris,
- Original Message -
From: Chris Nolan [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, February 12, 2004 2:26 PM
Subject: Re: InnoDB Hot Backup + MySQL embedded?
Dear Heikki,
Thanks for the quick response! It never ceases to amaze me
Chris,
- Original Message -
From: Chris Nolan [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, February 12, 2004 2:45 AM
Subject: InnoDB Hot Backup + MySQL embedded?
Hi all,
I'm looking at developing an (open source) server-style application with
the embedded
: Re: InnoDb Table Performance problem
Michael McTernan wrote:
Hi there,
I'm making something similar to a file revision control system, and using
MySQL on Linux as the database to drive it. Almost all my tables are
InnoDB, and generally it is going very well, with the exception
of one
McTernan
Cc: Mysql
Subject: Re: InnoDb Table Performance problem
Michael McTernan wrote:
Hi there,
I'm making something similar to a file revision control system, and using
MySQL on Linux as the database to drive it. Almost all my tables are
InnoDB, and generally it is going very well
Dear Heikki,
Thanks for the quick response! It never ceases to amaze me that such
compartively small teams at Innobase Oy and MySQL AB produce such
incredibly high-quality software.
Being a final-year Software Engineering student, I'm curious as to what
you consider the most difficult problem
Michael McTernan wrote:
Hi,
SELECT COUNT(*) for InnoDB tables is a know problem... The table
handler (for InnoDB) has to do a table scan to count all rows... This
particular case is optimized with MyISAM ...
Sure. But why is the tablescan ~100 times faster for the table without the
PROTECTED]
Sent: 12 February 2004 14:04
To: Michael McTernan
Cc: Mysql
Subject: Re: InnoDb Table Performance problem
Michael McTernan wrote:
Hi,
SELECT COUNT(*) for InnoDB tables is a know problem... The table
handler (for InnoDB) has to do a table scan to count all rows
.
Thanks,
Mike
-Original Message-
From: Chris Nolan [mailto:[EMAIL PROTECTED]
Sent: 12 February 2004 12:23
To: Michael McTernan
Cc: Benoit St-Jean; Mysql
Subject: Re: InnoDb Table Performance problem
Michael McTernan wrote:
Hi,
SELECT COUNT(*) for InnoDB tables is a know
-
From: Benoit St-Jean [mailto:[EMAIL PROTECTED]
Sent: 11 February 2004 22:47
To: Michael McTernan
Cc: Mysql
Subject: Re: InnoDb Table Performance problem
Michael McTernan wrote:
Hi there,
I'm making something similar to a file revision control
system, and using
MySQL
Subject: Re: InnoDb Table Performance problem
Michael McTernan wrote:
Hi there,
I would try to sum it up like this:
1. Discs work best when used as purely sequential devices.
2. Inserting those BLOBs takes up space somewhere. Strictly speaking, on
the disc they may very well be in between
Michael McTernan wrote:
Hi there,
I'm making something similar to a file revision control system, and using
MySQL on Linux as the database to drive it. Almost all my tables are
InnoDB, and generally it is going very well, with the exception of one table
that is always very slow.
This table
Michael,
- Original Message -
From: MIchael Johnson [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Saturday, February 07, 2004 1:03 AM
Subject: INNODB - Reclaiming ibdata space and various ibdata questions
--0-1416817391-1076108604=:94234
Content-Type: text/plain;
Chris,
- Original Message -
From: Chris Elsworth [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Saturday, February 07, 2004 7:25 PM
Subject: InnoDB Hot Backup new tablespace format
Hello,
Does anyone know if InnoDB Hot Backup supports the new tablespace
format being
Tofu Optimist wrote:
When I set up the databases, I recall assigning
a few large fixed-size files to the InnoDB engine for
data (and I think) logs.
I've been adding data to my databases daily and wish
to know how full they are,
Use this command:
show table status from database_name like
701 - 800 of 1574 matches
Mail list logo