transposh and mysql_slow_queries

  • omaichotnho

    (@omaichotnho)


    11 years, 5 months ago

    i use transposh for my site but have problem with mysql database server.
    tmp/mysql_slow_queries
    ex:

    # Sun Nov 25 09:02:31 2012
    # Query_time: 1.411015 Lock_time: 0.004424 Rows_sent: 864 Rows_examined: 1418
    use vietnau3_thaodienpearl;
    SET timestamp=1353859351;
    SELECT original, translated, source FROM wp_translations WHERE (original = ‘Tin tức’ OR original = ‘Welcome’ OR original = ‘visitor’ OR original = ‘Register’ OR original = ‘Login’ OR original = ‘Post an Ad’ OR original = ‘thao dien pearl’ OR original = ‘Căn hộ ….

    http://wordpress.org/extend/plugins/transposh-translation-filter-for-wordpress/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter omaichotnho

    (@omaichotnho)

    11 years, 5 months ago

    # Sat Nov 24 23:52:27 2012
    # Query_time: 2.099604 Lock_time: 0.003476 Rows_sent: 526 Rows_examined: 939
    use vietnau3_thaodienpearl;
    SET timestamp=1353826347;
    SELECT original, translated, source FROM wp_translations WHERE (original = ‘Thảo Điền Pearl’ OR original = ‘Can ho Thao Dien Pearl’ OR original =…………

    Thread Starter omaichotnho

    (@omaichotnho)

    11 years, 5 months ago

    # Fri Nov 23 11:15:17 2012
    # Query_time: 1.620685 Lock_time: 0.005907 Rows_sent: 537 Rows_examined: 928
    use vietnau3_thaodienpearl;
    SET timestamp=1353694517;
    SELECT original, translated, source FROM wp_translations WHERE (original = ‘Tin tức’ OR original = ‘Welcome’ OR original = ‘visitor’ OR original = ‘Register’ OR original = …….

    Plugin Author oferwald

    (@oferwald)

    11 years, 5 months ago

    Hello There,

    I think the trigger for slow log is a bit lower than it should be (I suggest 5 seconds, and not 1 second) however, have you tried the performance improving options suggested on our FAQ?

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘transposh and mysql_slow_queries’ is closed to new replies.