Page MenuHomePhabricator

Database is slow. Load times abnormally high at times.
Closed, InvalidPublic

Description

The replicated database can't seem to decide whether to be slow or fast. It's starting to become mildly annoying to have to wait 30 seconds, give or take, to have my edit counter report data. Here is a query report taken from the edit counter. It shows all queries made to the DB when compiling the report. Time is logged in seconds.

[executiontime] => Array
    (
        [basic_stats] => Array
            (
                [queries] => Array
                    (
                        [0] => Array
                            (
                                [time] => 13
                                [query] => SELECT COUNT(*) AS count FROM archive_userindex WHERE (`ar_user` ='6188256');
                                [result] => succeeded
                            )

                        [1] => Array
                            (
                                [time] => 6.01
                                [query] => SELECT rev_timestamp, page_title, page_namespace FROM revision_userindex JOIN page ON page_id = rev_page WHERE (`rev_user` = '6188256') AND `rev_timestamp` > 1 ORDER BY rev_timestamp ASC LIMIT 0,2691251;
                                [result] => succeeded
                            )

                    )

                [total] => 19.42
            )

        [replag] => Array
            (
                [total] => 0
                [queries] => Array
                    (
                        [0] => Array
                            (
                                [time] => 0
                                [query] => SELECT UNIX_TIMESTAMP() - UNIX_TIMESTAMP(rc_timestamp) as replag FROM recentchanges_userindex ORDER BY rc_timestamp DESC LIMIT 1;
                                [result] => succeeded
                            )

                    )

            )

        [usergroups] => Array
            (
                [total] => 0.07
                [queries] => Array
                    (
                        [0] => Array
                            (
                                [query] => http://en.wikipedia.org/w/api.php?action=query&list=users&ususers=Fastily&usprop=groups&format=php
                                [time] => 0.07
                                [result] => succeeded
                            )

                    )

            )

        [namespaces] => Array
            (
                [total] => 0.04
                [queries] => Array
                    (
                        [0] => Array
                            (
                                [query] => http://en.wikipedia.org/w/api.php?action=query&meta=siteinfo&siprop=namespaces&format=php
                                [time] => 0.04
                                [result] => succeeded
                            )

                    )

            )

    )

Version: unspecified
Severity: normal

Details

Reference
bz69326

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 22 2014, 3:33 AM
bzimport added a project: Cloud-VPS.
bzimport set Reference to bz69326.
bzimport added a subscriber: Unknown Object (MLST).

And another:

[executiontime] => Array
    (
        [basic_stats] => Array
            (
                [queries] => Array
                    (
                        [0] => Array
                            (
                                [time] => 16.93
                                [query] => SELECT COUNT(*) AS count FROM archive_userindex WHERE (`ar_user` ='6188256');
                                [result] => succeeded
                            )

                        [1] => Array
                            (
                                [time] => 10.99
                                [query] => SELECT rev_timestamp, page_title, page_namespace FROM revision_userindex JOIN page ON page_id = rev_page WHERE (`rev_user` = '6188256') AND `rev_timestamp` > 1 ORDER BY rev_timestamp ASC LIMIT 0,2691251;
                                [result] => succeeded
                            )

                    )

                [total] => 28.19
            )

        [replag] => Array
            (
                [total] => 0
                [queries] => Array
                    (
                        [0] => Array
                            (
                                [time] => 0
                                [query] => SELECT UNIX_TIMESTAMP() - UNIX_TIMESTAMP(rc_timestamp) as replag FROM recentchanges_userindex ORDER BY rc_timestamp DESC LIMIT 1;
                                [result] => succeeded
                            )

                    )

            )

        [usergroups] => Array
            (
                [total] => 0.08
                [queries] => Array
                    (
                        [0] => Array
                            (
                                [query] => http://en.wikipedia.org/w/api.php?action=query&list=users&ususers=Fastily&usprop=groups&format=php
                                [time] => 0.08
                                [result] => succeeded
                            )

                    )

            )

        [namespaces] => Array
            (
                [total] => 0.05
                [queries] => Array
                    (
                        [0] => Array
                            (
                                [query] => http://en.wikipedia.org/w/api.php?action=query&meta=siteinfo&siprop=namespaces&format=php
                                [time] => 0.05
                                [result] => succeeded
                            )

                    )

            )

    )
chasemp added a subscriber: chasemp.

closing due to age and activity