castortray Wrote:I've got about 600 movies and when I go to Movies --> Actors it took around 13 minutes (4882 actors) 
after adding skip-name-resolve in my.ini
Code:
[mysqld]
.....
......
skip-name-resolve
and the creation of the index:
Code:
mysql> ALTER TABLE movie ADD INDEX ix_idFile(idFile);
Query OK, 681 rows affected (1.01 sec)
Records: 681 Duplicates: 0 Warnings: 0
my time change from 13 min to 6 min for 4899 actors, it's better but should be much faster I think
Can you write your index table command for mysql ?
Do you use SSD ?
Everybody has the same issue ?
What are your times ?
I had the same issue but was able to fix it.
You should use an IP in your advancedsettings, not the DNS Name.
Here's my my.ini
Code:
[client]
host = .
port = 3306
socket = "MySQL"
[mysqld]
basedir = "C:/xampplite/mysql/"
datadir = "C:/xampplite/mysql/data/"
port = 3306
socket = "MySQL"
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
default-time-zone = "Europe/Berlin"
log_error = "C:/xampplite/mysql/data/mysql.err"
pid_file = "mysql.pid"
general_log = 0
general_log_file = "C:/xampplite/mysql/data/mysql.log"
slow_query_log = 0
slow_query_log_file = "C:/xampplite/mysql/data/mysql-slow.log"
enable-named-pipe
skip-federated
server-id = 1
tmpdir = "C:/xampplite/tmp/"
innodb_data_home_dir = "C:/xampplite/mysql/data/"
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = "C:/xampplite/mysql/data/"
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
And the SQL query (music db):
Code:
CREATE INDEX idAlbum_idx ON song(idAlbum);
CREATE INDEX idArtist_idx ON song(idArtist);
CREATE INDEX idArtist_idx ON album(idArtist);
CREATE INDEX idArtist_idx ON exartistsong(idArtist);
CREATE INDEX idArtist_idx ON exartistalbum(idArtist);
Exactly 4 seconds to list 4793 artists (music db)
2 seconds to list 203 genres (music db)
Less than 1 second to list 43 genres (movie db)
8 seconds to list 19239 actors (movie db)
Hope this helps
Intel Core i5 (not sure which one)
4 GB DDR3 RAM
320 GB WD Caviar Green Edition
GB-LAN
MySQL runs on a Windows 2008 R2 Server
