On 10/9/2017 3:27 AM, Xiaoyu Wang wrote:
Hello,I reported a bug, at https://bugs.mysql.com/bug.php?id=87637, as well as
a patch. And Bogdan, the bug hunter, told me this patch would show up on the
dev contribution report. So, could anyone please tell me how to contact dev
team, or how can I
Hello,I reported a bug, at https://bugs.mysql.com/bug.php?id=87637, as well as
a patch. And Bogdan, the bug hunter, told me this patch would show up on the
dev contribution report. So, could anyone please tell me how to contact dev
team, or how can I know the progress about integrating the
Hi, I signed Oracle Contributor Agreement about a month ago, but have not got a
response. I reported a bug, but I can not contribute my patch. So, could anyone
please tell me how long will it take before I am informed? Thanks, sincerely
Hello Steve,
To what list should I post with a post-installation config and startup
question?
This list, the MySQL General Mailing List, is the right place if the
question is about MySQL!
Cheers
--
Claudio
To what list should I post with a post-installation config and startup
question?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
I build from source but find that libmysqlclient_r is merely a symlink to
libmysqlclient. Is that expected?
$ uname -a
Darwin Damien-Kicks-MacBook-Pro.local 12.5.0 Darwin Kernel Version 12.5.0: Sun
Sep 29 13:33:47 PDT 2013; root:xnu-2050.48.12~1/RELEASE_X86_64 x86_64
$ echo $CXX
On 30-07-2013 01:16, Rick James wrote:
Elevator... If the RAID _controller_ does the Elevator stuff, any OS
optimizations are wasted. And there have been benchmarks backing that
up. (Sorry, don't have any links handy.)
RAID 5/10 ... The testing I have done shows very little difference.
2013/7/30 Rick James rja...@yahoo-inc.com
Elevator... If the RAID _controller_ does the Elevator stuff, any OS
optimizations are wasted.
And there have been benchmarks backing that up. (Sorry, don't have any
links handy.)
RAID 5/10 ... The testing I have done shows very little
Hello List,
On two different occasions and on two different servers I have found server
debug information written out to the mysqld.log file.
Now I know that by issuing the kill -1 mysql-pid will write that information to
the mysqld.log file, and by using mysqladmin debug will also write debug
Rick James rja...@yahoo-inc.com wrote:
When writing a random block, RAID-5 does not need to touch all the
drives, only the one with parity. Suitable XORs will update it
correctly. So, a write hits 2 drives, whether you have RAID-5 or -10.
Only if the other blocks happen to be in the cache,
]
Sent: Saturday, July 27, 2013 4:32 AM
To: mysql@lists.mysql.com
Subject: Re: hypothetical question about data storage
On 7/26/2013 6:58 PM, Chris Knipe wrote:
The issue that we have identified is caused by seek time - hundreds of
clients simultaneously searching for a single file
Rick James rja...@yahoo-inc.com wrote:
For MySQL + RAID, a Linux elevator strategy of 'deadline' or 'noop' is
optimal. (The default, 'cfq', is not as good.)
I should look into those again at some point. Do you have a brief word as to
why they're better?
A RAID controller with multiple drives
James; will...@techservsys.com; mysql@lists.mysql.com
Subject: RE: hypothetical question about data storage
Rick James rja...@yahoo-inc.com wrote:
For MySQL + RAID, a Linux elevator strategy of 'deadline' or 'noop' is
optimal. (The default, 'cfq', is not as good.)
I should look into those
On 7/26/2013 6:58 PM, Chris Knipe wrote:
The issue that we have identified is caused by seek time - hundreds of
clients simultaneously searching for a single file. The only real way
to explain this is to run 100 concurrent instances of bonnie++ doing
random read/writes... Your disk utilization
, 2013 11:53:53 PM
Subject: hypothetical question about data storage
Hi all,
We run an VERY io intensive file application service. Currently, our
problem is that our disk spindles are being completely killed due to
insufficient SEEK time on the hard drives (NOT physical read/write
speeds
question about data storage
Hi all,
We run an VERY io intensive file application service. Currently, our
problem is that our disk spindles are being completely killed due to
insufficient SEEK time on the hard drives (NOT physical read/write
speeds).
We have an directory structure where
26, 2013 12:30 AM
To: Johan De Meersman
Cc: mysql
Subject: Re: hypothetical question about data storage
Hi All,
Thanks for the responces, and I do concur. I was taking a stab in the
dark so to speak.
We are working with our hosting providers currently and will be
introducing
-
From: ckn...@savage.za.org [mailto:ckn...@savage.za.org] On Behalf Of
Chris Knipe
Sent: Friday, July 26, 2013 12:30 AM
To: Johan De Meersman
Cc: mysql
Subject: Re: hypothetical question about data storage
Hi All,
Thanks for the responces, and I do concur. I was taking a stab
-
From: ckn...@savage.za.org [mailto:ckn...@savage.za.org] On Behalf Of
Chris Knipe
Sent: Friday, July 26, 2013 12:30 AM
To: Johan De Meersman
Cc: mysql
Subject: Re: hypothetical question about data storage
Hi All,
Thanks for the responces, and I do concur. I was taking a stab in
the
dark
2013/07/27 00:58 +0200, Chris Knipe
I would definately consider the md5 checksum as a
PK (char(32) due to the hex nature),
Well, not that it greatly matters, but you could convert it to BINARY(16).
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi all,
We run an VERY io intensive file application service. Currently, our
problem is that our disk spindles are being completely killed due to
insufficient SEEK time on the hard drives (NOT physical read/write speeds).
We have an directory structure where the files are stored based on the
Hi,
Sorry but mysql is not the address of it , use riak instead of mysql
With riak which is key and value based , all keys are on memory and just
only one seek enough to handle it
Consider to use riak
VM
On 7/26/13 12:53 AM, Chris Knipe sav...@savage.za.org wrote:
Hi all,
We run an VERY io
don't know the exact fields in ibdata1.)
-Original Message-
From: Wayne Leutwyler [mailto:wleut...@columbus.rr.com]
Sent: Monday, February 04, 2013 11:47 AM
To: mysql@lists.mysql.com
Subject: Question about Innodb
Question about InnoDB tables and tablespaces.
I have one file per
For this,
2012/10/04 16:13 +0200, MAS!
IF(GROUP_CONCAT(DISTINCT secA.sec_code SEPARATOR '|') is null,
IF(GROUP_CONCAT(DISTINCT secB.sec_code SEPARATOR '|') is null,
Hi
I know there'd be a reason, but I can't understand that..
mysql select @valore:=rand(), @valore, @valore:=ciao, @valore;
+---+---+-+-+
| @valore:=rand() | @valore | @valore:=ciao | @valore |
Hrm, what version of MySQL? I just ran the query on 5.5.24 and it worked as
expected.
- Derek Downey
On Oct 4, 2012, at 9:52 AM, MAS! wrote:
Hi
I know there'd be a reason, but I can't understand that..
mysql select @valore:=rand(), @valore, @valore:=ciao, @valore;
On 04/10/2012 15:52, MAS! wrote:
Hi
I know there'd be a reason, but I can't understand that..
mysql select @valore:=rand(), @valore, @valore:=ciao, @valore;
+---+---+-+-+
| @valore:=rand() | @valore | @valore:=ciao | @valore
favore non alterare o perturbare la
comunicazione
From: urk...@gmail.com
Subject: (real) silly question about variables...
Date: Thu, 4 Oct 2012 15:52:20 +0200
To: mysql@lists.mysql.com
Hi
I know there'd be a reason, but I can't understand that..
mysql select @valore:=rand(), @valore
what version of MySQL are you running? I get this:-
mysql select version();
+---+
| version() |
+---+
| 5.1.63-0+squeeze1 |
+---+
I'm asking that because I have a trouble with a select..
I have something similar..
SELECT
Am 25.06.2012 06:17, schrieb Sabika Makhdoom:
I want to test our memcmp() binaries to see if we have the mysql binaries
that are impacted by the recent security breach. How do I test it?
why do you simply not update?
signature.asc
Description: OpenPGP digital signature
Subject: Question about testing memcmp()
I want to test our memcmp() binaries to see if we have the mysql binaries that
are impacted by the recent security breach. How do I test it?
Thanks
Life was meant to be mobile
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
I want to test our memcmp() binaries to see if we have the mysql binaries that
are impacted by the recent security breach. How do I test it?
Thanks
Life was meant to be mobile
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hello,
Y read this message: http://lists.mysql.com/mysql/109590 and I would like
to ask for authorization but I don´t see the email address in that thread
(it says: sales@stripped).
Can someone tell me that email address?.
Thanks in advance.
Claudia.
Hello Claudia,
On 6/18/2012 2:13 PM, Claudia Murialdo wrote:
Hello,
Y read this message: http://lists.mysql.com/mysql/109590 and I would like
to ask for authorization but I don´t see the email address in that thread
(it says: sales@stripped).
Can someone tell me that email address?.
Thanks in
If you own the code, you can license it under multiple licenses.
Kind of like if you own a TV Show, you can license it in the US under one
contract, and in other geographies under other more or less restrictive
contracts.
This is a painful reality to those of us in Canada, as we can't watch
And in europe we cannot watch all the american TV Series online :(
2012/4/11 Paul Vallee val...@pythian.com
If you own the code, you can license it under multiple licenses.
Kind of like if you own a TV Show, you can license it in the US under one
contract, and in other geographies under
...@pythian.com
Cc: James Ots my...@jamesots.com; mysql@lists.mysql.com
Sent: Wednesday, April 11, 2012 10:53 AM
Subject: Re: Licensing question about mysql_com.h
And in europe we cannot watch all the american TV Series online :(
2012/4/11 Paul Vallee val...@pythian.com
If you own the code, you can
GPL v2 Section 2 clause b:
You must cause any work that you distribute or publish, that in
whole or in part contains or is derived from the Program or any
part thereof, to be licensed as a whole at no charge to all third
parties under the terms of this License.
From my reading of
In their blog post, announcing the sharing of their work, they mention
licensing it under BSD, but in the repository the COPYING file still
contains the GPLv2 licence, so I'm not sure what's going on there.
On 10 April 2012 02:32, Andrew Moore eroomy...@gmail.com wrote:
So what's the deal with
I don't think I can use a linking exception when I license my code, as
the GPL says I must license my code with the same licence that the
original code used.
James Ots
On 8 April 2012 00:52, Michael Dykman mdyk...@gmail.com wrote:
Not quite true. Your driver would likely have to be published
Your code might not qualify for the linking excepetion, but users of
your code can use the inking exception to licence their product
however they choose.
- michael dykman
On Mon, Apr 9, 2012 at 2:43 PM, James Ots my...@jamesots.com wrote:
I don't think I can use a linking exception when I
So what's the deal with Twitter's mysql code...how can it be BSD licensed?
I'm a bit unsure about the intricacies of licensing.
A
On Tue, Apr 10, 2012 at 1:19 AM, Michael Dykman mdyk...@gmail.com wrote:
Your code might not qualify for the linking excepetion, but users of
your code can use the
I am writing a MySQL connector for the Dart programming language. I
was hoping to licence it under the BSD Licence, but since it uses
modified parts of mysql_com.h, which is licensed under the GPL, I'm
guessing that I'll have to licence my connector under the GPL as well?
And therefore, anyone who
Not quite true. Your driver would likely have to be published under
GPL but that allows the linking exception which allows users of your
driver to avoid having to open-source their own works which utilize
the driver.Should someone decide to code bug fixes or extensions
for your driver, those
Does drop table use the undo log (rollback segment) to temporarily store
records to be purged later, the way delete from table does?
As 'DROP TABLE' causes an implicit commit
(http://dev.mysql.com/doc/refman/5.5/en/implicit-commit.html), I would highly
suspect that it doesnt. You cannot roll
I am trying to install mysql 5.1.59 on my ppc running os x and I get this
error message in the term.c file.
cc1: warnings being treated as errors
term.c: In function ‘term_set’:
term.c:946: warning: passing argument 1 of ‘tgetflag’ discards qualifiers
from pointer target type
term.c:947: warning:
I can't help directly with the error message (the warning seems fairly
harmless), but may I inquire why you are building MySQL instead of using one
of the prepared binaries? Compiling under OS/X can be pretty harrowing.
- michael dykman
On Sat, Oct 8, 2011 at 2:49 AM, Peter Schrock
I can understand your point, however, as stated, I am using a ppc
architecture and am not afforded the luxury of binaries in the most up to
date versions. I know using 5.1.59 isn't the most up to date, but I was also
having issues with the most current version. I might start with the most
current
The server hosting bacula and the database only has one kind of disk: SATA,
maybe I should buy a couple of SSD for mysql.
I have read all your mails, and still not sure if I should enable innodb
compression. My ibfile is 50 GB, though.
Regards
Maria
Questions:
1) Why are you putting
Am 14.09.2011 09:50, schrieb Maria Arrea:
I have read all your mails, and still not sure if I should enable innodb
compression
if you have enough free cpu-ressources and IO is your problem simply yes
because the transfer from/to disk will be not so high as uncompressed
signature.asc
| |
+++-++---++-+-+--+---++-+-+-+---+--+-+-+
I am still benchmarking, but I see a 15-20% performance gain after enabling
compression using bacula gui (bat).
Regards
Maria
- Original Message -
From: Maria Arrea
Sent: 09/14/11 09:50 AM
To: mysql@lists.mysql.com
Subject: Re: Question about slow storage and InnoDB
Am 14.09.2011 14:50, schrieb Maria Arrea:
I have finally enabled compression:
I am still benchmarking, but I see a 15-20% performance gain after enabling
compression using bacula gui
as expected if disk-io is the only bottenleck
the same with NTFS-Compression inside a VMware Machine on
compression using bacula gui (bat).
Regards
Maria
- Original Message -
From: Maria Arrea
Sent: 09/14/11 09:50 AM
To: mysql@lists.mysql.com
Subject: Re: Question about slow storage and InnoDB compression
The server hosting bacula and the database only has one kind of disk:
SATA, maybe I
Hello
I have upgraded our backup server from mysql 5.0.77 to mysql 5.5.15. We are
using bacula as backup software, and all the info from backups is stored in a
mysql database. Today I have upgraded from mysql 5.0 to 5.5 using IUS
repository RPMS and with mysql_upgrade procedure, no problem so
I would recommend to go for a 15K rpm SSD raid-10 to keep the mysql data and
add the Barracuda file format with innodb file per table settings, 3 to 4 GB
of innodb buffer pool depending the ratio of myisam v/s innodb in your db.
Check the current stats and reduce the tmp and heap table size to a
Thanks for correcting me in the disk stats Singer, A typo error of SSD
instead of SAS 15k rpm.
Compression may not increase the memory requirements :
To minimize I/O and to reduce the need to uncompress a page, at times the
buffer pool contains both the compressed and uncompressed form of a
Subject: Re: Question about Backup
Forget mysqldump because TABLE LOCKS for so hughe databases
I would setup a replication-slave because you can stop
the salave and make a filesystem-backup of the whole db-folder
while the production server is online, we do this with our
dbmail-server since
that the database is one table of 5.000 gigabyte, and not
5.000 tables of one gigabyte; and that the backup needs to be consistent :-p
- Original Message -
From: Reindl Harald h.rei...@thelounge.net
To: mysql@lists.mysql.com
Sent: Monday, 21 March, 2011 12:44:08 PM
Subject: Re: Question about
Message -
From: Reindl Harald h.rei...@thelounge.net
To: mysql@lists.mysql.com
Sent: Monday, 21 March, 2011 12:44:08 PM
Subject: Re: Question about Backup
Forget mysqldump because TABLE LOCKS for so hughe databases
I would setup a replication-slave because you can stop
the salave and make
Hi
I need set up a backup strategy for a mysql database in a ubuntu server,
the database will grow up to a 5TB.
What would be the best option ?? Maybe a script that uses mysqldump?? There
is a better way to do this?
Thanks in advance to all
Pedro.
Forget mysqldump because TABLE LOCKS for so hughe databases
I would setup a replication-slave because you can stop
the salave and make a filesystem-backup of the whole db-folder
while the production server is online, we do this with our
dbmail-server since 2009
Am 21.03.2011 12:23, schrieb Pedro
Hi,
The statement like 'I need to back up a 5T database' is not a backup strategy.
It is intention. There are some specifics that have to be determined to work
out a strategy. Going from there, the backup solution can be chosen. The
examples of questions one typically asks when
That would be the last question :-) Suppose we worked out strategy, lined up
the solutions along with their costs and then compare them with our budget.
That would be easy to find the one we can afford, and we will know what we
could dream about :-).
On Mar 21, 2011, at 11:28 AM, Singer
Or you can interrupt the query instead, although I've seen it not to
work on occasions: KILL QUERY id;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hi all;
I wonder if there is any tool to Performance Tuning querys. In other know if
there is any way to kill connections that take x hours dead (for example 1
hour)
--
Mit forever
My Blog http://www.redcloverbi.wordpress.com
My Faborite
from the mysql console: show processlist
this will show you ids of all active connections, even the dead ones
then, again form the console kill processid
On Thu, Feb 17, 2011 at 3:52 PM, Rafael Valenzuela rav...@gmail.com wrote:
Hi all;
I wonder if there is any tool to Performance Tuning
Hi Michael:
Yeah , i think that i do a shell script.something like that.
require 'mysql'
mysql = Mysql.new(ip, user, pass)
processlist = mysql.query(show full processlist)
killed = 0
processlist.each { | process |
mysql.query(KILL #{process[0].to_i})
}
puts
Rafael,
You realize that script will kill perfectly well-behaved queries in
mid-flight? If you have so many dead connections that it is interfering
with operation, you have another problem elsewhere..
- md
On Thu, Feb 17, 2011 at 4:16 PM, Rafael Valenzuela rav...@gmail.com wrote:
Hi
I am working with mysql since many yaers and i have never
found e reason to kill braindead connections - what
benefit do you think to have from such actions instead
looking why there are hanging ones?
kill a connection of postfix and some user gets
temorary lookup error, php-scripts are closing
So, a problem popped up today that has caused us no end of hair-pulling, and
it brought to mind a similar issue that I found very, well, wrong.
If you have a table defined:
CREATE TABLE `tester_table` (
`acnt`varchar(20) NOT NULL DEFAULT '',
`method` varchar(10) NOT
Are you using the strict SQL mode? Check your my.cnf file.
Peter
Date: Fri, 4 Feb 2011 14:08:01 -0800
From: awall...@ihouseweb.com
To: mysql@lists.mysql.com
Subject: Question about database value checking
So, a problem popped up today that has caused us no end of hair-pulling
Thanks Peter, exactly what I was hoping for!
andy
On 2/4/11 3:11 PM, Peter He wrote:
Are you using the strict SQL mode? Check your my.cnf file.
Peter
Date: Fri, 4 Feb 2011 14:08:01 -0800
From: awall...@ihouseweb.com
To: mysql@lists.mysql.com
Subject: Question about database value checking
From the OP:
I have a copy of the INNODB files for these two tables - is there a way
to extract the table contents from these files short of a full import?
I have to agree, that's quite ambiguous. Andy, is it a copy of the innoDB
datafiles, or a database dump that you have ?
In the latter
If you just need specific records, you can use -w option of mysql to
extract only the specifc records.
Then you can run the dump file into another db.
regards
anandkl
On Fri, Nov 12, 2010 at 2:35 PM, Johan De Meersman vegiv...@tuxera.bewrote:
From the OP:
I have a copy of the INNODB files
Thanks, guys. I have copies of the innodb files. The boss went whole hog on
using zfs for everything, so backups of files are readily available. Looks
like I'll be having the db reconstituted...
thanks again
On 11/12/10 1:05 AM, Johan De Meersman wrote:
From the OP:
I have a copy of the
Cc: Gavin Towey; Andy Wallace; mysql list
Subject: Re: question about restoring...
On Tue, Nov 9, 2010 at 11:39 PM, Jerry Schwartz je...@gii.co.jp wrote:
Then I guess it's a matter of preference. I'd rather edit a text file than
build a new instance of MySQL.
The way I parse that, you're
So, I got a request this morning to recover some specific records for
a client. I just want a handful of records from a couple of tables here.
I have a copy of the INNODB files for these two tables - is there a way
to extract the table contents from these files short of a full import?
thanks,
No, you should import the data into another instance of mysql to extract the
records.
Regards,
Gavin Towey
-Original Message-
From: Andy Wallace [mailto:awall...@ihouseweb.com]
Sent: Tuesday, November 09, 2010 10:34 AM
To: mysql list
Subject: question about restoring...
So, I got
Not if he has the raw innodb files.
-Original Message-
From: Jerry Schwartz [mailto:je...@gii.co.jp]
Sent: Tuesday, November 09, 2010 11:05 AM
To: Gavin Towey; 'Andy Wallace'; 'mysql list'
Subject: RE: question about restoring...
That's overkill.
You should be able to import the data
about restoring...
Not if he has the raw innodb files.
-Original Message-
From: Jerry Schwartz [mailto:je...@gii.co.jp]
Sent: Tuesday, November 09, 2010 11:05 AM
To: Gavin Towey; 'Andy Wallace'; 'mysql list'
Subject: RE: question about restoring...
That's overkill.
You should be able
On Tue, Nov 9, 2010 at 11:39 PM, Jerry Schwartz je...@gii.co.jp wrote:
Then I guess it's a matter of preference. I'd rather edit a text file than
build a new instance of MySQL.
The way I parse that, you're saying that there is a way to reattach ibd
files to another database ?
--
Bier met
On 03/09/2010 9:27 p, Hank wrote:
On 02/09/2010 8:30 p, Hank wrote:
Simple question about views:
Hank,
Have you tried running away from the problem :-) by doing...
CREATE PROCEDURE `combo`(theid INT)
BEGIN
(SELECT * FROM table1 WHERE id = theid)
UNION
(SELECT * FROM
On 03/09/2010 9:26 p, Hank wrote:
On Fri, Sep 3, 2010 at 6:23 AM, Jangitajang...@jangita.com wrote:
On 02/09/2010 8:30 p, Hank wrote:
Simple question about views:
Hank,
Have you tried running away from the problem :-) by doing...
CREATE PROCEDURE `combo`(theid INT)
BEGIN
(SELECT
On 02/09/2010 8:30 p, Hank wrote:
Simple question about views:
I have a view such as:
create view combo as
select * from table1
union
select * from table2;
Where table1 and table2 are very large and identical and have a
non-unique key on field id
On 9/3/2010 6:23 AM, Jangita wrote:
On 02/09/2010 8:30 p, Hank wrote:
Simple question about views:
I have a view such as:
create view combo as
select * from table1
union
select * from table2;
...
(I've also tried UNION ALL with the same results
On 02/09/2010 8:30 p, Hank wrote:
Simple question about views:
Hank,
Have you tried running away from the problem :-) by doing...
CREATE PROCEDURE `combo`(theid INT)
BEGIN
(SELECT * FROM table1 WHERE id = theid)
UNION
(SELECT * FROM table2 WHERE id = theid
Simple question about views:
I have a view such as:
create view combo as
select * from table1
union
select * from table2;
Where table1 and table2 are very large and identical and have a
non-unique key on field id..
when I do a:
select * from combo where id
Hey you all,
I'm messing about with various settings and parsing the documentation, and
my naughty mind saw something that's not very clear in the docs:
The InnoDB autoincrement
dochttp://dev.mysql.com/doc/refman/5.1/en/innodb-auto-increment-handling.htmlstates
that innodb_autoinc_lock_mode
= 2
only once for all the rows deleted.
regards
anandkl
On Thu, Mar 18, 2010 at 1:21 AM, Price, Randall randall.pr...@vt.edu
wrote:
Hello,
I have a simple question about deleting records from INNODB tables. I
have
a master table with a few child tables linked via Foreign Key
constraints
] On Behalf Of Johan De
Meersman
Sent: Thursday, March 18, 2010 6:48 AM
To: Ananda Kumar
Cc: Price, Randall; [MySQL]
Subject: Re: Question about DELETE
Given that OP is talking about a single delete statement, I'm gonna be very
surprised if he manages to squeeze an intermediate commit
is happening multiple times?
Thanks,
-Randall Price
From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
Meersman
Sent: Thursday, March 18, 2010 6:48 AM
To: Ananda Kumar
Cc: Price, Randall; [MySQL]
Subject: Re: Question about DELETE
Given that OP is talking about
: Thursday, March 18, 2010 10:11 AM
To: Price, Randall
Cc: Johan De Meersman; Ananda Kumar; [MySQL]
Subject: RE: Question about DELETE
Hi Randall,
If you're talking about processes that are taking that long, then
running SHOW PROCESSLIST several times during the operation should give
you a rough idea
-Original Message-
From: Ian Simpson [mailto:i...@it.myjobgroup.co.uk]
Sent: Thursday, March 18, 2010 10:11 AM
To: Price, Randall
Cc: Johan De Meersman; Ananda Kumar; [MySQL]
Subject: RE: Question about DELETE
Hi Randall,
If you're talking about processes that are taking that long
: Thursday, March 18, 2010 11:15 AM
To: Price, Randall
Cc: Ian Simpson; Johan De Meersman; [MySQL]
Subject: Re: Question about DELETE
delete will also cause the undo(before image) to be generated, in case u want
to rollback. This will also add up to the delete completion time.
After each mass delete
Hello,
I have a simple question about deleting records from INNODB tables. I have a
master table with a few child tables linked via Foreign Key constraints. Each
table has several indexes as well.
My question is: if I delete many records in a single delete statement (i.e.,
DELETE FROM
AM, Price, Randall randall.pr...@vt.eduwrote:
Hello,
I have a simple question about deleting records from INNODB tables. I have
a master table with a few child tables linked via Foreign Key constraints.
Each table has several indexes as well.
My question is: if I delete many records
Regards,
Gavin Towey
-Original Message-
From: Banyan He [mailto:ban...@rootong.com]
Sent: Friday, August 07, 2009 11:12 AM
To: Gavin Towey; joerg.bru...@sun.com; Peter Chacko
Cc: mysql
Subject: Re: Question about MySQL
Hi Gavin,
I am interested in the things you made for the optimization. Can
Hi all!
First of all, please excuse the typo I made in my posting.
I had written
There may be some merit to this in a specialized setup (NAS systems -
I'm not convinced of them, but don't claim expert knowledge about them),
and of course meant SAN, not NAS systems.
As regards NFS:
Peter
Hi Peter, all,
let me just concentrate on the NFS aspect:
Peter Chacko wrote:
[[...]]
Another question is , whats the general experience of running MySQL
servers on NFS shares ?
I would *never* use NFS storage for any DBMS (except for some testing):
NFS access is slower than local disk
Hi Jorg,
I really appreciate your help sharing your experience/thoughts.
Yes, i fully concur with you, NFS is not designed for Databases. But
you know there are Distributed SAN file systems (that use Direct IO to
the SAN) are serving databases like DB2 in many installations for
shared
1 - 100 of 697 matches
Mail list logo