PDA

View Full Version : MySQL versions


Binx
04/04/2014, 09:06 PM
I know that there are different versions of MySQL. But is there any difference using R6? I know it of by heart, however, I don't really understand threaded version. Is it really that much slower to "not" use it?

Regards.

Vince
04/04/2014, 09:50 PM
I wouldn't put my finger on it, initially. However, as your playerbase grows so will your database. Searching through larger tables takes more time. Meanwhile, the server also needs to keep track of players and events. It can't do that while executing a non-threaded query. Regular selects are fairly doable, but once you start to join, group and order the results the execution time significantly increases. Consider this real life example:


SELECT country_code, count(*) AS amount
FROM core_ip_table
GROUP BY country_code
ORDER BY amount DESC


A table with 80k rows. Grouping and ordering takes approximately 60 milliseconds.

Sticking to an older version because you know it isn't really an excuse either. That would be like sticking with DOS while you could use Windows 8. Eventually you'll have to upgrade. Better to do it sooner than later.

Binx
04/04/2014, 09:52 PM
I wouldn't put my finger on it, initially. However, as your playerbase grows so will your database. Searching through larger tables takes more time. Meanwhile, the server also needs to keep track of players and events. It can't do that while executing a non-threaded query. Regular selects are fairly doable, but once you start to join, group and order the results the execution time significantly increases. Consider this real life example:


SELECT country_code, count(*) AS amount
FROM core_ip_table
GROUP BY country_code
ORDER BY amount DESC


A table with 80k rows. Grouping and ordering takes approximately 60 milliseconds.

Sticking to an older version because you know it isn't really an excuse either. That would be like sticking with DOS while you could use Windows 8. Eventually you'll have to upgrade. Better to do it sooner than later.

I understand, but I really can't get the hang of threaded queries. I'll most likely update sometime in the future(if it was taking it's time), thanks anyway Vince!