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
...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
, 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 database
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 - Milano 20123
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
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
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
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
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
-
elenco2g]#
Fix:
No clue, this happens every time.
Submitter-Id: submitter ID
Originator:Steve Rapaport
Organization: A-Tono
MySQL support: none
Synopsis: Indexing fails, myisamchk cannot repair, no error msg.
Severity: serious
Priority: high
Category: mysql
Class
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
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
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
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
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
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
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
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.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
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? Roughly 10^9.
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
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
, 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 story so far.
Steve Rapaport
Director, Technical Services
A-Tono
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?
fulltext
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 size
, 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
-
Before posting, please check:
http
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? Roughly 10^9.
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
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?
fulltext
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 size
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/ (the list archive)
To request this thread, e-mail
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 into a
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 me
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:
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
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
still at large
---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
#===
dbdir=/var/lib/mysql/
topath=${dbdir}${todb}/
frompath=${dbdir}${fromdb
?
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
-
Before posting, please check:
http
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=frthreadm=a11dqg%242slq%241%40FreeBSD.csie.NCTU.edu.twrnum=7prev=/groups%3Fq
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 manual)
http
James Montebello wrote:
File permissions?
Nope, tried that.
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
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 request
. And
then apparently proceeds to scan each row, converting phone_no to an integer to
compare to the constant.
Seems naive to me, since the datatype of the field is known, why not convert
the constant instead? Then everything would work at least as well, and always
faster.
-steve
--
Steve
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:
http://www.mysql.com/manual.php
://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 PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Steve Rapaport
World Citizen
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)
--
Steve Rapaport
World Citizen
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
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 (the manual
to improve upon. I was also
using scheme 1 before, but gave up after something mis-synchronized the
replication logs and it was impossible to recover.
If you get scheme 2) to work, let me know, I might want to change.
--
Steve Rapaport
World Citizen
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:
http://www.mysql.com/manual.php
DROP TABLE + CREATE TABLE to modify the schema
--
Steve Rapaport
World Citizen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
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 check:
http://www.mysql.com/manual.php
PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Steve Rapaport
World Citizen
-
Before posting, please check:
http://www.mysql.com
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 UNIX
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://www.mysql.com
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.com
://lists.mysql.com/php/unsubscribe.php
--
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
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.
Thanks!
Steve
--
Steve Rapaport
World
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 request this thread, e
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 archive)
To request
) in
the master my.cnf
I will put the above in the manual...
--
Steve Rapaport
World Citizen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
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 common case.
-steve
--
Steve Rapaport
World Citizen
://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 PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Steve Rapaport
World Citizen
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
World Citizen
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 having locked tables.
--
Steve Rapaport
World Citizen
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 common case.
-steve
--
Steve Rapaport
World Citizen
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.php (the manual)
http
)),
KEY city (city),
KEY province (province),
KEY postal_code (postal_code)
) TYPE=MyISAM;
Thanks in advance for any ideas!
--
Steve Rapaport
World Citizen
-
Before posting, please check:
http
INSERTs and is well optimized for the procedure.
Sincerely,
Craig Vincent
--
Steve Rapaport
World Citizen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
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 problem for you
you have,
the longer each one takes. you may consider adding the keys after
inserting all your datajust a thought.
On Thu, 20 Dec 2001, Steve Rapaport wrote:
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
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
Via Amedei
72 matches
Mail list logo