[crimsonfury]

Does it matter that I have MySql installed on the same HTPC that is my main XBMC library with all of the HDDs located in it? It has 4 networked hdds in it that range from 1TB to 2TB each and I have 4gb Memory in it and a Q6600 QaudCore CPU.

I have a ATV2 connected and it seems just as fast as before putting MySql to work but the main library takes a while to load and it constantly freezes for 5 seconds and then its fine for 30 or so and then freezes again. Only started once I put MySql to work.


Is there anything I can do to help speed XBMC up again? I have at least 3 TV shows downloaded and added every night, but other than that nothing gets added on a daily basis...


Or would I be better off, off loading the HDDs into an older Pentium 4 PC that has 2gb of ram, to be my Home Server alone and having MySql running off of it?

[Ned Scott]

It will be slower, but I'm not sure if that kind of behavior, where it goes off and on slow, is from MySQL or not.

[crimsonfury]

It seems like when I enter menu's or libraries it freezes and then it will be fine but its random and not all the time...

[winestock]

It seems like when I enter menu's or libraries it freezes and then it will be fine but its random and not all the time...

What you might be experiencing is a resource sharing issue where MySql is using a lot RAM. I would suggest that you try running a MySQL tunning script. The script will evaluate your MySQL config and give you suggestions on how to fix issues that might exist.

For Windows: http://mysqltuner.codeplex.com/
For Linux:

Code:

wget mysqltuner.pl
wget tuning-primer.sh

Unfortunately, I can't find a tuning-primer.sh alternative that runs under MS Windows. You run these tools while MySql server is running.

Another possibility is to use mariadb instead of MySQL. mariadb is a drop in replacement for MySQL that runs quicker. I use mariadb with XBMC and it works great. A lot faster then using MySQL.

For Windows: http://www.iaji.net/step-by-step-guide-i...ows-7.html
For Linux: https://downloads.mariadb.org/

[crimsonfury]

MySQL Tuner 0.3 - Peter Chapman <[email protected]>
Currently running supported MySQL version 5.5.30
Operating on 64-bit architecture
Archive Engine Installed
Berkeley DB Engine Not Installed
Federated Engine Not Installed
InnoDB Engine Installed
ISAM Engine Not Installed
NDBCLUSTER Engine Not Installed
Data in InnoDB tables: 24M (Tables: 56)
Total fragmented tables: 56
All database users have passwords assigned
Up for: 2d 0h 7m 35s (3M q [22.000 qps], 119K conn, TX: 9G, RX: 412M)
Reads / Writes: 0% / 100%
Total buffers: 183.0M global + 960.0K per thread (100 max threads)
Maximum possible memory usage: 276.8M (6% of installed RAM)
Slow queries: 0% (0/3M)
Highest usage of available connections: 0% (7/100)
Key buffer size / total MyISAM indexes: 55.0M/97.0K
Key buffer hit rate: 100% (80M cached / 0 reads)
Query cache is disabled
Sorts requiring temporary tables: 0% (4K temp sorts / 561K sorts)
Temporary tables created on disk: 0% (33K on disk / 449K total)
Thread cache hit rate: 100% (7 created / 119K connections)
Open file limit used: 0% (0/2K)
Table locks acquired immediately: 100% (6M immediate / 6M locks)

I have no idea what to fix...

[crimsonfury]

It seems like when I enter menu's or libraries it freezes and then it will be fine but its random and not all the time...

What you might be experiencing is a resource sharing issue where MySql is using a lot RAM. I would suggest that you try running a MySQL tunning script. The script will evaluate your MySQL config and give you suggestions on how to fix issues that might exist.

For Windows: http://mysqltuner.codeplex.com/
For Linux:

Code:

wget mysqltuner.pl
wget tuning-primer.sh

Unfortunately, I can't find a tuning-primer.sh alternative that runs under MS Windows. You run these tools while MySql server is running.

Another possibility is to use mariadb instead of MySQL. mariadb is a drop in replacement for MySQL that runs quicker. I use mariadb with XBMC and it works great. A lot faster then using MySQL.

For Windows: http://www.iaji.net/step-by-step-guide-i...ows-7.html
For Linux: https://downloads.mariadb.org/

How do I run these? I have Windows 8 and run MySql from Command Prompt... I downloaded http://mysqltuner.codeplex.com/ but I don't understand how to fix what it says is high or wrong...

Please help with my results up top.

[winestock]

It seems like when I enter menu's or libraries it freezes and then it will be fine but its random and not all the time...

What you might be experiencing is a resource sharing issue where MySql is using a lot RAM. I would suggest that you try running a MySQL tunning script. The script will evaluate your MySQL config and give you suggestions on how to fix issues that might exist.

For Windows: http://mysqltuner.codeplex.com/
For Linux:

Code:

wget mysqltuner.pl
wget tuning-primer.sh

Unfortunately, I can't find a tuning-primer.sh alternative that runs under MS Windows. You run these tools while MySql server is running.

Another possibility is to use mariadb instead of MySQL. mariadb is a drop in replacement for MySQL that runs quicker. I use mariadb with XBMC and it works great. A lot faster then using MySQL.

For Windows: http://www.iaji.net/step-by-step-guide-i...ows-7.html
For Linux: https://downloads.mariadb.org/

How do I run these? I have Windows 8 and run MySql from Command Prompt... I downloaded http://mysqltuner.codeplex.com/ but I don't understand how to fix what it says is high or wrong...

Please help with my results up top.

It appears that MySQL is only using 6% of total memory. I am not sure what to fix at this point. In order to run tuning-primer.sh you would need to install CygWin which is a bash shell emulator for Windows.