that I get this problem even when the
temporary table doesn't exist, on a brand-new connection.
I've had this code running for a couple of weeks and just noticed the
problem, so I'm not sure if it cropped up right away or not. Haven't
had a chance to bounce the server yet.
ut the stored procedure debugger -- does all the
functionality in the documentation work with MySQL? Anybody used this with
MySQL, who could describe their experience with it?
I would really love a good SP debugger!
Nick
--
Nick Arnett
[EMAIL PROTECTED]
Messages: 408-904-7198
ll let me use the function.
I hit a problem using functions in stored procedures, too, and I'm wondering
if these are related.
Nick
--
Nick Arnett
[EMAIL PROTECTED]
Messages: 408-904-7198
I have Python code that I run on Windows and Solaris. It works properly
on Windows. However, on Solaris, when it inserts records, datetime
columns end up with a value of zero. I suspect that this began
happening after we upgraded the MySQL server to 4.1.10 from a 4.0.x
version (I think we we
We have something I can't figure out happening on one of our servers. It's
running 4.0.23 on OSX.
One of the InnoDB tables is locked even though we can't see any process that is
even active that
could have locked it. SHOW OPEN TABLES doesn't show it as in use or locked.
We've tried all sorts
[EMAIL PROTECTED] wrote:
Your solution is as good as any I can think of. If your source tables
are InnoDB you could wrap your SELECT/UPDATE processing in a transaction
to help make it even more robust. It might speed things up if you omit
the offset to your LIMIT clause and just do:
Yes, they ar
I'm considering the best strategy for updating large tables that I'm indexing with Lucene. I'm
indexing in chunks of 5000 items at a time, which I select with LIMIT statements and an incremental
multiplier (SELECT blah FROM foo LIMIT 0, 5000; SELECT blah FROM foo LIMIT 5000, 5000; etc.).
After
Peter Brawley wrote:
is, there is some method to iterate in this relation to avoid joining
the table in itself each time ?
Exactly the problem with trying to model an anything-goes network, a
"world of ends", in a relational model of a directed graph. I think
you need an XML layer in there, eg
listsql listsql wrote:
Since I read about Foaf [ http://www.foaf-project.org/ ], I become
interested with Social Networking,
What you're doing is often called link analysis -- searches on that term
may yield more for you to chew on. There are software tools and
visualization tools for answerin
I'm updating one table with data from another and finding that the
server is doing a table scan on the second table, even though it's a
simple join on the primary keys. This doesn't seem right. The query
looks liket this:
UPDATE a SET a.y TO b.a WHERE a.primary_key = b.primary_key
and if I do
symbulos partners wrote:
Is there any other workaround? The reason because we are using InnoDB is
because there s full support
- for foreign keys,
- for joint queries
- for rollback on commit
Does anybody know any other way of indexing the table in a way, which would
allow full text search?
Dathan Pattishall wrote:
Use char
And use fixed-length types for *all* columns... one variable-length
column makes all records variable-length.
Nick
-Original Message-
From: Marc Michalowski [mailto:[EMAIL PROTECTED]
Sent: Friday, January 28, 2005 10:28 AM
To: mysql@lists.mysql.com
S
27;s what I was just reading!
So... is this the equivalent of using BEGIN and COMMIT, for which I have
methods in the Python MySQLdb module? Or is there an advantage to the
latter?
Thanks again,
Nick Arnett
Director of Business Intelligence Services
Liveworld Inc.
--
MySQL General Mailing List
Fo
Heikki Tuuri wrote:
* Do not acquire an internal InnoDB table lock in LOCK TABLES if
AUTOCOMMIT=1. This helps in porting old MyISAM applications to InnoDB.
InnoDB table locks in that case caused very easily deadlocks.
Could you explain a bit more about how this relates to MyISAM? Is it
just tha
I don't see a way to ask MySQL what the "full" name of a table is... the
equivalent of this:
SELECT CONCAT(DATABASE(), ".", "table_name")
which would return something like this (assuming the current database is
called "my_database":
my_database.table_name
The reason I want this is to ensure tha
no longer a
transaction.
The culprit was some table locking that improved performance quite a bit
when the tables were MyISAM. Gotta go look for more of those lurking in the
corners, I guess.
--
Nick Arnett
Phone/fax: (408) 904-7198
[EMAIL PROTECTED]
> -Original Message-
> Fr
> -Original Message-
> From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 29, 2003 12:58 PM
> crash recovery is usually much faster than purge and merge.
>
> Killing the mysqld process is a legal (and the fastest :)) way of shutting
> down InnoDB.
That's good to hear. W2
n to find out who uses a
given application, the query would be along these lines (this uses the
column 'app_id' as the key:
SELECT used_by FROM nms_apps, user WHERE nms_apps.app_id = user.app_id AND
app_name = "Application Foo"
Hope that helps. If you grasp this, you'll
e future?
Thanks for any info...
--
Nick Arnett
Phone/fax: (408) 904-7198
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 17, 2003 9:38 PM
> To: Nick Arnett; [EMAIL PROTECTED]
Well, Paul, just knowing you were on the job inspired me and I finally
realized the dumb thing I'd done. The list I'm
ght near the beginning of the HTML, where it has lots of (annoying, I
suppose) backslashes, quotes and other stuff that is a pain to encode
properly by hand.
Any help will be most gratefully accepted. My hair will thank you, too.
Nick
--
Nick Arnett
Phone/fax: (408) 904-7198
[EMAIL PROTE
> -Original Message-
> From: Adam Murphy [mailto:[EMAIL PROTECTED]
> Sent: Saturday, May 31, 2003 10:48 PM
> To: [EMAIL PROTECTED]
> Subject: MYSQL DB PROBLEM
>
>
>
> I am trying to insert a table ibf_posts
>
> into a localhost database using the MYSQL control center every
> time i try to i
> -Original Message-
> From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]
> Sent: Saturday, May 31, 2003 12:05 PM
> To: 'Ulterior'; [EMAIL PROTECTED]
> Subject: RE: Insert query
>
>
> Hi,
>
> I would use mediumint rather than int for the ID column (int has
> support for
> up to 2.1 Bill
> -Original Message-
> From: Mikey [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 30, 2003 11:53 AM
> To: [EMAIL PROTECTED]
> Subject: Why doesn't this query work?
>
>
> OK, first of all thanks for the pointers, however, the query I now have
> doesn't seem to work. If I run the query up unt
> -Original Message-
> From: Ulterior [mailto:[EMAIL PROTECTED]
> Sent: Saturday, May 31, 2003 7:35 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Insert query
>
>
> sow what would you suggest, Jerry?
>
> ( I need a very FAST search on this table's filename field)
>
> Ulterior
>
> > Don't use va
> -Original Message-
> From: Rehaz Golamnobee [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 29, 2003 3:41 AM
...
> I have just upgraded my MySQL from version 3.23 to 4.0.13.
>
> However I cannot start the server. When I type mysqld_safe & I
> get the following :
>
> [1] 1730
> Linux:/#
You could pre-pend "EXPLAIN" and see if it generates an error.
--
Nick Arnett
Phone/fax: (408) 904-7198
[EMAIL PROTECTED]
> -Original Message-
> From: Jerry [mailto:[EMAIL PROTECTED]
> Sent: Friday, April 04, 2003 5:46 AM
> To: [EMAIL PROTECTED]
> Subjec
yone confirm that wildcards, indeed,
can't be used in phrase searches. I'm doing these in Boolean mode because I
need exact counts of occurrences. This is on MySQL-4.0.12-nt.
Nick
--
Nick Arnett
Phone/fax: (408) 904-7198
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives
I've searched and searched, but I can't find anything that describes the
format of a custom stopword file for fulltext indexing in MySQL. Anybody
have a pointer or a description of the format?
Nick
--
Nick Arnett
Phone/fax: (408) 904-7198
[EMAIL PROTECTED]
--
MySQL General Mailin
> -Original Message-
> From: Nick Arnett [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 25, 2003 8:48 AM
...
> Just noticed something odd, though, with the MySQLdb SSCursor.
> When close()
> is called, it does a fetchall(), getting any records that you hadn't
> -Original Message-
> From: Joseph Bueno [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 25, 2003 1:36 AM
..
> If you want to speed it up, you have to make it use an index.
> You need to add a WHERE or an ORDER BY clause.
> Have you tried :
> SELECT Message_ID, Body FROM Body_etc ORDER
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 24, 2003 9:17 PM
> Please post the query and the output of running it thru EXPLAIN.
>
> It is likely sorting the results without an index and having to weed
> thru more and more records the farther
> -Original Message-
> From: Brian [mailto:[EMAIL PROTECTED]
...
> I have a client with approximately 2 gigabytes of un-indexed
> document files
> (includes text and graphics).
>
> He wants to be able to enter a few parameters and bring up a list of all
> documents that fit, and then be a
dropped
tremendously. I'm guessing that that's where index caching was no longer
sufficient...?
I've optimized, analyzed and defragmented the disk, all of which seemed to
help a bit.
Nick
--
Nick Arnett
Phone/fax: (408) 904-7198
[EMAIL PROTECTED]
--
MySQL General M
> -Original Message-
> From: Nick Arnett [mailto:[EMAIL PROTECTED]
> Sent: Sunday, March 23, 2003 1:39 PM
At the risk of talking to myself too much... I've tried creating a table
that has about 100 records with lots of characters with ASCII > 126 and have
no problem bu
> -Original Message-
> From: Nick Arnett [mailto:[EMAIL PROTECTED]
...
> It dawned on me that perhaps the problem had to do with double-byte
> characters,
Actually, what I think I meant to say was "unprintable" characters with
ASCII > 122. Does this break
expertise in
that area -- I used to be the product manager for advanced technology at
Verity.
--
Nick Arnett
Phone/fax: (408) 904-7198
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
That syntax will always report zero rows affected, but it is very fast. If
you want to know how many rows were deleted, use something like "DELETE *
FROM Sqs WHERE 1=1".
The latter query will be much slower, as it examines each record.
Nick
> -Original Message-
> From: Bhavin Vyas [mai
Can anyone confirm that it is *not* possible to pass a list to the Python
MySQLdb module in UPDATE operations? In other words, this kind of thing
works:
self.dbh.execute("INSERT INTO Foo (blah, blorg,snork) VALUES
(%s,%s,%s)",myList)
... But this kind doesn't appear to work for me:
self.dbh.ex
I'm finding that it's not quite as simple as I had imagined to maintain a
table whose values are calculated by analyzing other tables. The source
tables contain time series data, which can is updated several times a day.
To calculate totals by day, week, month, etc., I don't want to have to start
I'm wondering if there's a way to use the results of a SELECT in an UPDATE
operation, the way that it's possible to do so with INSERT and REPLACE.
This seems like it should be possible, but as far as I can tell, it's not.
This comes up for me repeatedly, but the problem at hand is identifying the
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Nick Arnett
[snip]
> What seemed to be the obvious solution was to use
> MySQLdb.times.format_TIMESTAMP() or MySQLdb.times.format_DATE()-- but that
> doesn't work, it retur
I'm have a bit of trouble figuring out how to use a date field retrieved
from MySQL when updating a record in another table. Rather than a date
string, MySQLdb returns a DateTime object. At first, imagining that since
it came out of a field, the date object would also then match the field in a
s
> -Original Message-
> From: Nick Arnett [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, April 21, 2002 3:39 PM
> To: [EMAIL PROTECTED]
> Subject: How to speed up mods to large table?
>
>
> I haven't been able to dig up any specific information about how to g
I haven't been able to dig up any specific information about how to get
maximum performance when making changes to large tables. I have a table
that's close to 4 GB, which I'm altering to come up with the best trade-off
between performance and speed. Dropping a column or an index seems
exceeding
> -Original Message-
> From: Doug Bishop [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 10:13 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: Table statistics
>
>
> Try:
>
> mysql_connect("localhost", "user", "password");
...
Might be helpful to the original
> -Original Message-
> From: Russell E Glaue [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 7:15 AM
...
> Does anyone on this list have a suggestion as what might be the best
> language to embed into MySQL? Be sure to consider memory efficiency,
> threadding, speed of th
> -Original Message-
> From: DL Neil [mailto:[EMAIL PROTECTED]]
...
> Which begs the questions:
> - in what way are you analyzing "behavior"? and
> - in what way are you analyzing this list-community?
"There's too much to read," is the simple answer to the first question.
Over the las
> -Original Message-
> From: Ben Holness [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 28, 2002 7:43 AM
> Have I understood the two table concept correctly?
> How does the third table fit in?
>
> I guess that if two (or more) of the entries overlap, I could make things
> even
> -Original Message-
> From: Ben Holness [mailto:[EMAIL PROTECTED]]On Behalf Of
> [EMAIL PROTECTED]
...
> My question is this: Would it be more efficient to have each entry in the
> list stored in this table in the database, or would I be better
> off having a
> reference to a file tha
> -Original Message-
> From: Maribel Piloto [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, March 24, 2002 10:24 AM
[snip]
> The data is loading fine and the NULL values are in fact
> correctly entered
> as NULLs but I'm getting this warning after the LOAD statement:
>
> Records: 3 Deleted
> -Original Message-
> From: Roger Baklund [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 21, 2002 4:03 PM
[snip]
> It looks like you have the CRLF problem... Python on win platform outputs
> CRLF for '\n', because that is normally the wanted line ending on windows
> systems... ope
I have something odd happening with a bulk insert file and haven't been able
to find anything in docs or archives that gives me a clue what's going on.
I'm creating a bulk insert file programmatically with Python. Everything
seems to work fine, except that in the last field of each record, a retu
53 matches
Mail list logo
