Hi all,
I'm busy setting up replication and have encountered what looks like a bug
in mysqldump. The following commands work perfectly:
Running the following commands in the mysql client on the slave:
stop slave;
reset slave;
create database dbName;
CHANGE MASTER TO MASTER_HOST='masterHost',
Message-
From: Mark Maunder [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2008 3:02 AM
To: mysql@lists.mysql.com
Subject: Possible bug in mysqldump?
Hi all,
I'm busy setting up replication and have encountered what looks like a bug
in mysqldump. The following commands work
LOCK on the master prior to the mysqldump will
guarantee that no transactions, regardless of whether it is for MyISAM or
InnoDB, will come through during a mysqldump.
--
*From:* Mark Maunder [mailto:[EMAIL PROTECTED]
*Sent:* Tuesday, August 05, 2008 12:17 PM
1))
';
If the return value of the select statement is
0 - Outside the polygon
1 - Inside the polygon
Thanks,
ViSolve MySQL Support Team.
- Original Message -
From: Mark Maunder [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, July 21, 2006 4:40 AM
Subject
PROTECTED]
--
Mark Maunder [EMAIL PROTECTED]
http://www.markmaunder.com/
+1-206-6978723
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
/var/lib/mysql/database name
is a common location. If you're on unix try the following command:
find /var -name mysql
On 7/20/06, Martin Jespersen [EMAIL PROTECTED] wrote:
You can usually find the database files under the var subdirectory
under your installation, unless another datadir was
I'd like to test whether a point is truly inside a polygon, not just
insude the minimum bounding rectangle. Is there a way to do this in
MySQL with the spatial extensions? I love mysql but I'm forced to
consider migrating to postgresql (ugh!) because it has built in
support for testing spatial
This all started when one of the 16 byte binary primary keys kicked out
a duplicate key error. It seems mysql does not store the last byte of
the binary value if it is a space. That is, ascii 32 or hex 20.
How do I force it to store the space? Thanks!
create table testtable ( id binary(16) NOT
-12-03 at 12:10, Dan Nelson wrote:
In the last episode (Dec 03), Mark Maunder said:
This all started when one of the 16 byte binary primary keys kicked out
a duplicate key error. It seems mysql does not store the last byte of
the binary value if it is a space. That is, ascii 32 or hex 20
So what you're saying is that BINARY isn't binary because it chomps
spaces off the end, thereby corrupting the binary data. Sounds like a
bug. Should I report it?
On Fri, 2004-12-03 at 12:30, Paul DuBois wrote:
I agree about using the TINYBLOB to avoid trailing space truncation, but
BINARY and
It looks like when mysql coerces character strings into integers, it
turns them into signed int's. Obviously if the column is unsigned, this
is a problem. Don't use quotes you say. Problem is that the perl DBI API
seems to put quotes around everything. So when I grab a really really
large integer
Thanks very much Paul. My day has just improved.
On Fri, 2004-12-03 at 16:53, Paul DuBois wrote:
At 16:34 -0800 12/3/04, Mark Maunder wrote:
It looks like when mysql coerces character strings into integers, it
turns them into signed int's. Obviously if the column is unsigned
Scott,
http://dev.mysql.com/tech-resources/articles/4.1/prepared-statements.html
regards,
Mark.
On Thu, 2004-11-11 at 15:38, Scott Hamm wrote:
I've read the article about 'prepared statement' found in MySQL 4.1, and am
not sure if I understood what 'prepared statement' does and how can it
Please include the full query you're running, the table structure, and
the number of rows in the table. A dump of 'show variables;' would be
helpful too.
On Wed, 2004-11-10 at 21:44, foo bar wrote:
Hi Everyone,
I've been Googling unsuccessfully for specific issues
relating to queries run on
Hi,
If I set the table cache to 2 how much memory will it consume? And
how much latency is there when mysql has to open a table before
executing a query?
Some background:
I have a database with around 1000 tables. I'll have roughly 20
concurrent connections to the DB. And in my queries I'll
wait_timeout28800
--- Mark Maunder [EMAIL PROTECTED] wrote:
Please include the full query you're running, the
table structure, and
the number of rows in the table. A dump of 'show
variables;' would be
helpful too.
On Wed, 2004-11-10 at 21:44, foo bar wrote:
Hi Everyone
Post it, I'll help.
On Tue, 2004-11-09 at 19:21, Lewick, Taylor wrote:
I am asking before I post so I don't anger everyone...
Is this list okay to post a specific question regarding multiple row
inserts..
I am doing this in perl, and I need some help with the perl part...
We won't be serving concurrent queries.
On Sun, 2004-11-07 at 10:41, Michael J. Pawlowsky wrote:
Another thing to consider is how many transactions per minute/second you
will need to serve.
Mark Maunder wrote:
I'm busy building an application that will have 10 million records, each
I'm busy building an application that will have 10 million records, each
with a chunk of text - about 500 words each, on average. Does anyone
have any benchmarks they can share with mysql's fulltext search
performance on indexes of this size?
What I'd like to know is what size server I need to
as I preload the index. Isn't that the point
of preloading?
On Fri, 2004-11-05 at 05:25, Gleb Paharenko wrote:
Hi.
There is a bug: http://bugs.mysql.com/bug.php?id=4285.
Mark Maunder [EMAIL PROTECTED] wrote:
I have a large fulltext index (the MYI file is about 750 Megs) and I've
set
I keep getting this error when trying to preload a fulltext index. I've
checked the block size of the fulltext index using myisamchk (is there
an easier way to find out block size?) and it is 2048. The block size of
the primary key on the same table is 1024. Is that what it means by
Indexes use
I have a large fulltext index (the MYI file is about 750 Megs) and I've
set my key_buffer_size to 1 Gig. I do:
load index into cache fttest;
and I watch the Mysql process in memory, and it doesn't grow. It just
hangs around 250Megs. Why isn't the index loading into memory?
Thanks,
Mark.
--
to it. Just want to let you know that you are not alone
having this problem.
Haitao
On Fri, 05 Nov 2004 02:16:49 +, Mark Maunder [EMAIL PROTECTED] wrote:
I keep getting this error when trying to preload a fulltext index. I've
checked the block size of the fulltext index using myisamchk
I have a large database of zip codes with longitude and latitude of
each, and I periodically generate a lookup table for each zip showing
all zip codes within various radii. The process takes a day on my poor
workstations 2.5GHz CPU, but I need to do it faster. Does anyone know of
somewhere I can
disks? Are you not
risking major data loss if ever you have a power failure or PC failure?
Thanks for the info!
Eric
Mark Maunder [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Since HEAP tables don't support fulltext indexes, is moving MYISAM
tables to ramdisk an acceptable
/doc/en/Multiple_key_caches.html
I haven't tried 4.11 yet (I'm just about to d/l it), but would expect it to
be pretty stable.
Eric
Mark Maunder [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
The table I'm using is non-critical data, so it's not really an issue
for me
Since HEAP tables don't support fulltext indexes, is moving MYISAM
tables to ramdisk an acceptable workaround?
On Sat, 2004-02-21 at 18:35, Mark Maunder wrote:
I've noticed a 4 times insert speed improvement by moving the MYI index
file of a myisam table to a ramdisk. The MYD file is still
I've noticed a 4 times insert speed improvement by moving the MYI index
file of a myisam table to a ramdisk. The MYD file is still on a physical
disk, and I benchmarked the difference between moving just the index
file, or moving both, and it was only a 10% difference in speed. The
table has a
The two simultaneous insert statements will be have separate connections
to the database and last_insert_id() is connection specific. So if
you're running apache, and you're worried about two different apache
child processes getting the same connection ID, don't. Because those two
children will
for the activity of other
clients, and without the need for locks or transactions.
On Thu, 2004-02-19 at 09:26, Mark Maunder wrote:
The two simultaneous insert statements will be have separate connections
to the database and last_insert_id() is connection specific. So if
you're running apache
I am considering an upgrade on our server from 512 megs of RAM to 1 or
possibly 1.5 gigs, and would like to know if I'm going to get a
significant performance boost. Any suggestions or information is much
appreciated. Our configuration is as follows:
The table has around 100,000 records (but will
Hi,
Is there a way to speed up inserts on a table with three fulltext
indexes? I'm using the multiple value insert format like:
insert into blah (field1, field2) values ('val1', 'val2'), ('val2',
'val3'), etc..
Perhaps this is a bug in the current mysql4 bk snapshot, but inserts and
selects on
Art,
Do you mean, whenever you try to run the 'mysql' client you get that error? That
usually happens because you are trying to connect to the mysql server using the
mysql client running on the same machine i.e. localhost. It's because the mysql
client uses a socket file when connecting locally
Just in case you were wondering what the state of mysql version 4 is.
We're running a production site with a reasonably loaded MySQL 4.0
back-end. You can visit the site at http://www.workzoo.com/
The main motivation for mysql4 was the enhanced fulltext index support
which is awesome and rapidly
Jim,
I'd like to help, but I dont answer questions directly. Please post your
question to the mysql mailing list in future. I have crossposted this to the
list.
kind regards,
Mark Maunder.
Jim Chivas wrote:
Mark:
I work in a School where the teachers want to use mysql.
A while back you
Linux for PS2 is being released in Europe in May this year:
http://www.scee.com/corporate/pressreleases.jhtml
Who's going to be the first to get MySQL to compile on PS2. ;-)
~mark.
-
Before posting, please check:
Clive Bredenkamp wrote:
Hi All,
I have about 15GB of xml files each ranging from about 400bytes to 4k (some
exceptions being up to a few MB, but mainly small), and am planning to stick
these files in a database for better mainteance.
Does anyone have advice on the best way in which to
I've seen various bug reports for mysql 4.0.1 but no sign of it on the
site. Has it been released yet? I think the 'IN BOOLEAN MODE' modifier
for a fulltext search may solve all my problems.
kind regards,
Mark.
-
Before
I've figured out a temp workaround for the problem/feature of words that
appear in more than 50% of records in a fulltext index being considered
stopwords. I just added as many dummy records as there are real records
in the table. A fulltext search will now not disregard any words based
on their
Sergei Golubchik wrote:
Mark, it's no point in discussing how things could be
done in 3.23 branch - nothing can be changed there,
this is exactly the reason we call it stable.
How to get rid of 50% threshold is explained in the manual -
for MySQL-3.23.x the only way is to modify the source
Sergei Golubchik wrote:
Hmm, them 4.0.1 (with IN BOOLEAN MODE) won't help either :-(
It uses the same scoring scheme as the above query in 4.0.0
Where can I get 4.0.1? I dont see it on the website.
Because it's not officially out yet :-)
(you can always use it before official
Hi,
Is there a way to prevent the 50% occurence threshold in mysql's
fulltext search logic that causes words that appear in more than 50% of
records to be considered stopwords? I have a table that has less than
1000 records and would like to do a fulltext search on two columns and
have them
Hi,
Is MySQL 4.0 Alpha updated periodically with bugfixes? i.e. Is it worth
periodically re-downloading and re-installing MySQL 4.0 to ensure I have
the most stable version?
tnx,
~Mark.
-
Before posting, please check:
Jim Chivas wrote:
Greetings:
I saw a reply you sent to a mysql user about setting up new users to
mysql. I am hoping you can clarify some questions for me.
I referenced the url you gave out at the mysql.com/documentation/. It
was suppose to show how to setup users but does not give
Hi,
We have just launched a non-profit open source jobsite. Check it out at
http://www.freeusall.com/ It's built on MySQL 4.0 (Alpha), Perl and
Apache. We'd appreciate any feedback you might have.
kind regards,
Mark Maunder
David Potter wrote:
Dear list members,
We are running Mysql 3.23 on Redhat Linux 7.1.
We have an emergency. This is the first time we have ever had a problem. Our
production database suddenly crashed. I have tried to repair the tables with
myisamchk commands, -r, -o, etc and nothing
Robert Alexander wrote:
I just found out, while looking for other things, that what seems to be the entire
content of the MySQL list is being published on the web.
I, for one, really don't like this idea. I have a reasonable expectation that what I
post here is for viewing by subscribers to
Trond Eivind Glomsrød wrote:
Moshe Gurvich [EMAIL PROTECTED] writes:
I'm trying to run:
delete from followups where task_id not in (select task_id from tasks)
but it gives me an error:
Error: 1064 - You have an error in your SQL syntax near 'select task_id from
tasks)' at line 1
Robert Alexander wrote:
- Replies are directed to the POSTER and not to the list. This keeps traffic
and clutter down.
- Those who don't post a SUMMARY are likely to find future questions
going unanswered.
So answers to questions go directly to the poster and are not cc'd to the
Ben Edwards wrote:
I have a bit of a problem with using freetext indexes because there are a
LOT of important 3 letter words in my database and as I am using shared
hosting so do not have the option to recompile MySql. Can't quite figure
why 3 is not the default (car, dog, cat war, man,
Scott Alexander wrote:
I've been reading a document at
http://www.saturn5.com/~jwb/dbi-performance.html
by Jeffrey William Baker.
And I have changed my perl code in one script to use placeholders and
bound parameters.
On my test server 500 mhz rh 7.1 128 MB I haven't noticed any speed
Jeremy Zawodny wrote:
On Sat, Oct 20, 2001 at 05:02:22PM +0100, Mark Maunder wrote:
The only time you'll see a real performance increase is where you're
repeadedly calling execute() on the same statement handle with
different values for the placeholders - usually this occurs in a
loop
Hi,
I think this is a bug. The script to recreate the problem is included
below. This problem appears consistently as long as there's a fulltext
index and a regular index on the same field and you do an update to
change the case of a single char. It doesn't matter if the fulltext
index includes
Mark Maunder wrote:
Hi,
I think this is a bug. The script to recreate the problem is included
below. This problem appears consistently as long as there's a fulltext
index and a regular index on the same field and you do an update to
change the case of a single char. It doesn't matter
tester;
Fix:
No known workaround. Please advise if you are aware of one. Thanks.
Submitter-Id: submitter ID
Originator:Mark Maunder
Organization:
SwiftCamel Software LTD
MySQL support: none
Synopsis: Table crash when doing update of record with fulltext index.
Severity
(quicky coz this is way off topic):
ln -s /usr/local/apache/bin/apachectl /etc/rc.d/init.d/httpd
ln -s /etc/rc.d/init.d/httpd /etc/rc.d/rc3.d/S90httpd
ln -s /etc/rc.d/init.d/httpd /etc/rc.d/rc5.d/S90httpd
ln -s /etc/rc.d/init.d/httpd /etc/rc.d/rc6.d/K90httpd
That should do it. Should bring up
I have had the following problem with both mysql 3.22 (using isamchk) and
3.23 (using myisamchk).
I use either isamchk table.ISM or isamchk -e table.ISM. The utility reports
a miscellaneous error (error: Record at: 20224201 Can't find key for
index: 2 for example).
I run the check again
It's one of MySQL's permission files which is usually in
/var/lib/mysql/mysql
If the file is there it may be permissioned incorrectly. It usually needs to
be owned by the mysql user and group so
cd /var/lib/mysql
chown mysql.mysql mysql -R
if this seems to be the problem.
The permission files in
Sounds like you want a mutex and you can use get_lock and release_lock in
mysql for that.
http://www.mysql.com/doc/M/i/Miscellaneous_functions.html
GET_LOCK(str,timeout)
Tries to obtain a lock with a name given by the string str, with a timeout
of timeout seconds. Returns 1 if the lock was
Sounds good. You should probably have a cleaner process of some kind just in
case one of your threads dies before it can release the lock. I think with
get_lock you have a timeout that protects you from that. I'm curious about
the internals of get_lock - perhaps it's more efficient to use a soft
60 matches
Mail list logo