.
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.
Any insight appreciated.
Nick
--
Nick Arnett
[EMAIL PROTECTED]
Messages: 408-904-7198
--
MySQL General Mailing List
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
, 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 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
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
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
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
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
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?
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
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
For list archives
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 that a
...
--
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]
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 have the basic idea of
relational data.
Nick
--
Nick Arnett
-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. W2K
, 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 PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
-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 iterating, urls, comes from
-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 Billion records
-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 insert that
-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 varchar unless
-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 until
-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:/# starting
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]
Subject: Pre parsing
Hi,
Anyone know
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 Mailing List
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: http://lists.mysql.com/mysql
To unsubscribe
-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 BY
-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
retrieved, trying to load all
. 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 Mailing List
For list archives: http
-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 able to
-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 back
.
--
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: 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 fulltext indexing?
Nick
--
MySQL
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
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:
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
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
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
-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 returns an error:
File C
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
-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 get
maximum performance when making
-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 the
-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 poster to
-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 that is
-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 last few
-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: 0
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
-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... open
49 matches
Mail list logo