Jump to:

23364 Posts in 18142 Topics by 2862 members

General Questions

SilverStripe Forums » General Questions » mysql performance problem ?

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 580 Views
  • lx
    Avatar
    Community Member
    82 Posts

    mysql performance problem ? Link to this post

    in our latest SS project we having some performance problems with the mysql db server.
    So now i need to find the bottleneck in the database server.
    The configuration of the mysql server is not optimal, but i think i found a problem that comes from SS.
    I am no mysql expert, so please let me know if i am wrong.

    When you define something like :

    static $db = array(..., 'Description' => 'Text', 'Comments' => 'HTMLText');

    the columns for 'Descrition' and 'Comments' are created as 'mediumtext'
    This is the default behaviour
    If you are making queries that uses this table, i think mysql will slow down because of the mediumtext colums.
    The reason is (i think) msql is using temporary tables internal. If tinytext/mediumtext/blob colums exists, mysql cannot create the tmp tables in memory but needs to create them on a harddisk.
    Temporary tables on harddisk are of course slower than creating them in memory.

    The mysql status will show you then a high value for "Created_tmp_disk_tables"

    Can i relpace any mediumtext column with Varchar(1000) ?

    Has anyone ever done some mysql performance testing concerning this "problem".

    lx

    580 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.