|
change structure
|
934 |
dscsvsv vdvvdfsvv
|
10/28/2011 12:18PM
|
|
Re: change structure
|
310 |
Rick James
|
10/29/2011 01:31PM
|
|
InnoDB Update that takes a long time
|
864 |
Shawn Taylor
|
10/26/2011 10:26AM
|
|
Re: InnoDB Update that takes a long time
|
483 |
Shawn Taylor
|
10/27/2011 10:51AM
|
|
Re: InnoDB Update that takes a long time
|
511 |
Rick James
|
10/27/2011 06:57AM
|
|
how to modify innodb_use_native_aio variable
|
799 |
Nithya Natarajan
|
10/27/2011 05:30AM
|
|
How to restore innoDB tables without ibdata1 with innodb_file_per_table=1
|
4,493 |
Olag Ulga
|
09/13/2011 01:04AM
|
|
Re: How to restore innoDB tables without ibdata1 with innodb_file_per_table=1
|
1,661 |
Aleksandr Kuzminsky
|
10/23/2011 06:54AM
|
|
Re: How to restore innoDB tables without ibdata1 with innodb_file_per_table=1
|
1,995 |
Rick James
|
09/13/2011 10:01PM
|
|
Re: How to restore innoDB tables without ibdata1 with innodb_file_per_table=1
|
1,607 |
Olag Ulga
|
09/14/2011 12:07AM
|
|
Scheduling SHOW ENGINE INNODB STATUS
|
1,097 |
MySQL New DBA
|
10/21/2011 04:30PM
|
|
Re: Scheduling SHOW ENGINE INNODB STATUS
|
489 |
Rick James
|
10/22/2011 09:03PM
|
|
Insert on duplicate key update only if columns aren't changed
|
1,549 |
Nick Rupley
|
10/19/2011 12:47PM
|
|
Re: Insert on duplicate key update only if columns aren't changed
|
815 |
Nick Rupley
|
10/19/2011 03:03PM
|
|
Re: Insert on duplicate key update only if columns aren't changed
|
905 |
Nick Rupley
|
10/19/2011 01:09PM
|
|
Re: Insert on duplicate key update only if columns aren't changed
|
890 |
Rick James
|
10/20/2011 09:40PM
|
|
MySQL 5.5 Bin logs & InnoDB logs
|
1,088 |
Shiva V
|
10/20/2011 02:01PM
|
|
Re: MySQL 5.5 Bin logs & InnoDB logs
|
467 |
KimSeong Loh
|
10/20/2011 07:18PM
|
|
Is free space the only real indicator for optimizing tables?
|
1,435 |
David Hicks
|
10/06/2011 08:37AM
|
|
Re: Is free space the only real indicator for optimizing tables?
|
737 |
David Hicks
|
10/06/2011 10:00AM
|
|
Re: Is free space the only real indicator for optimizing tables?
|
704 |
Rick James
|
10/15/2011 01:30PM
|
|
Re: Is free space the only real indicator for optimizing tables?
|
434 |
David Hicks
|
10/15/2011 01:34PM
|
|
Innodb configuration optimal for my workload?
|
2,071 |
Fernando Perez
|
10/03/2011 09:14AM
|
|
Re: Innodb configuration optimal for my workload?
|
469 |
James Day
|
10/14/2011 12:45PM
|
|
Re: Innodb configuration optimal for my workload?
|
1,042 |
Fernando Perez
|
10/14/2011 12:39PM
|
|
Re: Innodb configuration optimal for my workload?
|
663 |
Rick James
|
10/15/2011 11:42AM
|
|
Re: Innodb configuration optimal for my workload?
|
596 |
Fernando Perez
|
10/14/2011 12:38PM
|
|
Re: Innodb configuration optimal for my workload?
|
579 |
Rick James
|
10/04/2011 08:19AM
|
|
Re: Innodb configuration optimal for my workload?
|
436 |
Fernando Perez
|
10/04/2011 08:22AM
|
|
Re: Innodb configuration optimal for my workload?
|
542 |
Greg Kemnitz
|
10/04/2011 12:10PM
|
|
Re: Innodb configuration optimal for my workload?
|
534 |
Rick James
|
10/07/2011 04:38AM
|
|
Re: Innodb configuration optimal for my workload?
|
531 |
Fernando Perez
|
10/11/2011 08:11AM
|
|
Strange deadlock problem - deadlock in same trnsaction
|
846 |
Peter Chang
|
10/13/2011 11:06AM
|
|
Re: Strange deadlock problem - deadlock in same trnsaction
|
356 |
Rick James
|
10/14/2011 05:32AM
|
|
Re: Strange deadlock problem - deadlock in same trnsaction
|
389 |
Peter Chang
|
10/14/2011 09:44AM
|
|
Re: Strange deadlock problem - deadlock in same trnsaction
|
450 |
Rick James
|
10/15/2011 11:29AM
|
|
Re: Strange deadlock problem - deadlock in same trnsaction
|
410 |
James Day
|
10/14/2011 12:35PM
|
|
Re: Strange deadlock problem - deadlock in same trnsaction
|
463 |
Peter Chang
|
10/14/2011 01:17PM
|
|
SHOW TABLE STATUS for InnoDB table
|
1,412 |
KimSeong Loh
|
10/12/2011 05:13PM
|
|
Re: SHOW TABLE STATUS for InnoDB table
|
498 |
Rick James
|
10/13/2011 06:20PM
|
|
how to limit DBsize
|
1,365 |
Ashok Naidu
|
10/06/2011 10:11PM
|
|
Re: how to limit DBsize
|
421 |
Rick James
|
10/09/2011 05:57AM
|
|
Re: how to limit DBsize
|
490 |
Ashok Naidu
|
10/10/2011 12:42AM
|
|
Re: how to limit DBsize
|
439 |
Ashok Naidu
|
10/10/2011 12:43AM
|
|
Re: how to limit DBsize
|
427 |
Rick James
|
10/11/2011 07:39PM
|
|
MySql Using 100% CPU
|
2,217 |
Balls Deep
|
10/09/2011 02:31PM
|
|
Re: MySql Using 100% CPU
|
800 |
Rick James
|
10/10/2011 09:32AM
|
|
InnoDB and autocommit=0
|
1,193 |
Markus Kirchknopf
|
10/06/2011 10:05PM
|
|
Re: InnoDB and autocommit=0
|
615 |
Rick James
|
10/09/2011 06:01AM
|
|
problem with "waiting in InnoDB queue"
|
1,646 |
Danny Wang
|
09/30/2011 03:01PM
|
|
Re: problem with "waiting in InnoDB queue"
|
701 |
Rick James
|
10/01/2011 08:56AM
|
|
Re: problem with "waiting in InnoDB queue"
|
946 |
Danny Wang
|
10/05/2011 08:58AM
|
|
Re: problem with "waiting in InnoDB queue"
|
690 |
Danny Wang
|
10/06/2011 09:36AM
|
|
Re: problem with "waiting in InnoDB queue"
|
616 |
Rick James
|
10/07/2011 05:54AM
|
|
Re: problem with "waiting in InnoDB queue"
|
979 |
Danny Wang
|
10/07/2011 07:53AM
|
|
InnoDB: Page directory corruption: supremum not pointed to
|
1,212 |
sanjeev sagar
|
10/04/2011 05:39PM
|
|
table issue
|
1,261 |
dscsvsv vdvvdfsvv
|
09/23/2011 12:39PM
|
|
Re: table issue
|
386 |
Greg Kemnitz
|
10/04/2011 11:57AM
|
|
Re: table issue
|
414 |
Adam Donnison
|
09/28/2011 10:02PM
|
|
Re: table issue
|
431 |
dscsvsv vdvvdfsvv
|
09/29/2011 10:27AM
|
|
Re: table issue
|
415 |
Adam Donnison
|
09/29/2011 04:08PM
|
|
Identical servers/databases/indexes, different query plans.
|
863 |
Clive le Roux
|
09/28/2011 02:41PM
|
|
Re: Identical servers/databases/indexes, different query plans.
|
898 |
Rick James
|
09/29/2011 06:13PM
|
|
degredation in performance
|
861 |
Jose Manuel Parada
|
09/21/2011 01:00PM
|
|
Re: degredation in performance
|
376 |
Adam Donnison
|
09/28/2011 10:06PM
|
|
fulltext on 5.6.2m5
|
954 |
Alex W
|
09/28/2011 10:10AM
|
|
Re: fulltext on 5.6.2m5
|
443 |
Adam Donnison
|
09/28/2011 09:57PM
|
|
Un-Authenticated User
|
1,641 |
Asad Raza
|
09/22/2011 12:39PM
|
|
Re: Un-Authenticated User
|
373 |
Rick James
|
09/23/2011 09:30AM
|
|
Re: Un-Authenticated User
|
425 |
Asad Raza
|
09/24/2011 03:13AM
|
|
Re: Un-Authenticated User
|
426 |
Rick James
|
09/25/2011 12:31PM
|
|
Re: Un-Authenticated User
|
641 |
Asad Raza
|
09/28/2011 08:54PM
|
|
Insert deadlock HUGE DELAYS??
|
722 |
Vincent Senese
|
09/28/2011 12:01AM
|
|
Re: Insert deadlock HUGE DELAYS??
|
361 |
Vincent Senese
|
09/28/2011 08:52PM
|
|
hanging JOIN
|
1,614 |
Jurgen Sidgman
|
09/23/2011 06:50AM
|
|
Re: hanging JOIN
|
405 |
Rick James
|
09/24/2011 08:32AM
|
|
Re: hanging JOIN
|
400 |
Jurgen Sidgman
|
09/25/2011 05:28PM
|
|
Re: hanging JOIN
|
417 |
Rick James
|
09/26/2011 07:19PM
|
|
Re: hanging JOIN
|
411 |
Jurgen Sidgman
|
09/27/2011 09:10AM
|
|
MySQL CPU load growing up
|
1,389 |
Filip Zachar
|
09/20/2011 01:30PM
|
|
Re: MySQL CPU load growing up
|
436 |
Filip Zachar
|
09/27/2011 05:39AM
|
|
Re: MySQL CPU load growing up
|
490 |
Rick James
|
09/21/2011 11:28PM
|
|
Got an error reading communication packets
|
1,520 |
Asad Raza
|
09/22/2011 12:33PM
|
|
Re: Got an error reading communication packets
|
718 |
Rick James
|
09/23/2011 09:35AM
|
|
Innodb Configuration
|
1,193 |
Zois Papas
|
09/19/2011 03:32AM
|
|
Re: Innodb Configuration
|
379 |
Rick James
|
09/20/2011 08:59PM
|
|
Deadlock on index of a Innodb table
|
1,903 |
Muthukumaran P
|
09/08/2011 12:35AM
|
|
Re: Deadlock on index of a Innodb table
|
678 |
Rick James
|
09/08/2011 08:16PM
|
|
Re: Deadlock on index of a Innodb table
|
682 |
Muthukumaran P
|
09/08/2011 11:35PM
|
|
Re: Deadlock on index of a Innodb table
|
691 |
Rick James
|
09/10/2011 03:36PM
|
|
Re: Deadlock on index of a Innodb table
|
573 |
Muthukumaran P
|
09/12/2011 01:13AM
|
|
Re: Deadlock on index of a Innodb table
|
567 |
Antonio Hernandez
|
09/20/2011 11:11AM
|
|
This topic has been moved.:
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 '10' at line 1
|
15 |
siu chan
|
09/20/2011 06:06PM
|
|
InnoDB-total number of locks exceeds lock table size
|
1,387 |
Robert Mariotti
|
09/13/2011 08:09AM
|
|
Re: InnoDB-total number of locks exceeds lock table size
|
498 |
Rick James
|
09/14/2011 08:26PM
|
|
Help errno: 121, Can't create table
|
6,060 |
James Davidson
|
09/09/2011 03:23PM
|
|
Re: Help errno: 121, Can't create table
|
2,947 |
Rick James
|
09/10/2011 03:12PM
|
|
Innodb v/s Myisam
|
1,326 |
Sachin Murudkar
|
07/20/2011 01:28AM
|
|
Re: Innodb v/s Myisam
|
521 |
Greg Kemnitz
|
09/08/2011 01:01PM
|
|
Re: Innodb v/s Myisam
|
470 |
Rick James
|
09/10/2011 11:03AM
|
|
Re: Innodb v/s Myisam
|
541 |
Irfan Ali
|
07/20/2011 02:11PM
|
|
Is it a good practice to mix InnoDB and MyISAM engine in a database?
|
1,453 |
Adrian Hoe
|
08/17/2011 01:06AM
|
|
Re: Is it a good practice to mix InnoDB and MyISAM engine in a database?
|
537 |
Greg Kemnitz
|
09/08/2011 01:32PM
|
|
Re: Is it a good practice to mix InnoDB and MyISAM engine in a database?
|
845 |
Rick James
|
08/17/2011 09:32PM
|
|
Re: Is it a good practice to mix InnoDB and MyISAM engine in a database?
|
559 |
Adrian Hoe
|
08/19/2011 12:21AM
|
|
Re: Is it a good practice to mix InnoDB and MyISAM engine in a database?
|
927 |
Rick James
|
08/19/2011 09:05PM
|
|
replication master-slave issue
|
1,603 |
emil öhgren
|
09/06/2011 05:39AM
|
|
Re: replication master-slave issue
|
435 |
Rick James
|
09/07/2011 07:57PM
|
|
Re: replication master-slave issue
|
465 |
emil öhgren
|
09/08/2011 03:04AM
|
|
Lock wait on INSERT using READ_COMMITTED
|
1,978 |
Greg Burcher
|
09/02/2011 02:27PM
|
|
Re: Lock wait on INSERT using READ_COMMITTED
|
513 |
Rick James
|
09/03/2011 07:52PM
|
|
Re: Lock wait on INSERT using READ_COMMITTED
|
610 |
Greg Burcher
|
09/06/2011 06:04AM
|
|
Re: Lock wait on INSERT using READ_COMMITTED
|
493 |
Rick James
|
09/07/2011 09:25AM
|
|
Some InnoDB error in Mysql log, Pls. help!
|
1,256 |
Yanping Wu
|
09/05/2011 01:12AM
|
|
Re: Some InnoDB error in Mysql log, Pls. help!
|
494 |
Rick James
|
09/06/2011 09:16AM
|
|
Re: Some InnoDB error in Mysql log, Pls. help!
|
505 |
Yanping Wu
|
09/06/2011 07:01PM
|
|
INNODB lock. How to resolve?
|
1,854 |
Giacomino Raccuia
|
08/22/2011 07:57AM
|
|
Re: INNODB lock. How to resolve?
|
710 |
Rick James
|
08/23/2011 08:22AM
|
|
Re: INNODB lock. How to resolve?
|
638 |
Giacomino Raccuia
|
08/23/2011 08:43AM
|
|
Re: INNODB lock. How to resolve?
|
674 |
Rick James
|
08/24/2011 09:37PM
|
|
Re: INNODB lock. How to resolve?
|
613 |
Giacomino Raccuia
|
09/04/2011 08:03AM
|
|
Re: INNODB lock. How to resolve?
|
554 |
Rick James
|
09/05/2011 02:46PM
|
|
syntax error
|
3,468 |
gareth grace
|
09/03/2011 02:12PM
|
|
Re: syntax error
|
428 |
Rick James
|
09/04/2011 09:33AM
|
|
Info on "ERROR 27 (HY000) Can't sync XXX.frm, Errcode:9
|
1,181 |
Robert McCormick
|
09/02/2011 10:49AM
|
|
Re: Info on "ERROR 27 (HY000) Can't sync XXX.frm, Errcode:9
|
466 |
Rick James
|
09/03/2011 08:18AM
|
|
Two question with InnoDB XA transaction
|
1,292 |
Jiang David
|
09/03/2011 03:23AM
|
|
Error 139 problem
|
1,395 |
BC Holmes
|
09/01/2011 06:27PM
|
|
Re: Error 139 problem
|
721 |
BC Holmes
|
09/02/2011 12:22PM
|
|
Re: Error 139 problem
|
700 |
Rick James
|
09/02/2011 11:51PM
|
|
UPDATE statement locks non-existent row
|
2,144 |
Burger King
|
08/23/2011 06:51PM
|
|
Re: UPDATE statement locks non-existent row
|
472 |
Peter Brawley
|
08/30/2011 07:53PM
|
|
Re: UPDATE statement locks non-existent row
|
521 |
Peter Brawley
|
08/30/2011 08:11PM
|
|
Re: UPDATE statement locks non-existent row
|
480 |
Burger King
|
08/31/2011 07:30PM
|
|
Re: UPDATE statement locks non-existent row
|
800 |
Rick James
|
09/01/2011 05:58PM
|
|
Re: UPDATE statement locks non-existent row
|
714 |
Burger King
|
09/01/2011 07:14PM
|
|
Re: UPDATE statement locks non-existent row
|
519 |
Rick James
|
09/02/2011 11:48PM
|
|
Re: UPDATE statement locks non-existent row
|
446 |
Burger King
|
08/30/2011 05:54PM
|
|
Error Number 5 when loading from mysqldump
|
1,854 |
Robert McCormick
|
08/23/2011 12:25PM
|
|
Re: Error Number 5 when loading from mysqldump
|
423 |
Shawn Taylor
|
08/30/2011 11:44AM
|
|
Re: Error Number 5 when loading from mysqldump
|
861 |
Rick James
|
08/31/2011 07:55AM
|
|
Re: Error Number 5 when loading from mysqldump
|
571 |
Shawn Taylor
|
08/29/2011 07:39AM
|
|
Re: Error Number 5 when loading from mysqldump
|
503 |
Robert McCormick
|
08/29/2011 10:22AM
|
|
Re: Error Number 5 when loading from mysqldump
|
662 |
Rick James
|
08/24/2011 09:55AM
|
|
Re: Error Number 5 when loading from mysqldump
|
512 |
Robert McCormick
|
08/24/2011 03:55PM
|
|
Re: Error Number 5 when loading from mysqldump
|
434 |
Rick James
|
08/25/2011 04:38PM
|
|
Re: Error Number 5 when loading from mysqldump
|
448 |
Robert McCormick
|
08/25/2011 05:29PM
|
|
Re: Error Number 5 when loading from mysqldump
|
411 |
Rick James
|
08/26/2011 01:04PM
|
|
Re: Error Number 5 when loading from mysqldump
|
443 |
Robert McCormick
|
08/29/2011 10:26AM
|
|
Re: Error Number 5 when loading from mysqldump
|
471 |
Rick James
|
08/30/2011 08:32AM
|
|
Re: Error Number 5 when loading from mysqldump
|
448 |
Robert McCormick
|
08/30/2011 09:45AM
|
|
When I need to use AnaLYZE??
|
815 |
|
08/25/2011 02:32PM
|
|
Re: When I need to use AnaLYZE??
|
443 |
Rick James
|
08/26/2011 12:09PM
|
|
Re: When I need to use AnaLYZE??
|
420 |
|
08/30/2011 07:25AM
|
|
Re: When I need to use AnaLYZE??
|
396 |
Rick James
|
08/31/2011 07:34AM
|
|
error dropping database
|
2,486 |
Angel Tirone
|
08/11/2011 01:52PM
|
|
Re: error dropping database
|
869 |
Shawn Taylor
|
08/29/2011 07:29AM
|
|
Database corruption
|
1,179 |
Francisco Vega
|
08/02/2011 01:29PM
|
|
Re: Database corruption
|
496 |
Peter Brawley
|
08/02/2011 01:51PM
|
|
Re: Database corruption
|
527 |
Francisco Vega
|
08/02/2011 02:15PM
|
|
Re: Database corruption
|
1,111 |
Francisco Vega
|
08/02/2011 02:00PM
|
|
Re: Database corruption
|
762 |
Peter Brawley
|
08/02/2011 02:48PM
|
|
Re: Database corruption
|
1,059 |
Francisco Vega
|
08/02/2011 04:19PM
|
|
Re: Database corruption
|
646 |
Peter Brawley
|
08/02/2011 05:23PM
|
|
Re: Database corruption
|
634 |
Francisco Vega
|
08/02/2011 06:04PM
|
|
Re: Database corruption
|
611 |
Peter Brawley
|
08/02/2011 06:17PM
|
|
Re: Database corruption
|
973 |
Francisco Vega
|
08/02/2011 08:04PM
|
|
Re: Database corruption
|
594 |
Rahul Rajpal
|
08/28/2011 05:25AM
|
|
Re: Database corruption
|
619 |
Peter Brawley
|
08/02/2011 08:43PM
|
|
Re: Database corruption
|
627 |
Francisco Vega
|
08/03/2011 06:34AM
|
|
PK in decending order
|
1,096 |
Tobias Lind
|
08/26/2011 06:25AM
|
|
Re: PK in decending order
|
434 |
Rick James
|
08/27/2011 09:07AM
|
|
Foreign key constraint.
|
915 |
Chaitanya Jakhadi
|
08/23/2011 10:43AM
|
|
Re: Foreign key constraint.
|
349 |
Rick James
|
08/25/2011 05:18PM
|
|
This topic has been moved.:
UPDATE statement locks non-existent row
|
665 |
Burger King
|
08/23/2011 07:36PM
|
|
All Innodb tables using seperate ibd, but ibdata1 still being modified?
|
1,746 |
Kyle Bresin
|
08/12/2011 01:33PM
|
|
Re: All Innodb tables using seperate ibd, but ibdata1 still being modified?
|
942 |
Rick James
|
08/13/2011 02:50PM
|
|
Re: All Innodb tables using seperate ibd, but ibdata1 still being modified?
|
595 |
Kyle Bresin
|
08/18/2011 07:53AM
|
|
Re: All Innodb tables using seperate ibd, but ibdata1 still being modified?
|
969 |
Rick James
|
08/19/2011 07:57AM
|
|
Interpreting Mysql Innodb Tuning Info
|
762 |
David Usherwood
|
08/16/2011 02:56AM
|
|
Re: Interpreting Mysql Innodb Tuning Info
|
395 |
Rick James
|
08/16/2011 11:03PM
|
|
This topic has been moved.:
change structure
|
0 |
dscsvsv vdvvdfsvv
|
10/28/2011 10:35AM
|
|
This topic has been moved.:
UPDATE statement locks non-existent row
|
0 |
Burger King
|
08/30/2011 07:53PM
|
|
This topic has been moved.:
Database corruption
|
0 |
Francisco Vega
|
08/02/2011 08:43PM
|