Found the cause.
sync_binlog was set to 1. I suspect that the default value is 5.5 was 0 and
that is has changed to 1
sometime after that.
Setting it to 0 boosted the performance back to normal (4x speed) and the HD
LED indicated much
lower stress on the hard disk.
Found this after I found
Hi Jørn,
Found this after I found out what caused it:
https://www.percona.com/blog/2009/01/21/beware-ext3-and-sync-binlog-do-not-play-well-together/
I suspect that this also apply to ext4, or?
I would go more specific and say that sync_binlog=1 does not play well with
single-threaded
Hello
(again I must say).
Over a year ago I experienced a severe drop in the MySQL Innodb performance
after ugrading to MySQL
5.6. I did not found any solution to that so I downgraded back to 5.5.33 and
lived with in until
recently.
After a system disk crash I replaced the system disk
...@wagnerbianchi.com
Skype: wbianchijr
2015-05-20 15:07 GMT-03:00 Jørn Dahl-Stamnes sq...@dahl-stamnes.net:
Hello
(again I must say).
Over a year ago I experienced a severe drop in the MySQL Innodb
performance after ugrading to MySQL
5.6. I did not found any solution to that so I downgraded back
On Wednesday, May 20, 2015, wagnerbianchi.com wrote:
Can you share the SHOW ENGINE INNODB STATUS\G ?
Sure, here it is.
*** 1. row ***
Type: InnoDB
Name:
Status:
=
2015-05-20 20:29:56 0x7f9a4c189700 INNODB
Hi Jørn,
- The data collector system processing jobs, is it multi threaded?
Sorry, forgot about that. No, it is not multi threaded. It is a PHP bases
system using several
script running sequently in an infinite loop. Each script taking care of part
of the job of
processing the data.
On Wednesday, May 20, 2015, Morgan Tocker wrote:
Hi Jørn,
Wagner’s point about SHOW ENGINE INNODB STATUS is a good one. A couple of
other questions about your workload:
- The data collector system processing jobs, is it multi threaded?
Sorry, forgot about that. No, it is not multi
I'd like to add to the Morgan's note that if you want to restrict the
number of transactions inside InnoDB kernel to 16, you need at least
configure the tickets...
= http://www.pythian.com/blog/once-again-about-innodb-concurrency-tickets/
BTW, leave it as its default, IMHO,
(again I must say).
Over a year ago I experienced a severe drop in the MySQL Innodb
performance after ugrading to MySQL
5.6. I did not found any solution to that so I downgraded back to 5.5.33
and lived with in until
recently.
After a system disk crash I replaced the system disk
Hi Jørn,
Wagner’s point about SHOW ENGINE INNODB STATUS is a good one. A couple of
other questions about your workload:
- The data collector system processing jobs, is it multi threaded?
- Do you have a sample schema + set of queries we could look at?
(We pay close attention to regressions.)
On Wednesday, May 20, 2015, wagnerbianchi.com wrote:
I'd like to add to the Morgan's note that if you want to restrict the
number of transactions inside InnoDB kernel to 16, you need at least
configure the tickets...
= http://www.pythian.com/blog/once-again-about-innodb-concurrency-tickets/
Good day all
We have downloaded the following MySQL version which untarred to
provide a list of RPM's:
MySQL-server-advanced-gpl-5.1.50-1.rhel5.x86_64.tar
The installations went through fine, however while doing some
configurations I found that Innodb is not enabled / installed.
Hi Maurice,
You say the MySQL data wasn't on the stuck volume, but were the InnoDB logs?
What is the disk configuration?
It sounds to me like bad hardware/software, which, unfortunately MySQL
and InnoDB cannot protect you from...
Regards,
Jeremy
Maurice Volaski wrote:
Some processes
Some processes on a server (64-bit Gentoo Linux with MySQL 5.0.44),
which seemed to be related to I/O on LVM volumes hung and it was
necessary to force reboot it. The mysql data was not on an LVM volume
though it still may have been affected since over time, more and more
processes became
Hi,
In my earlier post, I was making a mistake (though I didn't do so in
the posted text!) - I was passing the dob (the date field) in the
ddmm format. When I passed the date field in mmdd format, the
stored procedure ran fine and the record got inserted. The problem is
MySQL
2006/4/7, Charles Q. Shen [EMAIL PROTECTED]:
Hi all,
I am running MySQL 4.1.11 with an innoDB table holding about 17GB of
records. I took a few hundreds of randomly selected records from the table
and measured the average access time:
1st test: average access time is 600ms
2nd test:
The OS used are Mandriva and Fedora.
Can you explain more?
Thanks.
Charles
-Original Message-
From: Philippe Poelvoorde [mailto:[EMAIL PROTECTED]
Sent: Friday, April 07, 2006 2:43 AM
To: MySQL General
Subject: Re: MySQL 4.1.11 innodb cache can't be flushed after
restart
2006/4/7, Charles Q. Shen [EMAIL PROTECTED]:
The OS used are Mandriva and Fedora.
Can you explain more?
I'll make it quick, there is plenty of doc on a web that will explain
this better than I can.
Once you read few things from your hard drive (let's say the index
file for your table), it's
Hi all,
I am running MySQL 4.1.11 with an innoDB table holding about 17GB of
records. I took a few hundreds of randomly selected records from the table
and measured the average access time:
1st test: average access time is 600ms
2nd test: average access time is 30ms
3rd test: average access
locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
- Original Message -
From: superfly [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, November 23, 2005 7:32 PM
Jeremy Cole wrote:
Is it possible to run MySQL with InnoDB enabled on a readonly
filesystem. We only intend to run some select query's on this server.
I guess I can ask the obvious question. Why are you trying to use
InnoDB, if your data/filesystem is read only? Why not use MyISAM
Hello,
Is it possible to run MySQL with InnoDB enabled on a readonly
filesystem. We only intend to run some select query's on this server.
This is the errormessage from InnoDB
Nov 23 13:36:30 aliao mysqld[16073]: InnoDB: Error number 30 means
'Read-only file system'.
Nov 23 13:36:30 aliao
Hi Ralph,
Is it possible to run MySQL with InnoDB enabled on a readonly
filesystem. We only intend to run some select query's on this server.
I guess I can ask the obvious question. Why are you trying to use
InnoDB, if your data/filesystem is read only? Why not use MyISAM instead?
Regards
Hello.
Check the correct values in your configuration file for the size of the
log files. If you're sure that shutdown of the server was clean, you can
remove log files, InnoDB will recreate them (I suggest you to make a
backup of the old log files just in case something went wrong in the
Hi,
Our mysql 4.1 database server on win2000 was uninstalled by mistake, but
reinstalled , caused the follow errors:
InnoDB: Error: log file .\ib_logfile0 is of different size 0 14680064 bytes
InnoDB: than specified in the .cnf file 0 10485760 bytes!
051020 19:30:42 [ERROR] Can't init databases
, specify also:
innodb_log_files_in_group=...
Regards,
Heikki
Oracle/Innobase
- Original Message -
From: wang shuming [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, October 20, 2005 3:05 PM
Subject: reinstall mysql show innodb error
] wrote:
[-- text/plain, encoding 7bit, charset: ISO-8859-1, 74 lines --]
I'm attempting to configure mysql with InnoDB tables and I'm running
into problems. And am using the following version of mysqld-max, Ver
4.0.18-Max for suse-linux on i686 (Source distribution)
First I uncommented
I'm attempting to configure mysql with InnoDB tables and I'm running
into problems. And am using the following version of mysqld-max, Ver
4.0.18-Max for suse-linux on i686 (Source distribution)
First I uncommented the following lines in /etc/my.cnf:
# Uncomment the following if you are using
-Original Message-
From: Richard Dale [mailto:[EMAIL PROTECTED]
Sent: Sunday, May 08, 2005 9:37 PM
To: mysql@lists.mysql.com
Subject: Dual Opteron, linux kernels, 64 bit, mysql 4.1, InnoDB
A new server is about to arrive here and will have have 8x15K
RPM spindles, dual
.
- Original Message -
From: Dathan Pattishall [EMAIL PROTECTED]
To: Richard Dale [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Monday, May 09, 2005 4:15 PM
Subject: RE: Dual Opteron, linux kernels, 64 bit, mysql 4.1, InnoDB
-Original Message-
From: Richard Dale [mailto:[EMAIL PROTECTED]
Sent
Lakewood NM 88254
http://www.gunmuse.com
469 228 2183
-Original Message-
From: Jeremiah Gowdy [mailto:[EMAIL PROTECTED]
Sent: Monday, May 09, 2005 6:37 PM
To: Dathan Pattishall; Richard Dale; mysql@lists.mysql.com
Subject: Re: Dual Opteron, linux kernels, 64 bit, mysql 4.1, InnoDB
I use Redhat
BlackBerry Handheld.
- Original Message -
From: [EMAIL PROTECTED]
Sent: 05/09/2005 09:39 PM
To: Jeremiah Gowdy [EMAIL PROTECTED]; Dathan Pattishall [EMAIL
PROTECTED]; Richard Dale [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: RE: Dual Opteron, linux kernels, 64 bit, mysql 4.1, InnoDB
@lists.mysql.com
Sent: Monday, May 09, 2005 6:39 PM
Subject: RE: Dual Opteron, linux kernels, 64 bit, mysql 4.1, InnoDB
Why not Raid 3 and take advantage of disk write and read performance.
Raid 3 isn't commonly used because it has CPU overhead. But at the same
time Apache causes CPU overhead waiting
A new server is about to arrive here and will have have 8x15K RPM spindles,
dual Opteron processors and 4GB of RAM, and will have around 100GB of
database (primarily stock market prices) - the SCSI controller will also
have battery-backed RAM too. InnoDB will be used exclusively.
I've searched
Dear friends
we have a problem here.
We have 3 tables
- table language (id int not null auto_increment primarykey, languageName
tinytext)
- table country (id int not null auto_increment primarykey, defaultName
tinytext, defaultLanguage tinytext)
- table countryToLanguage ((languageID int,
symbulos partners [EMAIL PROTECTED] wrote on 03/21/2005 08:08:53 AM:
Dear friends
we have a problem here.
We have 3 tables
- table language (id int not null auto_increment primarykey,
languageName
tinytext)
- table country (id int not null auto_increment primarykey, defaultName
I don't think so. You already have the country's name in it's own language
on the countryToLanguage table, don't you? What name in which language is
the defaultName column supposed to represent? If you can define what the
*contents* of that field is supposed to be, then you should be able to
symbulos partners [EMAIL PROTECTED] wrote on 03/21/2005 10:25:27 AM:
I don't think so. You already have the country's name in it's own
language
on the countryToLanguage table, don't you? What name in which language
is
the defaultName column supposed to represent? If you can define what
.
From: Heikki Tuuri [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Re: mysql crash - innodb not starting
Date: Thu, 3 Mar 2005 23:20:56 +0200
Hi!
Error 11 means that you already have a mysqld process running on the same
files.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys
, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Order MySQL Network from http://www.mysql.com/network/
- Alkuperäinen viesti -
Lähettäjä: mel list_php [EMAIL PROTECTED]
Vastaanottaja: mysql
[EMAIL PROTECTED]
To: mel list_php [EMAIL PROTECTED], mysql@lists.mysql.com
Subject: Re: mysql crash - innodb not starting
Date: Fri, 4 Mar 2005 15:50:26 +0200
Mel,
do
ps -fA
Do you see more mysqld processes?
If the ibdata1 file stays locked even though there is no mysqld process
Mel,
- Alkuperäinen viesti -
Lähettäjä: mel list_php [EMAIL PROTECTED]
Vastaanottaja: [EMAIL PROTECTED]; mysql@lists.mysql.com
Lähetetty: Friday, March 04, 2005 4:13 PM
Aihe: Re: mysql crash - innodb not starting
Hi Heikki,
Still only one process with ps -fA. And mysql doesn't want
Hi,
I just have a crash of my mysql 4.1.5 .(the machine where it was running
just shutdown)
Tried to restart it, and problem with innodb:
050303 11:58:46 [WARNING] Asked for 196608 thread stack, but got 126976
InnoDB: Unable to lock ./ibdata1, error: 11InnoDB: Error in opening
./ibdata1
050303
Hi!
Error 11 means that you already have a mysqld process running on the same
files.
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
: Heikki Tuuri [EMAIL PROTECTED]
Lähetetty: Monday, January 17, 2005 11:11 AM
Aihe: Re: MySQL 4.1.8 InnoDB: data unavailability among different
connections
Thank you all for the hints.
What will be then the best solution to always get the latest data?
- Use commits (e.g. 'COMMIT; SELECT . ) before
Jose,
you must commit also the read transaction.
http://dev.mysql.com/doc/mysql/en/InnoDB_consistent_read.html
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
Hi!
I am experiencing something weird using MySQL 4.1.8 with InnoDB tables.
I have an application, let's call it A, that is monitoring the data that
is available in the database. The data is inserted in the database by a
different application, let's call it B. The problem is the following
simple answer is transactions. until you issue a commit, or otherwise
specify extra settings in your SQL syntax, other connections do not see
your data.
Jose Antonio wrote:
Hi!
I am experiencing something weird using MySQL 4.1.8 with InnoDB tables.
I have an application, let's call
do not
see your data.
Jose Antonio wrote:
Hi!
I am experiencing something weird using MySQL 4.1.8 with InnoDB tables.
I have an application, let's call it A, that is monitoring the data
that is available in the database. The data is inserted in the
database by a different application, let's call
of
InnoDB: InnoDB! But if you absolutely need to downgrade, see
InnoDB: http://dev.mysql.com/doc/mysql/en/Multiple_tablespaces.html
InnoDB: for instructions.
041215 16:42:00 [ERROR] /usr/local/mysql-4.1.7/libexec/mysqld: Can't find
file: 'host.MYI' (errno: 2)
041215 16:42:00 [ERROR] Fatal error
tablespaces
InnoDB: format. You should NOT DOWNGRADE to an earlier version of
InnoDB: InnoDB! But if you absolutely need to downgrade, see
InnoDB: http://dev.mysql.com/doc/mysql/en/Multiple_tablespaces.html
InnoDB: for instructions.
041215 16:42:00 [ERROR] /usr/local/mysql-4.1.7/libexec/mysqld: Can't find
We are considering migration to mysql 4.1. innodb. So I've made some tests
comparing innodb and myisam performance. Innodb was very very slow, so I
suspect something is wrong. It can't be so bad!
Mysql 4.1.7 on Linux (binary from www.mysql.com).System - Duron 800MHz, 500MB
RAM. Myisam database
Hristo Chernev wrote:
We are considering migration to mysql 4.1. innodb. So I've made some tests
comparing innodb and myisam performance. Innodb was very very slow, so I
suspect something is wrong. It can't be so bad!
Mysql 4.1.7 on Linux (binary from www.mysql.com).System - Duron 800MHz, 500MB
Hristo,
if you are doing INSERTs, UPDATEs, or DELETEs, try setting
innodb_flush_log_at_trx_commit=2
But read the caveats in the manual. You can also set innodb_buffer_pool_size
bigger.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot
Egor Egorov [EMAIL PROTECTED] wrote:
Stefan Gnann [EMAIL PROTECTED] wrote:
I have a mysql database 4.0.15 on a suse linux 9.x system running.
First, upgrade to .20 version officially built by MySQL AB (http://dev.mysql.com/).
RPM version is easy to install and run.
Oops, of
Stefan Gnann [EMAIL PROTECTED] wrote:
I have a mysql database 4.0.15 on a suse linux 9.x system running.
First, upgrade to .20 version officially built by MySQL AB (http://dev.mysql.com/).
RPM version is easy to install and run.
Now we have to use the features of InnoDB tables (rollback,
Hi all,
I have a mysql database 4.0.15 on a suse linux 9.x system running.
Now we have to use the features of InnoDB tables (rollback, a.s.o.).
Up to now we use the standard table type MyISAM.
Now I want to change the tabel type with the command ALTER TABLE x TYPE
= InnoDB.
The command
Is there any output from the command? Any errors?
Try SHOW CREATE TABLE x. It should show you the TYPE= at the end.
out.
On Thu, 21 Oct 2004 11:10:10 +0200, Stefan Gnann
[EMAIL PROTECTED] wrote:
Hi all,
I have a mysql database 4.0.15 on a suse linux 9.x system running.
Now we have to
be that InnoDB is not able to create its
ibdata and ib_logfiles. Look what mysqld prints when it starts.
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
Hi,
MySQL 4.0.16 running on Red Hat Linux release 8.0
with 4 Intel XEON 2.40 GHz with InnoDB tables.
This is the stack trace :
0x81077c6 handle_segfault + 474
0x4002a929 _end + 935891041
0x8272ff8 sync_array_print_long_waits + 580
0x81a7328 srv_error_monitor_thread + 96
0x40024ada _end +
C.F. Scheidecker Antunes [EMAIL PROTECTED] wrote:
Can anyone point me out what is going on wrong in this scenario?
The .err file in the datadir can give you a clue. Take a look at the end of it.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is
Hello all,
I would like to create InnoDB databases within MySQL. I have installed
MySQL 4.0.20 and I have tried to uncomment the following on my
/etc/my.cnf. MySQL is run on top of Fedora Core 2 Linux.
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /var/lib
, 2004 4:59 AM
Subject: Mysql 4.1.1, InnoDB - Slow TRUNCATE operations with Multiple
Tablespaces
--=_NextPart_000_0050_01C43F2A.002F6960
Content-Type: text/plain;
charset=us-ascii
Content-Transfer-Encoding: 7bit
Hi everybody,
I'm experiencing that the command TRUNCATE TABLE
such slow TRUNCATE operations?
Here's a summary of my environment:
Platform: Mysql 4.1.1-aplha, InnoDB
Noteable parameters: innodb_file_per_table, 160MB innodb buffer pool
Hardware: Win XP, 3Ghz P4 (HT), 1GB RAM, multiple 7200RPM drives
Database location: On its own database on its own hard drive
,
Mikhail.
- Original Message -
From: nm [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 30, 2003 10:17 AM
Subject: guru needed - large configuration MySQL-Max InnoDB - 4.0.16
Hi there
I was wondering I you can send your comments and remarks for this my.cnf
file
Hi there
I was wondering I you can send your comments and remarks for this my.cnf
file
o.s. redhat9
tables 20Mb
mem: 8gb
server dedicated to mysql
max_connections=2000/3000
uses only innodb tables
my.cnf
[mysqld]
port= 3306
socket =
I'd up your buffer sizes - the mysql manual has some clues as to setting
these values? You might want to increase the query cache size.
I'd then run it and watch the stats.
Greg
snipped
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
.
- Original Message -
From: nm [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 30, 2003 10:17 AM
Subject: guru needed - large configuration MySQL-Max InnoDB - 4.0.16
Hi there
I was wondering I you can send your comments and remarks for this my.cnf
file
o.s. redhat9
When testing my application code I note that
mysql_query() does not return a non-zero
result when a lock timeout occurs -- the error is detected
when I try to retrieve the result set and get a NULL
value.
However, this finding is not consistent; for example
in one block of code a mysql_query()
Hi
It seems to me that combination from the subject just doesn't work.
Every time I try to incorporate spatial column into Innodb table
Mysql dies. The simplest case, easy to repeat is bellow.
When I'm trying to create table with just one spatial column I'm
getting following error:
mysql
G B U [EMAIL PROTECTED] wrote:
It seems to me that combination from the subject just doesn't work.
Every time I try to incorporate spatial column into Innodb table
Mysql dies. The simplest case, easy to repeat is bellow.
When I'm trying to create table with just one spatial column I'm
At 19:16 +0300 9/29/03, Victoria Reznichenko wrote:
G B U [EMAIL PROTECTED] wrote:
It seems to me that combination from the subject just doesn't work.
Every time I try to incorporate spatial column into Innodb table
Mysql dies. The simplest case, easy to repeat is bellow.
When I'm trying
At 19:16 +0300 9/29/03, Victoria Reznichenko wrote:
G B U [EMAIL PROTECTED] wrote:
It seems to me that combination from the subject just doesn't work.
Every time I try to incorporate spatial column into Innodb table
Mysql dies. The simplest case, easy to repeat is bellow.
When I'm
On Mon, Sep 29, 2003 at 09:33:29PM +0400, G B U wrote:
Hmm... am I missing something?! IIRC there is nothing manual about Innodb
not supporting spatial extensions. And on windows it seems that all is working
fine. This is from my Win2000 box with the same Mysql version:
mysql create table
On Mon, Sep 29, 2003 at 09:33:29PM +0400, G B U wrote:
Hmm... am I missing something?! IIRC there is nothing manual about Innodb
not supporting spatial extensions. And on windows it seems that all is working
fine. This is from my Win2000 box with the same Mysql version:
mysql
At 21:33 +0400 9/29/03, G B U wrote:
At 19:16 +0300 9/29/03, Victoria Reznichenko wrote:
G B U [EMAIL PROTECTED] wrote:
It seems to me that combination from the subject just doesn't work.
Every time I try to incorporate spatial column into Innodb table
Mysql dies. The simplest case
At 22:05 +0400 9/29/03, G B U wrote:
On Mon, Sep 29, 2003 at 09:33:29PM +0400, G B U wrote:
Hmm... am I missing something?! IIRC there is nothing manual about Innodb
not supporting spatial extensions. And on windows it seems that
all is working
fine. This is from my Win2000 box with the
Hi,
Is there any possibility to check existing of autoextend option
for InnoDB ?
I mean by any sql command and not by searching in my.ini file ?
Regards,
Dmitry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
At 16:29 +0300 8/17/03, Dmitry Kosoy wrote:
Hi,
Is there any possibility to check existing of autoextend option
for InnoDB ?
I mean by any sql command and not by searching in my.ini file ?
If you mean you want to find out the setting of the innodb_data_file_path
variable, you can use this
Hello Heikki,
why you do not look with SHOW INNODB STATUS if there are dangling
transactions which could still see the delete-marked rows? Purge cannot
remove them then.
This is what I see:
mysql show table status like 'sccchangelog';
Message -
From: [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, July 03, 2003 10:48 PM
Subject: Re: Unexpected empty table performance problem with MySQL and
InnoDB
Hello Heikki,
why you do not look with SHOW INNODB STATUS if there are dangling
transactions which
in the table in
question, while in reality the table is empty. Restarting the DB forced the purge
list to be either merged on shutdown (with an earlier version of MySQL/InnoDB) or to
start being merged when restarted.
We've looked at the source a little and it seems that the scheduling algorithm
03, 2003 12:10 AM
Subject: Re: Unexpected empty table performance problem with MySQL and
InnoDB
Hi,
I wanted to post a follow-up question to the inquiry below. I've done some
more research since my last post and now think that the performance problem
is related to something other than
Hi,
Hi,
I would like to know if is there a way to delete constraints
without dropping and recreating a table. If there isn't, I would
like to know when do you plan to implement this important feature.
I would also like to see this feature. I have been implementing a new
db
Dyego,
- Original Message -
From: Dyego Souza do Carmo [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 10:42 PM
Subject: The MySQL and InnoDB FK´s
Hi,
I would like to know if is there a way to delete constraints
without dropping
Hi,
I would like to know if is there a way to delete constraints
without dropping and recreating a table. If there isn't, I would
like to know when do you plan to implement this important feature.
Thanks in advance,
sql,query
Hello,
we are starting a new Projekt and we going to use MySQL with InnoDB
Tables.
Which Version of MySQL should we use? 3.23.53 or 4.0.x? Which is the
best Version for InnoDB-Tables?
Thanks for your help,
Stefan Sturm
Stefan,
- Original Message -
From: Stefan Sturm [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Sunday, December 01, 2002 1:33 PM
Subject: MySQL with InnoDB
Hello,
we are starting a new Projekt and we going to use MySQL with InnoDB
Tables.
Which Version of MySQL should
Almost all modern unix type systems come with the powerd daemon.
-Original Message-
From: Jan Steinman [mailto:Jan;Bytesmiths.com]
Sent: Thursday, October 31, 2002 10:46 AM
To: [EMAIL PROTECTED]
Subject: UPS (Was: Mysql in Innodb)
From: gerald_clark [EMAIL PROTECTED]
A UPS
know this question would best suit for
[EMAIL PROTECTED] but there is over limit problem.
E-mail Account: lists-mysql is over the limit of
31457280 bytes.
I am running a Mandrake Linux 8.1, with an rpm
installed ver 3.23.41. Unfortunately configuring the
MySQL for InnoDb for me turned
://www.sayclub.com
NeoWiz http://www.neowiz.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Harald Fuchs
Sent: Tuesday, October 15, 2002 7:03 PM
To: [EMAIL PROTECTED]
Subject: Re: What is the best suited file system for MySQL w/ InnoDB
file system for MySQL w/ InnoDB?
In article
[EMAIL PROTECTED],
Chung Ha-nyung [EMAIL PROTECTED] writes:
I've considered raw filesystem, but it seems a bit
difficult, or even
impossible, to
copy db file to other servers, especially when making replication
slave servers.
Any
grown orchards in there ;-) ).
After restoring the AC, MySql and InnoDb are back to businness !!
As far as I am concerned everithing is running fast and safe an smooth.
Bye
Andrea Forghieri
Andrea,
- Original Message -
From: Andrea Forghieri [EMAIL PROTECTED]
Newsgroups
Among ext3, reiserfs, ext2, and xfs, which one is the best for MySQL
w/ InnoDB?
Since partition size is as small(!) as 60GB, I think that ext2 could
be plausible
choice. But any other journaling filesystem can outperform ext2 in
using MySQL?
--
Chung Ha-nyung alita@[neowiz.com|kldp.org
Andrea,
- Original Message -
From: Andrea Forghieri [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Saturday, October 12, 2002 2:02 AM
Subject: Mysql 4.0.4 + InnoDB leads to corrupted tables ?
Hi,
I recently updated from 4.0.3 do 4.0.4 .
everithing was running fast ans
of
other databases !
I ran myisamchk to check and fix the tables : there where the majority of
the tables
with index probles.
I restarted mysql WITHOUT innodb support, everithing was OK again.
I restarted mysql WITH innodb and I had the most of the tables (especially
the big ones)
corrupted again
Hello,
Recently I have installed MySQL-Max 4.0.3 in my production server, and
in the error log I found the following message (or very similar) several
times:
InnoDB: Assertion failure in thread xxx in file btr0pcur.c line
203
Why takes place this crash?
NOTE: Querys associated to
: mailing.database.mysql
Sent: Monday, September 23, 2002 6:00 PM
Subject: RV: Assertion failure with MySQL 4.0.3/InnoDB
Hello,
Recently I have installed MySQL-Max 4.0.3 in my production server, and
in the error log I found the following message (or very similar) several
times:
InnoDB: Assertion
I am setting up a web site with Linux (redhat 7.1), apache, php and mysql.
I need the version of mysql with innodb support.
Can anyone indicate to me what file or files I need to obtain to install
thecorrect version of mysql and where I can down load them?
Thanks in advance
Regards
Peter
septiembre de 2002 8:41
Para: [EMAIL PROTECTED]
Asunto: Mysql with innodb support
I am setting up a web site with Linux (redhat 7.1), apache, php and mysql.
I need the version of mysql with innodb support.
Can anyone indicate to me what file or files I need to obtain to install
thecorrect version
1 - 100 of 128 matches
Mail list logo