Hi all,
I'm happy to announce updates to two of Percona's suites of free (GPL)
tools for MySQL.
Percona Toolkit versions 2.0.5 and 2.1.2 are released. These are
bug-fix releases in the 2.0 and 2.1 series, respectively. These
releases fix many dozens of bugs, and we suggest that users upgrade to
Ultimately, if you intend to use MyISAM, you must keep in mind that it
eliminates some of your options. One problem is that MyISAM is very
slow to repair after a crash. Remember, if a crash can happen, it
eventually will, it's just a question of when. And MyISAM doesn't have
recovery -- it only
Yeah -- that was an unintentional omission. There are solo consultants
like Ronald Bradford too.
On Mon, Jun 11, 2012 at 3:14 PM, Andrew Moore eroomy...@gmail.com wrote:
Not forgetting Pythian, Baron ;)
On Mon, Jun 11, 2012 at 8:12 PM, Baron Schwartz ba...@xaprb.com wrote:
Ultimately, if you
There is also libdrizzle.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
In this case the solution is much easier outside of MySQL than inside.
http://ocaoimh.ie/wp-super-cache/ is an excellent option.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Don,
It is a little hard for me to comment on the query because I don't
have the context I need. When I tackle problems like this I ignore the
query and ask what are you trying to DO? The queries you sent look
like tunnel vision to me; there is probably a better way to do what
you're trying to
In regards to why the file grows large, you may wish to read some of
the posts on the MySQL Performance Blog, which has quite a bit of
information on this, such as
http://www.mysqlperformanceblog.com/2010/06/10/reasons-for-run-away-main-innodb-tablespace/
--
MySQL General Mailing List
For list
I would work from the inside out. What you're doing is grouping scenes
by DVD and throwing away the ones that have no scenes. If you start
with DVDs and do a subquery for each row, you'll process DVDs without
scenes and then filter them out. If you start with a subquery that's
grouped by DVD ID,
Argh. I meant to send this to the list but it doesn't have the
reply-to set as I expect... the usual gripe
On Mon, May 14, 2012 at 10:46 AM, Baron Schwartz ba...@xaprb.com wrote:
Johan,
On Mon, May 14, 2012 at 9:27 AM, Johan De Meersman vegiv...@tuxera.be wrote:
What I fail to understand
that it takes time, sometives
over 15 minutes, but they always resolve...
How Can I tell mysql to wait for the lock as needed? like for over 12
minutes?
TIA
--
Baron Schwartz
Author, High Performance MySQL
http://www.xaprb.com/
--
MySQL General Mailing List
For list archives: http
Andres,
On Fri, May 11, 2012 at 1:48 PM, Andrés Tello mr.crip...@gmail.com wrote:
Ok, so I had a deadlock...
But then, why a deadlock doesn't rollback all the transaccion?
Because it can be resolved by rolling back just one of them. Why
destroy ALL the work people are trying to accomplish, if
Hi,
D.1.1. Changes in MySQL 5.1.63 (7th May, 2012)
Bugs Fixed
* Security Fix: Bug #64884 was fixed.
* Security Fix: Bug #59387 was fixed.
Anyone want to elaborate on the nature or severity of the security
problem? Both are private / inaccessible to me.
--
MySQL General Mailing
I'll present a free webinar today about troubleshooting intermittent
MySQL problems. These are often hard to pin down because they happen
when you're not looking, so you can't reliably determine the symptoms
or the cause. I've created some free tools (part of Percona Toolkit)
to make this process
this error.
But, I'm hoping you guys can offer a work-around it without me
resorting to duplicate the entire while loop she-bang.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
--
Baron Schwartz
Win free MySQL
If you were not at the Percona Live MySQL Conference over the last few
days, the keynote videos are recorded for your convenience. You can
see them at http://www.percona.tv/
Presentations will be posted at http://www.percona.com/live/ as well,
after the speakers submit them to us for posting. I
This year's MySQL conference is hosted by Percona and takes place next
week in Santa Clara, CA. There is a day of tutorials from experts in
MySQL, followed by 2 days of keynotes, conference sessions, networking
events, receptions, birds-of-a-feather sessions, and much more. The
conference has 8
to try out the new server for feedback.
Please go to www.paralleluniverse-inc.com to download.
Thank you,
Hiromichi
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
--
Baron Schwartz
Win free MySQL conference
table between to two mysql
instances.
In other words, I wouild like to copy mysql.user from mysql-inst1 to
mysql-inst2 +
--
Baron Schwartz
Win free MySQL conference tickets! http://goo.gl/mvZ4W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
have any ideas for why this is happening?
Thanks,
Simon
--
Baron Schwartz
Win free MySQL conference tickets! http://goo.gl/mvZ4W
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
remaining tables as I not able to backup corruted tables.
Thanks in advance
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
--
Baron Schwartz
Win free MySQL conference tickets! http://goo.gl/mvZ4W
--
MySQL
Probably someday, but no plans yet.
On Thu, Mar 15, 2012 at 7:37 AM, Johan De Meersman vegiv...@tuxera.be wrote:
- Original Message -
From: Baron Schwartz ba...@xaprb.com
If you want to go to this year's MySQL conference like all the cool
kids, now's your chance. Percona is giving
= _import_products.ProductWidth;
SET ps4_products.ProductHeight = _import_products.ProductHeight;
SET ps4_products.ProductLength = _import_products.ProductLength;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
--
Baron
If you want to go to this year's MySQL conference like all the cool
kids, now's your chance. Percona is giving away free tickets (and free
books)! Details here:
http://www.mysqlperformanceblog.com/2012/03/14/win-free-mysql-conference-tickets/
--
MySQL General Mailing List
For list archives:
/mysql
To unsubscribe: http://lists.mysql.com/mysql
--
Baron Schwartz
Percona Inc http://www.percona.com/
Consulting, Training, Support Services for MySQL
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
It sounds like you've been handed a mandate that's difficult to
understand, but it could be because I don't understand the context, or
you may not understand your manager's real intention. In any case,
everyone is doing clustering is certainly not accurate. And every
clustering technology is
You may be interested in this:
http://www.mysqlperformanceblog.com/2009/09/28/how-number-of-columns-affects-performance/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Hi,
If its an IO problem the first and easiest thing to do is (probably) look at
your disk subsystem. You can easily achieve higher disk IO by increasing the
number of disks and implementing something like RAID1+0.
Or you can be logical about it and try to determine whether the IO
performance
Hi,
On Mon, Sep 20, 2010 at 4:59 AM, Tompkins Neil
neil.tompk...@googlemail.com wrote:
Any ideas why my statement like SELECT SHA1('abc') AS my_sha is being
returned as binary value, I thought it should be returning HEX in anycase ?
Maybe because that's what it's intended to do.
file? Just want to make sure all of the kinds
of inserts, updates, selects and deletes work just as well on the 5.5 box, esp
since we are turning on replication and copying tables from another server
onto
this server. Any ideas please?
TIA...
Nunzio
--
Baron Schwartz
Percona Inc
.
Actually, these transactions run fast on my master.
*^_^*
--
Baron Schwartz
Percona Inc http://www.percona.com/
Consulting, Training, Support Services for MySQL
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Hi Geoff,
This server has 6GB of RAM and no swap. According to some reasearch I was
doing I found this formula for calculating memory size:
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections =
(in your case) 384M + (64M + 2M)*1000 = 66384M
That come directly from this
it on a
Slave server mytop works,
but when I install it on a Master Server don't works, don't display the
queries.
I use mysql version 5.0.77
and linux mandriva 2010.1
Very Thanks
Carlos Caldi - DBA
--
Baron Schwartz
Percona Inc http://www.percona.com/
Consulting, Training, Support
Shawn,
On Mon, Aug 2, 2010 at 4:42 PM, Shawn Green (MySQL)
shawn.l.gr...@oracle.com wrote:
On 8/2/2010 3:39 PM, Daevid Vincent wrote:
And now I just got yet another email for a different bug from 2008!!
What's
going on here?
BTW, this bug is super annoying! How sad that in FOUR YEARS AND
://lists.mysql.com/mysql?unsub=ba...@xaprb.com
--
Baron Schwartz
Percona Inc http://www.percona.com/
Consulting, Training, Support Services for MySQL
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Tim,
What you have described is really a queue, although you are not seeing
it from that angle. This is a very common pattern in this kind of
usage. It's also tricky to make it correct (as you have discovered),
and both performance and scalability are problems in most
implementations.
A
Steven,
On Wed, Jun 16, 2010 at 9:09 AM, Steven Staples sstap...@mnsi.net wrote:
Baron,
Out of curiosity, do you (or anyone else) know what could be an issue with
upgrading to even 5.0.93? or even the 5.1 branch?
There are a lot of stored procedures/functions, as well as the fact that it
Steven,
On Tue, Jun 1, 2010 at 11:15 AM, Steven Staples sstap...@mnsi.net wrote:
Hello all
I have a stored procedure that probably does a lot more than it should, but
it works fine on my test server (which is running 5.0.67). When I moved it
over to the production server, (which is running
Jerry,
On Wed, May 26, 2010 at 5:13 PM, Jerry Schwartz je...@gii.co.jp wrote:
I have a pretty simple query that seems to take a lot longer than it ought to
(over 2 minutes).
I suspect that if you watch Handler_ stats, you'll find that the
EXPLAIN estimate is wrong for some reason and it's
Machiel,
I'm going to disagree strongly with the previous advice you got. You
should NOT configure the buffer pool to be larger than the amount of
RAM you have. If part of the buffer pool is swapped out, then
swapping it back in is MUCH worse than re-fetching the page. InnoDB
doesn't know the
To unsubscribe:
http://lists.mysql.com/mysql?unsub=yuzhih...@gmail.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=ba...@xaprb.com
--
Baron Schwartz
Percona Inc http://www.percona.com/
Consulting
for the assistance.
--
Regards,
Chris Knipe
--
Baron Schwartz
Percona Inc http://www.percona.com/
Consulting, Training, Support Services for MySQL
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch
250 visits etc
Cheers
Neil
--
Baron Schwartz
Percona Inc http://www.percona.com/
Consulting, Training, Support Services for MySQL
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
is taking 1-2 sec. to execute and after profiling the query, I
found query is taking 90-95% time in statistics state. Please let me know
what I am doing wrong.
-Dheeraj
--
Baron Schwartz
Percona Inc http://www.percona.com/
Consulting, Training, Support Services for MySQL
--
MySQL General
Hello,
On Wed, Feb 24, 2010 at 10:11 AM, Yang Zhang yanghates...@gmail.com wrote:
I have the following query. Note that the nested query has no
dependencies on the outer one, yet mysql reports it as dependent.
Do an EXPLAIN EXTENDED followed by SHOW WARNINGS. You will see the
optimization
Bryan,
On Tue, Feb 23, 2010 at 6:09 PM, Cantwell, Bryan
bcantw...@firescope.com wrote:
Ya, that one is helpful... just trying to land on a solution like I've seen
in other DB's that have index-advisor that listens and creates what it thinks
is the perfect indexes ... but thx...
I know
Hi,
On Mon, Feb 22, 2010 at 10:40 AM, Johan De Meersman vegiv...@tuxera.be wrote:
I don't think using a dot is a good idea - that's the table.field separator.
Right. Even if mysqld didn't complain about the directory name, just
try using a '.' character in an identifier. It's a syntax error,
Hi,
On Sun, Feb 21, 2010 at 1:42 PM, mos mo...@fastmail.fm wrote:
I am loading 35 million rows of data into an empty MyISAM table. This table
has 1 primary key (AutoInc) and 1 unique index and 2 non-unique indexes.
Is it going to be any faster if I remove the indexes from the table before
[snip]
Is there a simple function or method to compare a value in a column to
one or more items in a comma separated list?
[/snip]
Take a look at SUBSTRING_INDEX and related string functions.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Andy,
On Tue, Feb 9, 2010 at 10:27 AM, andy knasinski a...@nrgsoft.com wrote:
I've used the general and slow query log in the past, but I am trying to
track down some queries from a compiled app that never seem to be hitting
the DB server.
My guess is that the SQL syntax is bad and never get
?unsub=ba...@xaprb.com
--
Baron Schwartz
Percona Inc: Services and Support for MySQL
http://www.percona.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
WHERE
Stock.ProductID = 1 AND Stock.SizeID = 2;
10) Session 2: COMMIT;
Regards,
Johan Machielse
Machielse Software
http://www.machielsesoftware.nl
--
Baron Schwartz
Percona Inc: Services and Support for MySQL
http://www.percona.com/
--
MySQL General Mailing List
For list archives: http
Matt,
On Thu, Jan 7, 2010 at 3:10 PM, Matt Neimeyer m...@neimeyer.org wrote:
What's the best way to select names at random from this but still take
into account frequency of use?
Here's the link I usually send clients:
http://jan.kneschke.de/projects/mysql/order-by-rand/
--
Baron Schwartz
the other tables for the shopping
cart?
It will not matter at all. But it would be better to choose a
different design. Instead of adding a table per cart, just create a
table and add a row(s) to it for every cart. This is what relational
databases were designed for :-)
Regards
Baron
--
Baron
create a new database
so as to not make a mess of the main database.
You fundamentally misunderstand relational database design. I suggest
reading this book:
http://www.xaprb.com/blog/2009/08/22/a-review-of-beginning-database-design-by-clare-churcher/
Regards,
Baron
--
Baron Schwartz
Percona Inc
applications cannot simply let a dumb
intermediate layer handle it for them, because there are always cases
when lag is not permissible at all, mixed with cases where lag is OK,
and the application needs to make the decision.
--
Baron Schwartz
Percona Inc: Services and Support for MySQL
http
mycolumn;
I know what you're talking about. It doesn't exist in MySQL and I
would not expect it to be added soon. (Probably not ever, but that's
just a guess.)
- Baron
--
Baron Schwartz
Percona Inc: Services and Support for MySQL
http://www.percona.com/
--
MySQL General Mailing List
For list
out of
the box. As previous posters have noted, you generally have to build
something on top of other tools.
- Baron
--
Baron Schwartz
Percona Inc: Services and Support for MySQL
http://www.percona.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Lukas,
If you can't get innodb_force_recovery to work, then you might have to
try to recover the data with these tools:
http://code.google.com/p/innodb-tools/
Regards
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi Eric,
At least with Maatkit, you get transparency. We make a concerted
effort to update the RISKS section of each tool with each release, so
there
is full disclosure.
Fair enough, but I still found the warnings a little too scary. A more
complete explanation of the exact nature of the
Eric,
There are ways to resync data that don't involve all
this as well: Maatkit has some tools
I've looked with great interest at Maatkit, but their tools are replete
with warnings about dangers, bugs, and crashes. They certainly do not
inspire confidence.
I'm the primary author of
.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=ba...@xaprb.com
--
Baron Schwartz, Director of Consulting, Percona Inc.
Our Blog: http://www.mysqlperformanceblog.com/
Our Services: http://www.percona.com
Hi Tim,
On Mon, Jun 22, 2009 at 4:41 PM, Little,
Timothytlit...@thomaspublishing.com wrote:
We have a 20 gig db (that includes the MYIs and MYDs and FRMs).
We are wondering how long LVM snapshots take.. in that how long might
the DB be read-locked? Do we have to read-lock it and flush
=eric.ber...@gmail.com
--
Eric Bergen
eric.ber...@gmail.com
http://www.ebergen.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=ba...@xaprb.com
--
Baron Schwartz, Director of Consulting, Percona
[JS] I strongly suspect that MySQL, like any other random access, variable
record length scheme, would find it easier to manage the internal layout of
separate files. The rows would tend more to be of similar sizes, leading to
less obnoxious fragmentation, and the files themselves would be
wrote:
Hi,
Does the use of innodb_file_per_table option imply a performance cost ?
Compared to default: all InnoDB indexes are in ibdataX file(s).
Thanks
--
Sébastien Moretti
--
Baron Schwartz, Director of Consulting, Percona Inc.
Our Blog: http://www.mysqlperformanceblog.com/
Our Services
/ recommended way to achieve this.
Thanks
Neil
--
Baron Schwartz, Director of Consulting, Percona Inc.
Our Blog: http://www.mysqlperformanceblog.com/
Our Services: http://www.percona.com/services.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Simon,
On Wed, May 27, 2009 at 11:23 AM, Simon J Mudd sjm...@pobox.com wrote:
per...@elem.com (Perrin Harkins) writes:
On Wed, May 27, 2009 at 6:43 AM, Simon J Mudd sjm...@pobox.com wrote:
So is the format of the DELETE FROM .. WHERE ... IN ( ... ) clause I
propose valid and SHOULD the
could give me some information, or point me to some good
documentation, It would be much appreciated.
Thanks,
--Walt
--
Baron Schwartz, Director of Consulting, Percona Inc.
Our Blog: http://www.mysqlperformanceblog.com/
Our Services: http://www.percona.com/services.html
--
MySQL General
On Sun, May 10, 2009 at 10:12 PM, Moon's Father
yueliangdao0...@gmail.com wrote:
Hi.
MySQL only has one datatype called bit, but its smallest storage is one
byte.
How to save a bit on disk, but not a byte?
In some cases, CHAR(0) NULL can actually use one bit on disk. You
either store the
Hi,
On Tue, Apr 28, 2009 at 1:04 PM, Rolando Edwards
redwa...@logicworks.net wrote:
Make sure the tables that the information_schema are not locked.
This is because MyISAM tables, that are constantly being inserted into (Each
insert, update, delete on a MyISAM table does a table lock), must
So, how it's possible to replicate one specific db? I have 4 db's writing
into binlog. I need only one of them at client site. After the successful
setup of the replication I get errors on client site like no such table, no
such database etc...
On the slave side, use
I would stay away from any of the do-db or ignore-db settings.
Can you explain, why?
They are dangerous. Search the list archives, I wrote a diatribe
about it a while back.
Cheers
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I would not compare binlog positions. I would use mk-heartbeat from
Maatkit. It tells the truth in a much simpler and more direct way.
Instead of checking things that indicate your data is being
replicated, just replicate some data and check the data itself.
--
MySQL General Mailing List
For
the shutdown times depend on, and how can I reduce it?
Thanks,
Nico
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=ba...@xaprb.com
--
Baron Schwartz, Director of Consulting, Percona Inc.
Our
Mike,
Now the SSD that I would like to have is the Hyperdrive 5 from
http://www.hyperossystems.co.uk/. It is a DDR SSD and each drive has slots
for 8 DIMM's which means it can hold up to 32GB (64GB if you can find 8GB
DDR2's) per drive. They can be striped to give you a heck of a lot of drive
Mike,
MySQL does not scale well beyond 4 processors, at least not like PostgreSql
does. MySQL seems to hit a plateau rather quickly. If XtraDb's modified
Innodb plugin scales better, then fine. But I haven't seen any benchmarks
showing the speed improvements relative to the number of
know if anyone other than Google really does understand their
patches right now.
Baron
--
Baron Schwartz, Director of Consulting, Percona Inc.
Our Blog: http://www.mysqlperformanceblog.com/
Our Services: http://www.percona.com/services.html
--
MySQL General Mailing List
For list archives: http
the difference. InnoDb and MyISAM don't scale
well with multi-cores I'm afraid.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=ba...@xaprb.com
--
Baron Schwartz, Director of Consulting, Percona Inc
On Sun, Mar 29, 2009 at 10:19 AM, Claudio Nanni claudio.na...@gmail.com wrote:
An explain of the two statements yields the same plan,
anybody knows if they are actually translated in the same plan?
There is a difference. The IN list is sorted so lookups can be done
as a binary search. A bunch
:
http://yueliangdao0608.cublog.cn
--
Baron Schwartz, Director of Consulting, Percona Inc.
Our Blog: http://www.mysqlperformanceblog.com/
Our Services: http://www.percona.com/services.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
.
Craig
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=ba...@xaprb.com
--
Baron Schwartz, Director of Consulting, Percona Inc.
Our Blog: http://www.mysqlperformanceblog.com/
Our Services: http
On Mon, Mar 16, 2009 at 10:25 AM, Hatem Nassrat hatem.nass...@gmail.com wrote:
Hi,
Is there any way to rollback a transaction in MySQL 5.1 that contains
Create, Alter, Drop, table statements.
No. Sorry.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
But EXPLAIN is only a prediction. If you look at the changes in the
Handler status variables, you'll see the second one reads fewer rows.
Ok, I think I get it. I first changed both of my queries to add
sql_no_cache because without that, the Handler_read_rnd_next variable was
zero in both
:SIMPLE:actor:ALL:null:null:null:null:200:Using where
This explain output is identical to the output for the previous query, so
this workaround didn't appear to help any.
But EXPLAIN is only a prediction. If you look at the changes in the
Handler status variables, you'll see the second one reads fewer rows.
--
Baron
That's deprecated too :-)
On Wed, Mar 11, 2009 at 9:17 PM, Cui Shijun rancp...@gmail.com wrote:
hi,
#2. try adding the information of master into my.cnf then restart the
server.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Stefan,
On Sun, Mar 8, 2009 at 1:50 PM, Stefan Onken supp...@stonki.de wrote:
Hello,
I am bit puzzled about combining mysql fulltext search into our
current search:
I am not able to combine a fulltext search with other selections,
please see http://pastebin.com/m23622c39 for full details.
On Sat, Mar 7, 2009 at 12:10 PM, buf...@biffco.net wrote:
Is there a way I can restore the concurrent select feature to a working
state without having to shut down the server and rebuild the entire data
base?
Usually when concurrent insert is not permitted, it's because there
are holes in
!
On Fri, Mar 6, 2009 at 12:08 PM, Atle Veka at...@flyingcroc.net wrote:
Hi, care to elaborate on the pit-falls of binlog-do-db?
Thanks,
Atle
On Wed, 4 Mar 2009, Baron Schwartz wrote:
No. But I would recommend removing binlog-do-db and using
replicate-wild-do-table=mydb.% on the slave instead
/10 .. so whats the typical IO (rnd rw) that you
archive/expect on high trafficked sites ?
--- On Wed, 3/4/09, Baron Schwartz ba...@xaprb.com wrote:
From: Baron Schwartz ba...@xaprb.com
Subject: Re: MySQL Log and Data directories
To: dbrb2002-...@yahoo.com
Cc: mysql@lists.mysql.com
Date
accessing the view and doing the inserts in separate transactions?
--
Baron Schwartz, Director of Consulting, Percona Inc.
Our Blog: http://www.mysqlperformanceblog.com/
Our Services: http://www.percona.com/services.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Is there a way I can restore the concurrent select feature to a working
state without having to shut down the server and rebuild the entire data
base?
Usually when concurrent insert is not permitted, it's because there
are holes in the table that cause inserts to go somewhere other than
at the
SLAVE STATUS what's being replicated.
--
Baron Schwartz, Director of Consulting, Percona Inc.
Our Blog: http://www.mysqlperformanceblog.com/
Our Services: http://www.percona.com/services.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Carl,
Locked status in SHOW PROCESSLIST and a table being locked are
different. There is a bug in MySQL that shows Locked status for
queries accessing InnoDB tables in some cases. What version of MySQL
are you using?
The table is not really locked, you're just seeing that as a side
effect of
Carl,
Locked status in SHOW PROCESSLIST and a table being locked are
different. There is a bug in MySQL that shows Locked status for
queries accessing InnoDB tables in some cases. What version of MySQL
are you using?
The table is not really locked, you're just seeing that as a side
effect of
of difference.
The real answer is always -- run a benchmark and see. Does the
improvement offset things like any kind of penalty the OS imposes on
you (e.g. LVM can't take a snapshot across multiple volumes)?
--
Baron Schwartz, Director of Consulting, Percona Inc.
Our Blog: http
- Original Message - From: Baron Schwartz ba...@xaprb.com
To: Carl c...@etrak-plus.com
Cc: mysql@lists.mysql.com
Sent: Wednesday, March 04, 2009 2:29 PM
Subject: Re: Select query locks tables in Innodb
Carl,
Locked status in SHOW PROCESSLIST and a table being locked are
different
On Tue, Mar 3, 2009 at 12:35 PM, Brent Baisley brentt...@gmail.com wrote:
A SELECT will/can lock a table. It almost always does in MyISAM (no
insert/updates), almost never does in InnoDB. There is an exception to
every rule. The problem is most likely in the 107488 rows part of the
query.
Claudio,
http://www.mysqlperformanceblog.com/2007/10/29/hacking-to-make-alter-table-online-for-certain-changes/
Your mileage may vary, use at your own risk, etc.
Basically: convince MySQL that the indexes have already been built but
need to be repaired, then run REPAIR TABLE. As long as the
Hi,
On Fri, Feb 27, 2009 at 2:51 PM, dbrb2002-...@yahoo.com wrote:
Thanks for the quick followup Baron..
vmstat
procs ---memory-- ---swap-- -io --system--
-cpu--
r b swpd free buff cache si so bi bo in cs us sy id
wa st
3 0 100
: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=ba...@xaprb.com
--
Baron Schwartz, Director of Consulting, Percona Inc.
Our Blog: http://www.mysqlperformanceblog.com/
Our Services: http://www.percona.com/services.html
--
MySQL General Mailing List
For list
1 - 100 of 634 matches
Mail list logo