[an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive]
[an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive]![]() |
![]() |
![]() |
|||||||||||||||||||||||||
|
|||||||||||||||||||||||||||
![]() |
![]() |
![]() |
Well...vores live database ligger på ssd diske, men lige nu leger jeg med en kopi på min egen maskine: robert-desktop:/var/lib/mysql/gamelog $ ls -lh game_log_ng.* -rw-rw---- 1 mysql mysql 8,7K 2010-04-08 14:34 game_log_ng.frm -rw-rw---- 1 mysql mysql 771M 2010-04-08 14:35 game_log_ng.MYD -rw-rw---- 1 mysql mysql 817M 2010-04-08 14:43 game_log_ng.MYI Det er fair nok at det tager 33 sekunder at lave søgningen gennem indexet, hvis det er dét, der skal til, men hvorfor tager det 3 sekunder, hvis jeg IKKE bruger index ? Det giver ikke rigtig mening...synes jeg.
![]() |
![]() |
![]() |
||||||||||||
|
||||||||||||||
![]() | ||||||||||||||
|
||||||||||||||
![]() |
![]() |
![]() |