[Mediengruppe Thüringen]

This reply is private.

[Mediengruppe Thüringen]

Hi Cliff,

as mentioned in my last post, the posted SQL queries are the bottleneck. Because we’re coming into a massive temp & file sort. This is due the wp post meta data model, querying the _EventStartDate meta_value without any index. As we’re dealing with roundabout 50.000 events and therefore more then a half million post meta rows.

You can take a look here … be patient 😉
http://www.akt-magazin.de/veranstaltungen

I’ve tried some my.cnf tuning on the buffer and temp table options like sort_buffer_size, read_rnd_buffer_size, tmp_table_size, max_heap_table_size … without any notable effects. Maybe you got some advice for tuning the MySQL server for our special needs?

[Mediengruppe Thüringen]

Hi there,

what about our paid pro support?
Just a quick notice or anything else should be possible!
Do you have any advise for tuning the my.cnf to get the calendar running with an acceptable performance?

Big thanks in advance!

[Mediengruppe Thüringen]

This reply is private.

[Author]

Posts