A programmer just asked me about a possible race condition,
and I didn't know what to answer:
If I insert a line using autoincrement, then ask for last_insert_id()
am I guaranteed to get the same ID I just inserted?
It seems that another program could be inserting at almost the same
time, and c
...winner will be announced January 31, or sometime in February.
Did I miss something?
What is the Dolphin's name?
Steve the mysql data guy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I'm currently running MySQL for a big, fast app without
problems. BUT:
I'm in the middle of specifying a new application with a high
load, and I'm consideing looking for alternatives to MySQL
because without InnoDB, it gets really slow on tables
with frequent updates and reads (no row locking).
construct a
database, configure the interface, and put it on the web,
without knowing much SQL, middleware, etc. In the case of
Filemaker, you don't even need to know HTML or be artistic.
Perhaps this helps.
Steve Rapaport
]
] I thought Mysql was a server that could be used as a online
backslash before each apostrophe before using
the string in the database.
For SQL you may find that just using double quotes for
all strings is sufficient to recognize the apostrophe as
a regular character.
________
Steve Rapaport
CTO, A-Tono
Via Amedei, 15 - Mi
ge on replication issues.
Steve Rapaport.
] -Original Message-
] From: Tobias Lind - Telia Internet [mailto:[EMAIL PROTECTED]]
] Sent: Tuesday, March 05, 2002 1:46 PM
] To: [EMAIL PROTECTED]
] Cc: [EMAIL PROTECTED]
] Subject: Re: InnoDB frightens me...
]
]
] Thanks - that would be great!
I'm seriously considering switching to mysql-max so I can make my
session handling table an Innodb type. Currently the mysql locking policy
allows big traffic jams when several sessions are active simultaneously,
and it's the only table that has frequent updates. I need row-locks!
BUT, and it's
I need to change the variable ft_min_word_len, in mysql 4.0.1
The manual doesn't say how:
Here's the closest it comes:
SHOW VARIABLES shows the values of some MySQL system variables. You can also
get this information using the mysqladmin variables command. If the default
values are unsuitabl
>The "warning: Found 22079089 partsShould be: 0 parts" is a
>known error of myisamchk in MySQL 4.0.1, and is already fixed in MySQL 4.0.2
Thanks, Jocelyn, good to know, but the cardinality of the resulting indexes
is STILL NULL: hence perhaps not fixed.
So the bug report may
eferences index: 5
- check data record references index: 6
- check data record references index: 7
- check record links
myisamchk: warning: Found 22079089 partsShould be: 0 parts
MyISAM-table 'White' is usable but should be fixed
[root@db1 elenco2g]# ls -l
total 3433832
-rw-
Somewhere in the manual I once came across a way to
rebuild missing MYI files from MYD files and .frm files.
I think. Searches seem futile now.
Can anyone confirm and point to the page?
mysql table query
Thanks,
Steve
-
Bef
Thanks to the guy who pointed this out.
For the information of others, yes, it's quite possible
to have a machine with mysql table files > 2GB lying about on the
disk, that still doesn't properly support them.
I had thought that if Mysql could create a 3GB file,
it could use it. Bad assumption
Arrrggghhh!
This is definitely a problem!
Can't access table White in mysql 4.0.1: table is "read-only".
why? because it's corrupt!
Try to fix: takes a long time (about an hour) and seems to work.
But it's still corrupt and read-only:
[root@db1 elenco4_fb02]# myisamchk White;
Checking MyI
On Wednesday 27 February 2002 07:47 am, Jeff Kilbride wrote:
> -
> I'm going to be implementing a keyword search pretty soon myself, so I'd
> like to see you solve this. :)
Me too! :-)
> What about doing some sort of prefix indexing, instead of indexing the
> e
Problem:
1. in a phone book, a single field may contain several words, e.g.
District 52 Police Station.
2. The query for this record may contain some or all of these words, but not
necessarily in that order, e.g. Police district 52.
3. Searching for all of the query words can be done in many way
Problem:
1. in a phone book, a single field may contain several words, e.g.
District 52 Police Station.
2. The query for this record may contain some or all of these words, but not
necessarily in that order, e.g. Police district 52.
3. Searching for all of the query words can be done in many w
This one gets answered about 6 times per month, so
perhaps the Mysql doc team could consider putting
an FAQ or heading in the documentation for it.
For example, under "A Problems and Common Errors",
which is not English, by the way, there should be
a heading "Porting, Importing, and Exporting".
No need, Marco. Assuming you can run Mysql at the remote machine,
you can simply take the export file and run it in mysql.
Either, from the mysql prompt, type
mysql> use mynewdatabase;
mysql> source dumpfile;
or you can do it from a command line like
% mysql -e "use mynewdatabase; source dumpfi
etc., etc. All valuable and appropriate comments, no doubt. FOR SOME OTHER
PART OF THE MANUAL. I hope some tech writer at Mysql AB is reading this.
Steve Rapaport
-
Before posting, please check:
http://www.mysql.com/manual.
Has anyone noticed that the comments in the Mysql on-line docs
are almost entirely always off-topic?
Compare, for example, to the PHP docs www.php.net
What's strange is not the number of moronic posts (minimal), but
the number of useful and often insightful posts that appear
to have been entered
I said:
> > Why is it that Altavista can index terabytes overnight and return
> > a fulltext boolean for the WHOLE WEB
> > within a second, and Mysql takes so long?
On Friday 08 February 2002 08:56, Vincent Stoessel wrote:
> Apples and oranges.
Yeah, I know. But let's see if we can make some d
Ooops, factual error:
> > If, say, Google, can search 2 trillion web pages, averaging say 70k
> > bytes each, in 1 second, and Mysql can search 22 million records, with
> > an index on 40 bytes each, in 3 seconds (my experience) on a good day,
> > what's the order of magnitude difference? Roughl
the good ideas
and inserted them into the TODO list, although he had higher priorities
at the time.
And I was satisfied for now, although my application still isn't working
satisfactorily due to a really slow and CPU-hungry FULLTEXT search.
I think that's our stor
Check that your file size limit on your machine is more than the
usual 4GB. I have a 23 million row database, and it translates
into 3GB data file, 3GB index file. 1 billion records would never
fit. My record length is about 300 bytes.
If you need more than a 4GB data file, you should check o
st way to do this.
So Monty et al, my request is this: please put on the wish list, enhancement
of FULLTEXT search to approximately match the performance of an indexed
search on 25 million records, on the same hardware and with other things
held equal.
Steve Rapaport
---
Also, I have to ask the question:
Why is it that Altavista can index terabytes overnight and return
a fulltext boolean for the WHOLE WEB
within a second, and Mysql takes so long?
On Friday 08 February 2002 11:50, Steve Rapaport wrote:
> I second the question. It could also reduce the s
I second the question. It could also reduce the size of the
fulltext index and the time taken to update it.
-steve
> On Thursday 07 February 2002 20:53, Brian wrote:
> > Has anyone made a suggestion or thought about ways to distribute
> > databases which focus on fulltext indexes?
> >
> > ful
st way to do this.
So Monty et al, my request is this: please put on the wish list, enhancement
of FULLTEXT search to approximately match the performance of an indexed
search on 25 million records, on the same hardware and with other things
held equal.
Steve Rapaport
---
Ooops, factual error:
> > If, say, Google, can search 2 trillion web pages, averaging say 70k
> > bytes each, in 1 second, and Mysql can search 22 million records, with
> > an index on 40 bytes each, in 3 seconds (my experience) on a good day,
> > what's the order of magnitude difference? Roughl
I said:
> > Why is it that Altavista can index terabytes overnight and return
> > a fulltext boolean for the WHOLE WEB
> > within a second, and Mysql takes so long?
On Friday 08 February 2002 08:56, Vincent Stoessel wrote:
> Apples and oranges.
Yeah, I know. But let's see if we can make some d
Also, I have to ask the question:
Why is it that Altavista can index terabytes overnight and return
a fulltext boolean for the WHOLE WEB
within a second, and Mysql takes so long?
On Friday 08 February 2002 11:50, Steve Rapaport wrote:
> I second the question. It could also reduce the s
I second the question. It could also reduce the size of the
fulltext index and the time taken to update it.
-steve
> On Thursday 07 February 2002 20:53, Brian wrote:
> > Has anyone made a suggestion or thought about ways to distribute
> > databases which focus on fulltext indexes?
> >
> > ful
Check that your file size limit on your machine is more than the
usual 4GB. I have a 23 million row database, and it translates
into 3GB data file, 3GB index file. 1 billion records would never
fit. My record length is about 300 bytes.
If you need more than a 4GB data file, you should check o
ctly
from one db to another. See "simple powerful copy" in the January
mail list archive.
Steve Rapaport
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On Monday 04 February 2002 03:46, Robert Nagle wrote:
> I realize this is a very elementary question and explained somewhat in
> the mysql manual.
>
> The manual describes three different methods for backing up databases
>
> Copying the files themselves
> using mysqldump to dump all the tables int
The word "Schema" isn't really used in Mysql, it's
just table descriptions. You can save them using mysqldump -d
and read them in using SOURCE.
Try http://www.mysql.com/doc/m/y/mysqldump.html
Steve
In Thursday 31 January 2002 09:50 am, udayashankarl_n wrote:
> Hi!
> Can anybody please point
I'd buy it!
-steve
-Original Message-
From: BD [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 7:23 PM
To: [EMAIL PROTECTED]
Subject: Really good idea on Performance Tuning???
I sent a reply back to JW about his problem on performance tuning and came
up with I thought a re
Use a 48-to 64 bit int. When you print or
calculate, divide by 10^12. It's called fixed-point arithmetic.
-steve
P.S.
Ignore the funny guy talking about the commas, he's never been
outside his country.
-Original Message-
From: Vasoczki Ferenc [mailto:[EMAIL PROTECTED]]
Sent: Wednesda
et it continue or give up? Will this take another 2 days?
another week? Anyone else with experience to get a rule of thumb?
I'm using mysql 3.23.37 on a dual processor intel Redhat, 700Mhz, 1G ram.
--
Steve Rapaport
stil
tions...
>
> Anyone remember where?
This might do, it's in the SELECT syntax. It lists all the
options and mentions that they must be in THAT ORDER.
http://www.mysql.com/doc/S/E/SELECT.html
--
Steve Rapaport
still at large
7;s very
little checking or flexibility. Corrections welcome.
Steve
---cut here------
#!/bin/bash
# copytable olddb newdb table
# (c) Steve Rapaport, 2002.
# Use as desired, keep the credits intact.
set -x
fromdb=$1
todb=$2
table=$3
#===
http://www.mysql.com/information/crash-me.php
> Is there some material available which comapres mySql with Oracle and PostgreSql.
--
Steve Rapaport
still at large
-
Before posting, please check:
http://www.mysql.
are at the bottom of this mail
as I sent them to the
last person who asked.
Best to all,
Steve Rapaport.
Ronnie Garcia wrote:
Hi Steve,
I just found your post about failover and mysql on google (
http://groups.google.com/groups?hl=fr&threadm=a11dqg%242slq%241%40FreeBSD.csie.NCTU.edu.tw&rnum=
ame write only problem and fixed it by doing it.
--
Steve Rapaport
still at large
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To req
James Montebello wrote:
> File permissions?
Nope, tried that.
>
>>mysql> lock table White write;
>>ERROR 1036: Table 'White' is read only
>>
>>
>>How do we make i
mysql> lock table White write;
ERROR 1036: Table 'White' is read only
How do we make it read-write?
--
Steve Rapaport
still at large
-
Before posting, please check:
http://www.mysql.com/manual.php (the ma
and always
faster.
-steve
--
Steve Rapaport
World Citizen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-
it succeeded, but failed to use the indexing. I suspect
that any insight we get from this could help in optimizing db design and
queries in future.
Steve
--
Steve Rapaport
World Citizen
-
Before posting, please check:
ther than noise...
Steve
--
Steve Rapaport
World Citizen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail &l
I noticed that your update says the server just stopped.
Try looking in the server error logs under the mysql directory
hostname.err, (replace hostname with your own),
and it may help tell you what went wrong.
--
Steve Rapaport
World Citizen
ql on boot,
you can run:
/etc/rc.d/init.d/mysql start
if not, try reading the manual about how to run mysql for the first time.
-steve
> mysqltest: Failed in mysql_real_connect(): Can't connect to local MySQL server
>through socket '/var/lib/mysql/mysql.sock' (111)
--
St
Rob
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
&g
kespeare
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list arch
sible to replicate the SQL2000 to a mySQL server?
> (One of the reasons for this is that we have a rather large Sun-server
> which we are not using for anything)
--
Steve Rapaport
World Citizen
-
Before posting, please ch
to a table which has or is referenced in a foreign key constraint, but
> : use DROP TABLE + CREATE TABLE to modify the schema
>
>
--
Steve Rapaport
World Citizen
-
Before posting, please check:
http://www.mysql.co
.Pouvez vous me le confirmer?
En lieu des caractères accentués, qu'est que vous trouvez?
Les memes caractères sans accent, ou quelque chose different?
--
Steve Rapaport
World Citizen
-
Before posting, please check:
tous ARP scheme.
Anyway, I'm currently using scheme 3, and I'll be happy to send you my
half-scripted solution which you are welcome to improve upon. I was also
using scheme 1 before, but gave up after something mis-synchronized the
replication logs and it was
le which has about 15 fields. Is it possible using a
> standard SQL statement to do a full text search on all fields ??
--
Steve Rapaport
World Citizen
-
Before posting, please check:
http://www.mysql.com/manual.php
> Thanks Jaime to reply me message so fast !
> I would like to set 2 different user to maintance MySQL machine.
> 1st user can maintance the Unix box and MYSQL program
> 2nd user ONLY can maintance the MySQL program
Kevin, this should be solved at the MySQL user permissions level,
not at the UNI
http://www.mysql.com/doc/n/o/node_365.html
> Can anyone tell me how many characters a MySQL TEXT field can hold? What's
> the limit?
--
Steve Rapaport
World Citizen
-
Before posting, please check:
http://ww
d, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
--
Steve Rapaport
World Citizen
-
Before posting,
cters
of each field instead of 8 or 12? These index files are just too huge.
Hints?
Steve
--
Steve Rapaport
World Citizen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.
nnect()
to create a connection pool and save the connection overhead.
--
Steve Rapaport
World Citizen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list a
cters
of each field instead of 8 or 12?
Hints?
Steve
--
Steve Rapaport
World Citizen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To req
ble to put arbitrary mysql commands like SHOW
MASTER STATUS into a script. I had assumed I was limited to the
shell-level utilities like mysqlimport and mysqldump.
How exactly do I put the
interactive commands into a script?
I'm on Linux and I can use PHP, Perl, shell, or whatever.
Thank
st archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
--
Steve Rapaport
World Citizen
--
OCK TABLES
>
> Depending on the nature of your queries you may have some conflicts. most
> likely, queries that cause the conflict in this case can be skipped, so if
> you can just add --slave-skip-errors=1062 ( to skip duplicate key errors) in
> the master my.cnf
>
> I will pu
ed
> them is active, and mysqladmin closes its connection when it exits.
> That means that the lock is valid only for the rest of the commands on
> the mysqladmin command line, and I can't really see where any of the
> other commands would benefit from hav
The command FLUSH TABLES WITH READ LOCK has an
equivalent, supposedly, from mysqladmin.
But whatever it is, it's not documented!
I've unsuccessfully tried
mysqladmin flush-tables --with-read-lock
mysqladmin flush-tables --read-lock
What works? Anyone?
--
Steve Rapaport
Wor
-
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTEC
changes to a tgz file and
over to the master
start the master
UNLOCK TABLES on the slave
switch my client over to use the master.
I'm not certain this will preserve the replication and bin files.
Can anyone offer help, this seems to be a pretty commo
changes to a tgz file and
over to the master
start the master
UNLOCK TABLES on the slave
switch my client over to use the master.
I'm not certain this will preserve the replication and bin files.
Can anyone offer help, this seems to be a pretty comm
Thanks, that works! (By the way, my current index has another day and
a half to go!)
steve
Dan Nelson wrote:
>In the last episode (Dec 22), Steve Rapaport said:
>
>>I've got a "Alter table DROP INDEX" that's been running for over 48
>>hours now. I'
ng or not, and how far it has progressed.
Does anyone know how to track the progress of a long Alter Table, or an
indexing op?
--
Steve Rapaport
World Citizen
-
Before posting, please check:
http://www.mysql.com/manual.p
r your table gets, and the more keys you have,
>the longer each one takes. you may consider adding the keys after
>inserting all your data....just a thought.
>
>On Thu, 20 Dec 2001, Steve Rapaport wrote:
>
>>VALinux 2-CPU P3, 800 Mhz, using mysql Ver 11.15 Distrib
VALinux 2-CPU P3, 800 Mhz, using mysql Ver 11.15 Distrib 3.23.37, for
pc-linux-gnu (i686)
Tables are MyISAM.
Computer has 1 GB of memory, tuned for large DBs.
Philip Molter wrote:
>On Thu, Dec 20, 2001 at 08:32:55PM +0100, Steve Rapaport wrote:
>: Okay, here's a tuning/opt
a look at the LOAD INTO command, it was designed specifically for mass
>INSERTs and is well optimized for the procedure.
>
>Sincerely,
>
>Craig Vincent
>
>
--
Steve Rapaport
World Citizen
-
Before posting, p
12)),
KEY lfps (last_name(12),first_name(12),province,street_short(12)),
KEY lfcpa
(last_name(12),first_name(12),city(12),province,street_name(12)),
KEY lfcps
(last_name(12),first_name(12),city(12),province,street_short(12)),
KEY city (city),
KEY province (province),
KEY postal_code (postal_c
error message in the log
that says one of my databases can't be created
because it already exists! (I know it exists,
why are you trying to create it??!!).
Anyway, more details to anyone who volunteers to help...
Best,
Steve
________
Steve Rapaport
CTO, A-Tono
79 matches
Mail list logo