[SOLVED] Netjukebox and mysqli errors

[charliego]

Netjukebox is a very fast web based media jukebox for playing music over the internet. With around 40.000 tracks music there are 2 query's with errors. One i solved by changing the sort_buffer_size = 256K in sort_buffer_size = 8M. The other one (same error code as the first one) is still giving troubles.

Code: Select all

$query = mysqli_query($db, 'SELECT track.artist, title, featuring, track_id FROM track, album WHERE (genre_id = "" OR genre_id NOT IN (' . $blacklist . ')) AND video_dataformat = "" AND track.album_id = album.album_id ORDER BY RAND() LIMIT 10');

Code: Select all

Incorrect key file for table '/tmp/#sql_990_0.MYI'; try to repair it

I'm still think it has something to do with memory settings. On my old nas (synology 107+ with only 128mb memory) it works without troubles.

Update
Solved by increasing the tmp dir size.

Code: Select all

mount tmpfs  /tmp -t tmpfs -o size=128m
/etc/init.d/Qthttpd.sh restart
/etc/init.d/mysqld.sh restart