Re mysqld-max-nt.exe vs mysqld.exe: I donno. It's what the installer
and the Server Instance Configuration Wizard chose. The instance
config choices that I made are:
Server Machine
Multifunctional Database
Decision Support/OLAP
TCP/IP Network enabled
Strict Mode enabled
Def Char set UTF8
Install as windows service
With those options and with the hardware I'm running, mysqld-max-nt.exe
gets chosen to be service provider. I'm sure that the only storage
engine being used is InnoDB.
Re you not seeing any slow queries: Do you have library statistics
disabled in the Slmsvr server performance settings? With the
statistics function turned off, all my lagging query problems go away
and the web interface is more than fast enough. But I've done just
enough sql query writing in the past so that I have suspicions about
the album, artist, track count queries as they are currently being
generated by the perl code. This is what gets passed to the database
back end to generate (I think) just the track count:
Code:
--------------------
SELECT COUNT( DISTINCT( track_2.id ) ) FROM genres me
LEFT JOIN genre_track genreTracks ON ( genreTracks.genre = me.id )
JOIN tracks track ON ( track.id = genreTracks.track )
LEFT JOIN contributor_track contributorTracks ON ( contributorTracks.track =
track.id )
JOIN contributors contributor ON ( contributor.id =
contributorTracks.contributor )
LEFT JOIN contributor_track contributorTracks_2 ON (
contributorTracks_2.contributor = contributor.id )
JOIN tracks track_2 ON ( track_2.id = contributorTracks_2.track )
WHERE ( ( ( ( ( contributorTracks.role IN ( '1', '5' ) )
AND ( me.id = '7' ) ) ) ) );
--------------------
Again, with my library, with some 25k tracks, the above query took
about 64 seconds to execute and examined over 21 million rows to
determine the count. I just loaded the same query into the MySQL Query
Browser. It took 61.1639 seconds to execute there. I have to believe
there is a simpler way to write that query that will be quicker to
execute.
--
gharris999
------------------------------------------------------------------------
gharris999's Profile: http://forums.slimdevices.com/member.php?userid=115
View this thread: http://forums.slimdevices.com/showthread.php?t=27334
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/beta
