|
What could cause a table to 'crash' and should be repaired?
|
463 |
Simon Goodman
|
11/14/2012 12:43AM
|
|
Re: What could cause a table to 'crash' and should be repaired?
|
249 |
Rick James
|
11/14/2012 09:39PM
|
|
Re: What could cause a table to 'crash' and should be repaired?
|
304 |
Simon Goodman
|
11/15/2012 02:49AM
|
|
Re: What could cause a table to 'crash' and should be repaired?
|
248 |
Aftab Khan
|
11/20/2012 06:15AM
|
|
issue with rename table to new database
|
393 |
Alex McIntosh
|
11/05/2012 10:09AM
|
|
Re: issue with rename table to new database
|
246 |
Rick James
|
11/06/2012 11:48PM
|
|
dedlocks between "update limit N" and "update by primary key"
|
370 |
boa B
|
11/06/2012 07:15AM
|
|
MySQL 5.0 + Innodb plugin
|
398 |
Aurelien PANIZZA
|
11/02/2012 03:09AM
|
|
Re: MySQL 5.0 + Innodb plugin
|
255 |
Rick James
|
11/03/2012 09:34AM
|
|
Re: MySQL 5.0 + Innodb plugin
|
283 |
Aurelien PANIZZA
|
11/03/2012 10:13AM
|
|
Re: MySQL 5.0 + Innodb plugin
|
248 |
Rick James
|
11/04/2012 10:46AM
|
|
Re: MySQL 5.0 + Innodb plugin
|
242 |
Aurelien PANIZZA
|
11/05/2012 03:24AM
|
|
Index re-creation after composite primary key change
|
443 |
Jakub G
|
11/01/2012 09:56AM
|
|
Re: Index re-creation after composite primary key change
|
306 |
Rick James
|
11/02/2012 08:29PM
|
|
Re: Index re-creation after composite primary key change
|
278 |
Jakub G
|
11/03/2012 07:45AM
|
|
last_insert_id function always returns same value
|
383 |
Rhydian Edwards
|
11/01/2012 06:49AM
|
|
Re: last_insert_id function always returns same value
|
235 |
Rick James
|
11/02/2012 11:41PM
|
|
Possible? Restore tables from ib_logfile1, no binary logs
|
505 |
Miltos P
|
10/27/2012 06:54AM
|
|
Re: Possible? Restore tables from ib_logfile1, no binary logs
|
259 |
Rick James
|
10/29/2012 09:14AM
|
|
Re: Possible? Restore tables from ib_logfile1, no binary logs
|
291 |
Miltos P
|
10/31/2012 06:35AM
|
|
Re: Possible? Restore tables from ib_logfile1, no binary logs
|
259 |
Rick James
|
11/01/2012 10:59PM
|
|
drbd on ubuntu
|
343 |
satya dixit
|
10/31/2012 03:36AM
|
|
Error connecting to DB in site
|
358 |
mostafa hoo
|
10/31/2012 03:35AM
|
|
From production to archive ..
|
472 |
Mike Moran
|
09/28/2012 09:42AM
|
|
Re: From production to archive ..
|
303 |
Rick James
|
10/01/2012 07:22PM
|
|
Re: From production to archive ..
|
248 |
Mike Moran
|
10/30/2012 10:50AM
|
|
Re: From production to archive ..
|
260 |
Rick James
|
10/30/2012 12:51PM
|
|
Re: From production to archive ..
|
261 |
Mike Moran
|
10/04/2012 08:24AM
|
|
Re: From production to archive ..
|
237 |
Rick James
|
10/07/2012 04:54PM
|
|
Re: From production to archive ..
|
263 |
Mike Moran
|
10/30/2012 09:48AM
|
|
Re: From production to archive ..
|
253 |
Jonathan Stephens
|
10/08/2012 02:36AM
|
|
Re: From production to archive ..
|
259 |
Jonathan Stephens
|
10/05/2012 01:53AM
|
|
innodb_file_per_table and Data Directory
|
436 |
J Awbe
|
10/28/2012 11:37AM
|
|
Re: innodb_file_per_table and Data Directory
|
264 |
Rick James
|
10/29/2012 09:05AM
|
|
Error connecting to DB
|
470 |
Chuck Doglus
|
10/25/2012 07:52AM
|
|
Re: Error connecting to DB
|
267 |
Scott Nemes
|
10/25/2012 09:37AM
|
|
Re: Error connecting to DB
|
302 |
Chuck Doglus
|
10/25/2012 08:31AM
|
|
how to recover innodb corruption
|
839 |
rajesh ghiya
|
10/14/2012 07:42AM
|
|
Unique key and NULL values
|
597 |
Recoil UK
|
10/13/2012 03:53AM
|
|
The ibdata1 file grows too large with innodb_file_per_table
|
597 |
justin ux
|
10/10/2012 01:23AM
|
|
Re: The ibdata1 file grows too large with innodb_file_per_table
|
365 |
Rick James
|
10/10/2012 09:33PM
|
|
Minimal example of using select… for update to isolate rows
|
566 |
Jesvin Vattamattom
|
10/06/2012 08:46AM
|
|
Re: Minimal example of using select… for update to isolate rows
|
272 |
Rick James
|
10/07/2012 04:32PM
|
|
Innodb_buffer_pool_pages_free = 0
|
613 |
Douglas Nelson
|
09/24/2012 10:31AM
|
|
Re: Innodb_buffer_pool_pages_free = 0
|
353 |
Rick James
|
09/25/2012 10:44AM
|
|
Re: Innodb_buffer_pool_pages_free = 0
|
337 |
Aftab Khan
|
09/26/2012 03:21PM
|
|
Re: Innodb_buffer_pool_pages_free = 0
|
298 |
Douglas Nelson
|
09/26/2012 06:06PM
|
|
Re: Innodb_buffer_pool_pages_free = 0
|
293 |
Aftab Khan
|
09/27/2012 01:49AM
|
|
Re: Innodb_buffer_pool_pages_free = 0
|
559 |
Douglas Nelson
|
09/27/2012 02:48AM
|
|
Re: Innodb_buffer_pool_pages_free = 0
|
376 |
Aftab Khan
|
09/27/2012 03:57AM
|
|
InnonDB logfile size mismatch
|
453 |
amritansu ray
|
09/25/2012 09:39AM
|
|
Re: InnonDB logfile size mismatch
|
249 |
Aftab Khan
|
09/26/2012 03:42PM
|
|
Restoring raw innodb table files from replication server
|
666 |
Ricardo Oliveira
|
09/21/2012 07:10PM
|
|
Re: Restoring raw innodb table files from replication server
|
298 |
Rick James
|
09/24/2012 12:23AM
|
|
Re: Restoring raw innodb table files from replication server
|
330 |
Ricardo Oliveira
|
09/24/2012 12:38AM
|
|
Re: Restoring raw innodb table files from replication server
|
294 |
Rick James
|
09/24/2012 11:48PM
|
|
Re: Restoring raw innodb table files from replication server
|
281 |
Ricardo Oliveira
|
09/25/2012 01:34AM
|
|
Re: Restoring raw innodb table files from replication server
|
305 |
Rick James
|
09/25/2012 09:06PM
|
|
Re: Restoring raw innodb table files from replication server
|
271 |
Ricardo Oliveira
|
09/25/2012 10:18PM
|
|
Re: Restoring raw innodb table files from replication server
|
283 |
Aftab Khan
|
09/26/2012 03:14PM
|
|
A question for the developers about isolation level Repeatable-Read
|
485 |
David Smith
|
09/21/2012 03:36AM
|
|
Re: A question for the developers about isolation level Repeatable-Read
|
255 |
Rick James
|
09/24/2012 11:45PM
|
|
Re: A question for the developers about isolation level Repeatable-Read
|
319 |
David Smith
|
09/25/2012 02:11AM
|
|
X lock on the same gap
|
494 |
Boris Serebrov
|
09/24/2012 09:13AM
|
|
Delete Query Taking Too Much Resources
|
449 |
Vipin Kumar R Jaiswar
|
09/21/2012 01:13AM
|
|
Re: Delete Query Taking Too Much Resources
|
248 |
Aftab Khan
|
09/21/2012 05:20AM
|
|
Re: Delete Query Taking Too Much Resources
|
259 |
Vipin Kumar R Jaiswar
|
09/23/2012 10:44PM
|
|
Re: Delete Query Taking Too Much Resources
|
304 |
Rick James
|
09/24/2012 12:31AM
|
|
Problems with temporary InnoDB tables after Crash
|
661 |
Erich Jakubczyk
|
09/18/2012 01:20AM
|
|
Re: Problems with temporary InnoDB tables after Crash
|
284 |
Rick James
|
09/18/2012 11:31PM
|
|
SHOW KEYS creating problem in performance INNODB
|
570 |
kuntal basu
|
09/14/2012 07:43AM
|
|
Re: SHOW KEYS creating problem in performance INNODB
|
282 |
Aftab Khan
|
09/14/2012 07:49AM
|
|
Re: SHOW KEYS creating problem in performance INNODB
|
291 |
kuntal basu
|
09/14/2012 08:58AM
|
|
Re: SHOW KEYS creating problem in performance INNODB
|
304 |
Rick James
|
09/14/2012 08:01PM
|
|
Re: SHOW KEYS creating problem in performance INNODB
|
299 |
kuntal basu
|
09/14/2012 10:07PM
|
|
Re: SHOW KEYS creating problem in performance INNODB
|
232 |
Aftab Khan
|
09/17/2012 09:03AM
|
|
Possible to do if .. then atomically without exceptions?
|
474 |
Archie Cobbs
|
09/13/2012 08:08PM
|
|
Re: Possible to do if .. then atomically without exceptions?
|
287 |
Aftab Khan
|
09/14/2012 02:00AM
|
|
Re: Possible to do if .. then atomically without exceptions?
|
232 |
Archie Cobbs
|
09/14/2012 09:48AM
|
|
Size of the databse
|
416 |
Thomas Laguerre
|
09/13/2012 08:59AM
|
|
Re: Size of the databse
|
246 |
Aftab Khan
|
09/14/2012 01:50AM
|
|
Innodb Plugin 1.0.17 + MySQL 5.1.62
|
434 |
Adrian Chapela Cordeiro
|
09/12/2012 01:47AM
|
|
Re: Innodb Plugin 1.0.17 + MySQL 5.1.62
|
255 |
Rick James
|
09/13/2012 09:09AM
|
|
MYSQL Crash
|
584 |
Lee Harper
|
09/11/2012 01:50PM
|
|
Re: MYSQL Crash
|
295 |
Rick James
|
09/12/2012 08:20PM
|
|
Orphaned table space after optimize lock up
|
600 |
William Taylor
|
09/05/2012 10:30AM
|
|
Re: Orphaned table space after optimize lock up
|
299 |
Rick James
|
09/06/2012 07:42PM
|
|
Re: Orphaned table space after optimize lock up
|
284 |
William Taylor
|
09/06/2012 11:45PM
|
|
kill -9 is a no-no
|
289 |
Rick James
|
09/07/2012 10:16PM
|
|
Innodb Table Recovery
|
627 |
Dvaid zzzzz
|
09/05/2012 01:37PM
|
|
Re: Innodb Table Recovery
|
263 |
Aftab Khan
|
09/06/2012 02:12AM
|
|
Re: Innodb Table Recovery
|
271 |
Dvaid zzzzz
|
09/06/2012 09:35AM
|
|
Re: Innodb Table Recovery
|
313 |
Rick James
|
09/06/2012 10:31PM
|
|
Re: Innodb Table Recovery
|
277 |
Andrii Nikitin
|
09/06/2012 01:06AM
|
|
Re: Innodb Table Recovery
|
268 |
Dvaid zzzzz
|
09/06/2012 09:34AM
|
|
How to convert MyIsam in Inodb?
|
489 |
jessy roswell
|
09/04/2012 11:26PM
|
|
Re: How to convert MyIsam in Inodb?
|
262 |
Dvaid zzzzz
|
09/05/2012 02:38PM
|
|
Re: How to convert MyIsam in Inodb?
|
273 |
Rick James
|
09/06/2012 07:48PM
|
|
Re: How to convert MyIsam in Inodb?
|
290 |
Aftab Khan
|
09/05/2012 04:00AM
|
|
Problem with innodb_large_prefix
|
1,181 |
Carsten Book
|
09/06/2012 01:43AM
|
|
Re: Problem with innodb_large_prefix
|
876 |
Aftab Khan
|
09/06/2012 01:56AM
|
|
Re: Problem with innodb_large_prefix
|
593 |
Carsten Book
|
09/06/2012 04:04AM
|
|
Restore InnoDB schema from partial backup
|
629 |
alena ss
|
08/27/2012 05:45AM
|
|
Re: Restore InnoDB schema from partial backup
|
313 |
Aftab Khan
|
08/27/2012 08:52AM
|
|
Re: Restore InnoDB schema from partial backup
|
310 |
alena ss
|
08/29/2012 07:18AM
|
|
Deadlock Detection in InnoDB storage engine
|
1,202 |
Manjunath C
|
07/24/2012 06:03AM
|
|
Re: Deadlock Detection in InnoDB storage engine
|
554 |
Aftab Khan
|
07/24/2012 09:49AM
|
|
Re: Deadlock Detection in InnoDB storage engine
|
571 |
Aftab Khan
|
07/24/2012 10:10AM
|
|
Re: Deadlock Detection in InnoDB storage engine
|
510 |
Manjunath C
|
07/24/2012 10:24PM
|
|
Re: Deadlock Detection in InnoDB storage engine
|
531 |
Aftab Khan
|
07/25/2012 02:38AM
|
|
Re: Deadlock Detection in InnoDB storage engine
|
463 |
Manjunath C
|
07/25/2012 04:59AM
|
|
Re: Deadlock Detection in InnoDB storage engine
|
465 |
Aftab Khan
|
07/25/2012 05:04AM
|
|
Re: Deadlock Detection in InnoDB storage engine
|
453 |
Manjunath C
|
07/25/2012 05:19AM
|
|
Re: Deadlock Detection in InnoDB storage engine
|
428 |
Manjunath C
|
07/25/2012 11:39PM
|
|
Re: Deadlock Detection in InnoDB storage engine
|
483 |
Aftab Khan
|
07/26/2012 02:32AM
|
|
Re: Deadlock Detection in InnoDB storage engine
|
468 |
Manjunath C
|
07/26/2012 06:33AM
|
|
Re: Deadlock Detection in InnoDB storage engine
|
397 |
Rick James
|
07/27/2012 10:30PM
|
|
Re: Deadlock Detection in InnoDB storage engine
|
436 |
Manjunath C
|
07/31/2012 12:00AM
|
|
Re: Deadlock Detection in InnoDB storage engine
|
410 |
Aftab Khan
|
07/31/2012 05:10AM
|
|
Re: Deadlock Detection in InnoDB storage engine
|
373 |
Manjunath C
|
08/01/2012 12:03AM
|
|
Re: Deadlock Detection in InnoDB storage engine
|
443 |
Aftab Khan
|
08/01/2012 06:05AM
|
|
Re: Deadlock Detection in InnoDB storage engine
|
395 |
Manjunath C
|
08/02/2012 03:20AM
|
|
Re: Deadlock Detection in InnoDB storage engine
|
311 |
Manjunath C
|
08/28/2012 06:28AM
|
|
Re: Deadlock Detection in InnoDB storage engine
|
469 |
Aftab Khan
|
07/31/2012 02:32AM
|
|
URGENT - Dump file won't restore. Syntax Errors????
|
628 |
Glenn Schworak
|
08/22/2012 05:32PM
|
|
Re: URGENT - Dump file won't restore. Syntax Errors????
|
431 |
Glenn Schworak
|
08/22/2012 06:22PM
|
|
Re: URGENT - Dump file won't restore. Syntax Errors????
|
333 |
Rick James
|
08/23/2012 08:07PM
|
|
Can't start MySQL on Windows 2003 after deleting ibdata1
|
605 |
Angelo Chu
|
08/23/2012 01:02AM
|
|
Re: Can't start MySQL on Windows 2003 after deleting ibdata1
|
401 |
Aftab Khan
|
08/23/2012 01:19AM
|
|
Re: Can't start MySQL on Windows 2003 after deleting ibdata1
|
438 |
Angelo Chu
|
08/23/2012 01:27AM
|
|
Re: Can't start MySQL on Windows 2003 after deleting ibdata1
|
325 |
Angelo Chu
|
08/23/2012 06:49AM
|
|
Mystery innodb crash
|
632 |
Justin Bennett
|
08/21/2012 10:44PM
|
|
Re: Mystery innodb crash
|
320 |
Aftab Khan
|
08/22/2012 02:12AM
|
|
Wrong ID of InnoDB table shown by InnoDB-monitor
|
385 |
Michael Abramovich
|
08/21/2012 09:22AM
|
|
Innodb stats for compressed tables
|
528 |
Aurelien PANIZZA
|
08/13/2012 03:34AM
|
|
Re: Innodb stats for compressed tables
|
271 |
Rick James
|
08/19/2012 04:39PM
|
|
Re: Innodb stats for compressed tables
|
266 |
Aurelien PANIZZA
|
08/20/2012 02:35AM
|
|
Re: Innodb stats for compressed tables
|
312 |
Aurelien PANIZZA
|
08/20/2012 03:47AM
|
|
Re: Innodb stats for compressed tables
|
259 |
Rick James
|
08/21/2012 09:09AM
|
|
Autocommit and transaction issues
|
489 |
Ping Pong
|
08/13/2012 03:14AM
|
|
Re: Autocommit and transaction issues
|
284 |
Aftab Khan
|
08/16/2012 02:14AM
|
|
Recovered DB: InnoDB tables dn't exist
|
493 |
Dan Rio
|
08/15/2012 02:13PM
|
|
Re: Recovered DB: InnoDB tables dn't exist
|
371 |
Aftab Khan
|
08/15/2012 02:47PM
|
|
Locking problem
|
561 |
ivan ivic
|
08/13/2012 07:32PM
|
|
Re: Locking problem
|
300 |
Aftab Khan
|
08/14/2012 02:15AM
|
|
Re: Locking problem
|
321 |
ivan ivic
|
08/14/2012 10:24AM
|
|
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END' at line 18
|
1,460 |
babu patil
|
08/11/2012 09:58AM
|
|
Re: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END' at line 18
|
335 |
Aftab Khan
|
08/12/2012 12:43AM
|
|
SQL - searching TEXT field type
|
531 |
Adam Lang
|
08/08/2012 10:50AM
|
|
Re: SQL - searching TEXT field type
|
354 |
Aftab Khan
|
08/09/2012 04:52AM
|
|
Re: SQL - searching TEXT field type
|
331 |
Adam Lang
|
08/09/2012 08:47AM
|
|
ibdata2 file size
|
730 |
Ankur Avlani
|
08/07/2012 12:19PM
|
|
Re: ibdata2 file size
|
392 |
Aftab Khan
|
08/08/2012 03:12AM
|
|
Re: ibdata2 file size
|
393 |
Rick James
|
08/08/2012 08:06AM
|
|
Got errror -1 from storage engine
|
525 |
Adam CzechBoY
|
08/06/2012 06:19AM
|
|
Re: Got errror -1 from storage engine
|
375 |
Rick James
|
08/07/2012 08:50PM
|
|
Re: Got errror -1 from storage engine
|
351 |
Andrii Nikitin
|
08/07/2012 09:18AM
|
|
Very slow massive inserts into simple table (innodb)
|
1,299 |
Michał Kowal
|
08/04/2012 02:11AM
|
|
Re: Very slow massive inserts into simple table (innodb)
|
671 |
Rick James
|
08/05/2012 09:14AM
|
|
Re: Very slow massive inserts into simple table (innodb)
|
585 |
Michał Kowal
|
08/05/2012 02:16PM
|
|
Re: Very slow massive inserts into simple table (innodb)
|
666 |
Michał Kowal
|
08/05/2012 02:07PM
|
|
Re: Very slow massive inserts into simple table (innodb)
|
621 |
Aftab Khan
|
08/04/2012 04:46AM
|
|
Re: Very slow massive inserts into simple table (innodb)
|
612 |
Michał Kowal
|
08/04/2012 05:06AM
|
|
Re: Very slow massive inserts into simple table (innodb)
|
567 |
Michał Kowal
|
08/04/2012 05:11AM
|
|
Re: Very slow massive inserts into simple table (innodb)
|
575 |
Andrii Nikitin
|
08/07/2012 09:20AM
|
|
InnoDB, Data Dictionary help
|
968 |
Jason Anderson
|
08/03/2012 09:13PM
|
|
Re: InnoDB, Data Dictionary help
|
480 |
Rick James
|
08/05/2012 08:51AM
|
|
Re: InnoDB, Data Dictionary help
|
563 |
Aftab Khan
|
08/04/2012 04:48AM
|
|
How to kill sleeping processes
|
2,395 |
jose joseph
|
08/01/2012 04:55PM
|
|
Re: How to kill sleeping processes
|
889 |
Rick James
|
08/03/2012 12:51AM
|
|
Re: How to kill sleeping processes
|
996 |
jose joseph
|
08/03/2012 02:22AM
|
|
Re: How to kill sleeping processes
|
951 |
Aftab Khan
|
08/03/2012 02:27AM
|
|
Re: How to kill sleeping processes
|
773 |
jose joseph
|
08/03/2012 07:27AM
|
|
Re: How to kill sleeping processes
|
1,144 |
Aftab Khan
|
08/02/2012 03:20AM
|
|
ignoring binlogs for a particular table
|
561 |
satya dixit
|
07/27/2012 02:33AM
|
|
Re: ignoring binlogs for a particular table
|
322 |
Rick James
|
07/28/2012 12:56PM
|
|
Re: ignoring binlogs for a particular table
|
324 |
Aftab Khan
|
07/29/2012 03:51AM
|
|
Re: ignoring binlogs for a particular table
|
329 |
Aftab Khan
|
07/27/2012 03:35AM
|
|
Re: ignoring binlogs for a particular table
|
280 |
satya dixit
|
07/27/2012 07:37AM
|
|
Re: ignoring binlogs for a particular table
|
319 |
Aftab Khan
|
07/27/2012 08:32AM
|
|
This topic has been moved.:
Innodb Table Recovery
|
0 |
Dvaid zzzzz
|
09/05/2012 02:06PM
|
|
This topic has been moved.:
ibdata2 file size
|
0 |
Ankur Avlani
|
08/07/2012 12:36PM
|
|
This topic has been moved.:
Deadlock Detection in InnoDB storage engine
|
0 |
Manjunath C
|
07/24/2012 08:42AM
|