EXT: bk_realulr¶

What does it do?¶

RealURL is a great extension, but when you deal with big website (hundreds or thousand pages generated like www.lyrics-of.com ) you can face the problem of slow queries. So this extension extends 'RealURL' in order to accelerate MySQL by adjusting table structure. This extension works with RealURL 1.0.0. and be aware that alias is now limited to 255 characters.

In the case study of this famous lyrics website the time saved was about 60-80%. You are invited to give feedback (in “user annotations” section) about your website size and the gain you've made using this extension.

Screenshots¶

What is done during installation :

Logging slow queries with MySQL¶

If you're not sure that your slow problem comes from RealURL, you can try amphisize slo queries by adjusting your MySQL configuration file 'my.cnf' by adding these lines (self explicit I guess):

log-slow-queries=/var/log/mysqld/mysqld-slow.loglog-long-formatlong- query-time=1

Example of what you may find¶

# Time: 051108 21:50:05# User@Host: root[root] @ localhost []# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 314085

SELECT value_aliasFROM tx_realurl_uniqaliasWHEREvalue_id=''AND field_alias='title'AND field_id='uid'AND tablename='tx_myextension'AND lang=0AND expire=0;

Another example of slow querie¶

# Time: 051108 23:15:39# User@Host: root[root] @ localhost []# Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 314085

SELECT value_idFROM tx_realurl_uniqaliasWHEREvalue_alias=''AND field_alias='title'AND field_id='uid'AND tablename='tx_myextension'AND (expire=0 OR expire>1131488137);