I have a simple single-table SELECT query that takes of several
minutes to complete, due to a very large number of result rows being
involed. I don't think there is any way to optimise the query - MySQL
is already using the appropriate index etc, it's just a huge table and
the query has a large res
Miles Thompson <[EMAIL PROTECTED]> wrote:
> At 07:56 AM 11/1/2006, Leandro Guimarães Faria Corcete DUTRA wrote:
> > .. further notices; and SolidDB, which
> >is still β.
>
> Help this poor English-speaker - what's the symbol you use to describe
> SolidDB?
I assume it is a "beta" character, sin
We are using MySQL 5.0.27 on RedHat Enterprise Linux ES release 4,
and the MySQL-python-1.2.1_p2 connector.
We are getting intermittent mysterious errors as follows:
OperationalError:
(2013, 'Lost connection to MySQL server during query')
when attempting to connect to the MySQL server (not
On Wed, May 09, 2007 at 09:22:34AM -0400, Michael Dykman wrote:
> I realize that's quite unlikely that you have performed a similar
> sloppy import but there is likely some edge condition on your server
> (wierd permissions in the data directory, corruoted tables, etc.)
> but I still recommend that
On Wed, May 09, 2007 at 11:17:59AM -0400, Michael Dykman wrote:
> When we first examined our server logs, we saw the same.. in our case
> (again) it was only when we slowed down and examined the timestamps on
> the start/stop messages that we realized that the server was
> restarting at unexpected
On Wed, May 09, 2007 at 07:14:38PM +0200, Martijn Tonies wrote:
> >I have a table of properties that is linked to a table f images with a one
> property to many images relationship. I >have manged this with nested
> queries but want to try and do it on one line. My current query
> >
> >$query = "S
On Wed, May 09, 2007 at 10:07:41PM -0400, Mathieu Bruneau wrote:
> We found a similar issue because we were using persistent connection in
> php and had a firewall between the mysql and the webserver. The problem
> is that our persistent connection were setup for lasting up to something
> like 8 ho
On Thu, May 10, 2007 at 03:37:26AM +0100, Jon Ribbens wrote:
> I've just upgraded all the clients and servers to 5.0.41 (which looks
> like it just came out); I'll see what happens.
It hasn't solved the problem, but it has changed the error message to:
OperationalEr
On Thu, May 10, 2007 at 08:58:37AM -0600, mos wrote:
> If you do a google search:
> http://www.google.ca/search?q=lost+mysql+connection+%22reading+authorization+packet%22&hl=en&start=90&sa=N
>
> you'll find about a hundred web sites encountering the exact same error.
Indeed, I noticed that ;-)
On Thu, May 10, 2007 at 05:17:12PM +0100, Jon Ribbens wrote:
> I suspect some sort of bug in the MySQLd authentication code.
I've managed to discover using --debug that it's due to MySQLd failing
to handle EINTR from read() in the authentication stage.
I've filed
On Tue, May 15, 2007 at 04:13:33PM -0500, Kenneth Loafman wrote:
> Can't tell. The docs are somewhat lacking in detail, however, if I do a
> db.autocommit(True) it works as it should.
>
> Will have to dig into the API code and see if that is where the semantic
> discontinuity lies.
The MySQL-p
On Tue, May 15, 2007 at 06:39:21PM -0500, Kenneth Loafman wrote:
> Interesting... guess the intent was a disconnect that would break code
> trying to work on MySQL, regardless of engine selected. That decision
> makes it two products, MySQL/MyISAM and MySQL/InnoDB with different
> semantics. Y
On Mon, Jun 04, 2007 at 02:44:25PM -0700, Daevid Vincent wrote:
> Thanks for the magazine. I already incorporated a little extra SQL
> injection checking into my db.inc.php wrapper...
>
> //[dv] added to remove all comments (which may help with SQL injections
> as well.
> $sql = preg_replace("/#.*
On Wed, Jun 06, 2007 at 05:56:44PM -0700, Peter Rosenthal wrote:
> On 04/06/07, Jon Ribbens <[EMAIL PROTECTED]> wrote:
> >Um, what? Both that and the methods described in the magazine are
> >completely wrong. You use mysql_real_ecape_string(), that's it.
>
>
On Fri, Jun 08, 2007 at 03:14:18PM +0530, Ananda Kumar wrote:
> How do i give only select privilege to a specific database.
>
> GRANT SELECT ON abc.* to 'ab'@'%' identified by 'ab';
Like that.
> mysql> select select_priv from user where user='qa';
> +-+
> | select_priv |
> +-
On Fri, Jun 08, 2007 at 04:25:00PM +0530, Ananda Kumar wrote:
>So, what ever i did is right?
Yes. User 'ab' can SELECT on all tables in database 'abc'.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Tue, Jun 12, 2007 at 11:09:41AM -0400, kalin mintchev wrote:
> > I guess a lot of that depends what an acceptable query execution time for
> > you is.
>
> well... i don't really know. 30 secs maximum?! i've never worked with
> such huge tables. 3 - 5 million records is fine but i've never work
On Wed, Jun 13, 2007 at 12:50:03PM -0700, Mufaddal Khumri wrote:
> mysql> select * from t1 where sid != 2;
>
> As you can see, the rows that had sid = NULL did not get returned in
> the results when i did "... where sid != ; "
>
> Question: Is this behaviour correct and is in accordance to the
Does nobody have any ideas on this? It's quite perplexing.
It's MySQL "Ver 14.6 Distrib 4.1.5-gamma", if it makes a difference.
Jon Ribbens <[EMAIL PROTECTED]> wrote:
> I am getting Error 136 "No more room in index file" on a table,
> but the table doe
I am getting Error 136 "No more room in index file" on a table,
but the table does not appear to be full in any way. As you can see
from the "myisamchk -dv" output below, both the datafile length and
the keyfile length are much smaller than their respective maximums.
The table is on a Linux ext3 pa
20 matches
Mail list logo
