mos wrote:
Chris,
You probably want to know the specific table, so I wonder if it
shows up in the MySQL error logs? Of course you can dump the database
structure and look for key "x" by doing:
mysqldump --no-data --skip-opt --skip-comments --compact
and redirect it out to a text file. Ho
At 09:19 PM 6/22/2007, you wrote:
when you get a duplicate key error it says something to the effect of
"Duplicate entry 'xyz' for key x"
What I want to know is how to find out what table fields are part of key x?
--
Chris,
You probably want to know the specific table, so I wonder if it s
The problem is fixed :D
If someone has the same problem :
With the line
innodb_force_recovery = 2
We could start correctly MySQL and InnoDB, and see that a table was corrupt. We
dropped the table, recreated it from a backup, restarted MySQL normally... and
it works !!
Thanks to you all :)
-
It doesn't look like a memory issue, but only you can tell (turn some of your
parameters to make sure). What does "top" tell you? It's not just how much
memory your machine has, but how much free memory there is.
Did you compile from source, or use a binary distribution? If you picked a
binary
Yes, and
I also saw "InnoDB: Out of memory in additional memory pool.", so I
gave more memory to InnoDB... I don't have the message "out of memory"
any more, but the other errors are still here... and the problem too :/
Here is
my.cnf (with the "skip-innodb" which let mysql starting properl
Did you see this part of the stack trace?
"It is possible that mysqld could use up to key_buffer_size +
(record_buffer + sort_buffer)*max_connections = 182271 K bytes of memory
Hope that's ok, if not, decrease some variables in the equation "
How much memory (MyISAM and InnoDB) are you allocating
Don't forget to allow port 3306 (or whatever port you're server listens on)
through any Windows firewall...
Tim
> -Original Message-
> From: Carlos Proal [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 22, 2007 1:40 PM
> Cc: mysql@lists.mysql.com
> Subject: Re: How do you allow external c
Mysql restricts access outside the server after the installation (on not
all, but several cases) so i suggest to connect to the mysql database as
root and review the host values on the user table, that can give you an
idea of who is allowed and from where is allowed ...remeber that % means
an
Okay :)
Here is the starting of the log, before the infinite loop...
070620 15:17:52 mysqld started
070620 15:17:52 mysqld started
070620 15:17:53 mysqld ended
070620 15:17:54 InnoDB: Out of memory in additional memory pool.
InnoDB: InnoDB will start allocating memory from the OS.
InnoDB: Yo
I had this issue, so just wanted to know, even if you have the same error
message.
regards
anandkl
On 6/22/07, Julien Marchand <[EMAIL PROTECTED]> wrote:
No, I don't have this error :/ And not any file system full issue...
- Message d'origine
De : Ananda Kumar <[EMAIL PROTECTED]>
À
No, I don't have this error :/ And not any file system full issue...
- Message d'origine
De : Ananda Kumar <[EMAIL PROTECTED]>
À : Julien Marchand <[EMAIL PROTECTED]>
Cc : mysql@lists.mysql.com
Envoyé le : Vendredi, 22 Juin 2007, 13h45mn 12s
Objet : Re: InnoDB: Assertion failure - MySQL k
You may have encountered a bug; one thing you could do to avoid having to
downgrade is specify the column number you wish to sort on (4th column in
your case), as in:
ORDER BY 4 DESC LIMIT 10;
Dan
On 6/22/07, Andrew Carlson <[EMAIL PROTECTED]> wrote:
I upgraded to Mysql 5.0.42 from 4.1.14 ye
Does that explain why, using ODBC 3.x, I can't retrieve Chinese characters
with Access? I never noticed that there was no Unicode support, no wonder
I've been beating my head against a wall.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT
I upgraded to Mysql 5.0.42 from 4.1.14 yesterday. Afterwards, a query the I
run every day to capture data on nodes that have increased backup load the
most in TSM, seems to be ignoring my "order by" statement. Here is the query
and the output:
mysql> select occupancy.node_name as NodeName,nodet
Hi Julien,
Do you see any "InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock /var/lib/mysql/ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files."
of these error in the error log file. W
Hello,
My MySQL keeps crashing and restarting, and I get this log, which repeats
indefinitely:
Number of processes running now: 0
070622 13:01:46 mysqld restarted
070622 13:01:46 InnoDB: Out of memory in additional memory pool.
InnoDB: InnoDB will start allocati
Dear All,
I've just posted this to MySQLdb help forum but maybe
there is a mysql way of getting what I want and you could,
time permitting, help me.
First my setup:
* Python 2.5
* MySQL 5.0.27-standard-log (MYISAM tables)
* MySQLdb.version_info (1, 2, 2, 'gamma', 1)
I have the following stateme
At 12:11 PM +0530 6/22/07, Ratheesh K J wrote:
Hello All,
I want a clarification. Whe run a forum wherein people send messages
with/without attachments. Attachments may contain images, documents
etc.. We are actually storing the attachment in a blob column.
Sometimes the attachments are big.
We had setup replication and it was working till the file system became 100%
full, after that it stopped.
On 6/21/07, Atle Veka <[EMAIL PROTECTED]> wrote:
Sounds like Gerald is right, your database server is not configured to
support replication. Have you given your database server a 'server-id
19 matches
Mail list logo
