T PROTECT MyISAM
> tables from live changes being written to the dump file since you cannot run
> ACID compliant transactions against MyISAM, only InnoDB.
>
>
>
> Doing FLUSH TABLES WITH READ LOCK on the master prior to the mysqldump will
> guarantee that no transactions, regardless
se --master-data in the mysqldump
>
> 5) In mysql session 2, run "CHANGE MASTER TO MASTER_LOG_FILE=' from SHOW MASTER STATUS>,MASTER_LOG_POS=' STATUS>';"
>
> 6) In mysql session 2,run 'START SLAVE'.
>
> 7) In mysql session 1, run 'UNLOCK TA
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', MAST
unsubscribe:http://lists.mysql.com/[EMAIL 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]
on((0 0,0 3,3 0,0 0),(1 1,1 2,2 1,1 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]>
T
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 rel
/var/lib/mysql/
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 specified
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
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 f
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
asap.
On Fri, 2004-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 i
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 N
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
>
he_size0
> query_cache_typeON
> query_prealloc_size 8192
> range_alloc_block_size 2048
> read_buffer_size131072
> read_only OFF
> read_rnd_buffer_size262144
> rpl_recovery_rank 0
> server_id 0
> slave_net_timeout 3
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
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
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 h
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 run
27;d
expect it to grow as soon 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:
> >
> solution 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'
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.
--
MyS
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 di
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 b
ache for temporary tables though:
> http://www.mysql.com/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 mess
echanism for ram 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
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
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 larg
eve your own ID without concern 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 conn
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 hav
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 a
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 a
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.
&g
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.
&g
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:
http://www
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
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 "
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
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 f
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 postin
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 retur
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:
http
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 g
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,
Ma
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 nothi
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
> >
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 subscriber
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
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,
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
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 s
A test' where id=1;
check table tester;
>Fix:
No known workaround. Please advise if you are aware of one. Thanks.
>Submitter-Id:
>Originator:Mark Maunder
>Organization:
SwiftCamel Software LTD
>MySQL support: none
>Synopsis: Table crash when doing update o
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
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 o
If you do any benchmarking with this setup let me know as I'm curious about
performance.
Mark Maunder.
Patrick Goetz wrote:
> Currently, every system I've set up is small enough so as to have the web
> server and the database server on the same machine. Consequently, loss of
> secu
(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 you
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 l
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 obta
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
Hey Chuck,
We replicate data on a regular basis from Oracle to MySQL and back using
perl cron scripts. Here's a basic one for ya:
#!/usr/bin/perl
use strict;
use DBI;
my $dbh1=DBI->connect("DBI:mysql:dbname:host.mark.com:6969", 'root'
,'password');
my $dbh2=DBI->connect("DBI:mysql:dbname2:host
mysql etoys < test.txt | more
where test.txt contains something like:
desc addresses;
desc members;
Or try
mysqldump dbname addresses members orders -d | more
That'll give you the data definition language without any data for each
table. (addresses, members and orders in the above example)
If
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 imm
64 matches
Mail list logo