On Fri, Jan 28, 2005 at 04:00:24PM +, Mat wrote:
> What Operating System are you running this on?
Linux 2.6, 64 bits.
MySQL 4.1.9.
> Also, is there anything in the errorlog?
Nothing, but as soon as I restart the server, it enters a strange state
where all slots are full with unauthenti
Is there a limit on the size of .MYI files?
I have a database that worked flawlessly until today. I can't restart it,
it immediately freezes.
I noticed that the .MYI file of a table has reached exactly 2 gigs.
May it be related? Is there anything to do in order to recover the data
an
It looks like the default thread stack is not large enough for MySQL 4.1
on Linux running on AMD64.
With NPTL, the database quickly crashed after a few hours of heavy load
(segv).
Without NTPL, I believed it wasn't the case. But after one week mysqld
process were stuck in a strange state.
Just wondering... I have this simple join:
SELECT b.id_commentaire AS id_commentaire, id_skynaute, id_article,
created_on, read, expediteur, email, text FROM comment_base AS b LEFT JOIN
comment_content AS c USING (id_commentaire) WHERE id_skynaute = 4671022 AND
id_article = 58366086;
id_com
Just curious...
While running SHOW INNODB STATUS, the "list of transactions for each
sessions" part shows queries that are only related to MyISAM tables.
Is it the expected behavior?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://
On Wed, Dec 08, 2004 at 11:25:55AM +0100, Bogdan TARU wrote:
> Everything went
> ok, up until the point when I tried linking PHP-4.3.9 against
> MySQL-4.1.7. After starting the new Apache/PHP (ldd httpd shows
> '/usr/local/mysql-4.1.7/lib/mysql/libmysqlclient.so.14'), I get a
> whole lot of Se
On Wed, Feb 19, 2003 at 10:43:41AM +0059, Jedi/Sector One wrote:
> Ok, except speculation on real life, there's no correct way to handle
> this.
Self-correction : it looks like MySQL returns ER_DUP_ENTRY when an
overflow occurs, even with InnoDB tables.
Great :)
--
__ /*-
od, I guess.)
> http://marc.theaimsgroup.com/?l=mysql&m=94495471802684&w=2
Ok, except speculation on real life, there's no correct way to handle
this.
--
__ /*- Frank DENIS (Jedi/Sector One) <[EMAIL PROTECTED]> -*\ __
\ '/http://www.PureFTPd.Org/";> S
--
__ /*- Frank DENIS (Jedi/Sector One) <[EMAIL PROTECTED]> -*\ __
\ '/http://www.PureFTPd.Org/";> Secure FTP Server \' /
\/ http://www.Jedi.Claranet.Fr/";> Misc. free software \/
-