Hi Yang,
On Mar 26, 2010, at 4:28 PM, Yang Zhang wrote:
I've noticed that Innodb seems to exhibit true serializability for the
serializable transaction isolation level. Does this mean it implements
predicate locking?
Kinda, but not exactly. In serializable, all reads will use shared
locks
Hello Johan,
On Dec 9, 2009, at 11:22 AM, Johan De Meersman wrote:
Posted this before, but beware: federated tables do NOT use indices.
Every
select is a full table scan, and if you're talking about a logging
table
that could become very expensive very fast.
This is not entirely true. If
Hello,
On Oct 23, 2007, at 11:23 AM, js wrote:
Hi list,
Reading How AUTO_INCREMENT Handling Works in InnoDB[1] makes me
wonder how is it possible to replicate AUTO_INCREMENTed value to
slaves.
According to the doc,
"If you specify an AUTO_INCREMENT column for an InnoDB table, the
table ha
Hello,
On Aug 31, 2006, at 5:12 AM, Kim Christensen wrote:
Hey list;
I posted this message under an earlier thread which touched the same
subject - but I realized my case could be slightly different, thus
posting a new thread here. Sorry for any inconvenience.
I have two tables, one of which
Hi,
On Jun 21, 2006, at 12:24 PM, Kevin Old wrote:
On 6/21/06, Barry <[EMAIL PROTECTED]> wrote:
Kevin Old schrieb:
> Hello everyone,
>
> I had a horrible thing happen to me this morning and wanted to
make it
> known to the community.
>
> I needed to delete a record from a very large table (
Hi Mike,
On Jun 8, 2006, at 10:52 AM, mos wrote:
At 03:09 AM 6/8/2006, Rob Desbois wrote:
Douglas,
If you are selling a product which requires your users download
MySQL or requires you distribute it with the product, you need a
commercial licence.
$595?! Ouch indeed...it's much cheaper if
Hi,
On Dec 16, 2005, at 9:23 AM, C.R.Vegelin wrote:
I use various script files with queries to update a MySQL base
periodically.
These scripts are run from the mysql> line with the \. command.
I would like to have a BEEP command at the end of the script to get
a signal that processing the s
Hi,
On Nov 11, 2005, at 10:01 PM, Marcus Bointon wrote:
At the time I reported this bug back in February: http://
bugs.mysql.com/bug.php?id=8684 I was pleased to see it apparently
fixed so fast. I wasn't yet using MySQL 5, so I couldn't get the
fix. I am now upgrading to 5 using mysql 5.0.1
Hi Ken,
On Sep 18, 2005, at 3:53 PM, Ken Gieselman wrote:
Scott Gifford wrote:
Ken Gieselman <[EMAIL PROTECTED]> writes:
[...]
So, here's my question: How can I find out how many rows are being
returned by a query, without using mysql_stmt_store_result() to
buffer all the rows back to the cli
Hi,
On May 26, 2005, at 5:03 PM, David Griffiths wrote:
This isn't exactly the right spot, but I can't find any info on the
MySQL web site.
Anyone know who maintains the MySQL Migration Tool (or who is
developing it, as it is currently Apha)?
MySQL AB is actively developing it (hence why i
can use STR_TO_DATE to "fix" a
datetime field before it is loaded into the table directly.
will be quite hard to figure out on my own i guess?
Thanks again!
From: Harrison Fisk <[EMAIL PROTECTED]>
To: "Jessica Svensson" <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Sub
Hi,
On May 25, 2005, at 1:28 PM, Jessica Svensson wrote:
That just complicates things alot since i get around 200 files, 6
times a day via an automated process and every textfile looks
different from the other. To just have different load data would make
it much easier.
I have read alot of
Hi,
On May 8, 2005, at 1:47 PM, Kevin Burton wrote:
Harrison Fisk wrote:
aren't loaded into the query cache, they are loaded into the key
cache (key_buffer_size).
Yes... you busted me ! :). I meant to say key cache though.
Alright, I assumed a typo or such.
Not only THAT but it doesn'
Hi Kevin,
On May 8, 2005, at 1:07 PM, Kevin Burton wrote:
OK.
Lets take a mythical application. The app is spending about 50% of
its time inserting into table FOO. The other 50% of the time its
spent doing SELECT against the table.
The SELECTs can use an index which is already full loaded into
Hi,
On Mar 24, 2005, at 6:07 PM, <[EMAIL PROTECTED]> wrote:
Mysql is telling me my Heap table is full. Now I set it to 128M.
my.cnf line
tmp_table_size = 128M
Try changing the setting called max_heap_table_size. tmp_table_size
only has to do with internal temporary tables that are used to reso
Hi,
On Mar 6, 2005, at 12:51 PM, mos wrote:
At 10:07 PM 3/2/2005, you wrote:
Hello.
You may use ALTER TABLE .. DISABLE KEYS to speed up the loading
process
on the MyISAM table.
I gave that a try but I had to cancel "Alter Table ... Enable Keys"
after 49 hours. I find it amazing that it takes only
Hi,
On Mar 3, 2005, at 3:13 PM, mos wrote:
At 12:39 PM 3/3/2005, Harrison Fisk wrote:
Hi,
On Mar 3, 2005, at 11:32 AM, mos wrote:
At 10:07 PM 3/2/2005, you wrote:
Hello.
You may use ALTER TABLE .. DISABLE KEYS to speed up the loading
process
on the MyISAM table.
That may work provided I can get
Hi,
On Mar 3, 2005, at 11:32 AM, mos wrote:
At 10:07 PM 3/2/2005, you wrote:
Hello.
You may use ALTER TABLE .. DISABLE KEYS to speed up the loading
process
on the MyISAM table.
That may work provided I can get the keys rebuilt later using FileSort
and not KeyCache.
You see the problem isn't in l
Hi,
On Feb 10, 2005, at 7:00 PM, Brad Eacker wrote:
Folks,
I have a 677M row table with index
desc pts_awarded_snap;
+-+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+-+-+--+-+-+---+
| memb
Hi,
On Tuesday, December 21, 2004, at 07:59 AM, Luciano Barcaro wrote:
Sergei, thanks for the reply, but I coudn´t see any 'useful' info
about it .
I would like to know the differences (characteristics) between
federated and other engines
The federated engine allows you to have remote tables (i
Hi,
On Wednesday, December 15, 2004, at 12:51 PM, John McCaskey wrote:
On Wed, 2004-12-15 at 11:46 -0600, gerald_clark wrote:
John McCaskey wrote:
I'm currently doing a large number of REPLACE queries, I know that
these
evaluate as if doing a DELETE/INSERT pair, and I'm wondering if this
is
true
Hi,
On Tuesday, December 7, 2004, at 03:07 PM, Klaus Berkling wrote:
On Dec 6, 2004, at 3:51 PM, Harrison Fisk wrote:
Hi,
On Monday, December 6, 2004, at 04:15 PM, Klaus Berkling wrote:
I beginning to use MySQL clustering abilities for a large records
keeping solution.
I have installed 4.1.7
Hi,
On Monday, December 6, 2004, at 04:15 PM, Klaus Berkling wrote:
I beginning to use MySQL clustering abilities for a large records
keeping solution.
I have installed 4.1.7 with the clustering components. The ndbd and
ndb_mgmd processes are running. I can create the database and tables
usin
Another way you can do something similar, rather than messing around with
permissions is to use the read-only option. This option exists in MySQL
4.0+. It prevents anyone except for the mysql root user or the
replication thread from being able to change data -- regardless of their
permissions. Y
On Fri, 6 Feb 2004, Michael Satterwhite wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> I still have the problem with being unable to logon to a database with a
> password. When the password is entered - either on the command line (-p???)
> or on the following line (-p without a pa
Hi,
On Sat, 13 Dec 2003, Chris Nolan wrote:
> 1. We all know that InnoDB can be backed up "hot" (by various means). I
> know that there are a few MS SQL Server (ick) and DB2 lovers in the
> group I'll be meeting with this week. I also know that these two
> databases do a form of online backup.
>
26 matches
Mail list logo
