Forum


Notice to all users

We are migrating towards a new forum system located at community.teamspeak.com, as such this forum will become read-only on January 29, 2020

Results 1 to 6 of 6
  1. #1
    Join Date
    December 2009
    Location
    Finland
    Posts
    11

    Major performance regression when updating from 3.0.10.3 to v3.0.11.1

    I noticed a major perfomance regression regarding the newest version which seems to affect at least some platforms. Basically if I try to remove or add a server group, a certain query executes 10-16k times without any obvious reason. This happens with both fresh and updated databases but the issue seems to get worse with either large userbase or multiple server groups.

    The query that is getting executed is (I replaced ' with QUOTE due to CloudFlare protection false positive):
    PHP Code:
    select from clients where client_unique_id QUOTEServerQueryQUOTE and server_id=
    Looks like this query is executing constantly in the background too. As an example I could get average SQL sleep times of 60s with 3.0.10.3 but 3.0.11.1 is constantly querying in a bursty manner.
    Last edited by duidalus; December 1st, 2014 at 08:54 PM.

  2. #2
    Join Date
    June 2002
    Location
    Netherlands
    Posts
    1,049
    What do you mean with "ServerQuery" ? do you mean that litteraly? or do you mean the unique id of a ServerQuery user?

  3. #3
    Join Date
    December 2009
    Location
    Finland
    Posts
    11
    Quote Originally Posted by nwerensteijn View Post
    What do you mean with "ServerQuery" ? do you mean that litteraly? or do you mean the unique id of a ServerQuery user?
    Literally, the query is like that on wire (captured via tcpdump). I also talked with someone on IRC with the very same observation.

  4. #4
    Join Date
    January 2010
    Location
    El Prat de Llobregat (Barcelona, Spain)
    Posts
    2,698
    Quote Originally Posted by nwerensteijn View Post
    What do you mean with "ServerQuery" ? do you mean that litteraly? or do you mean the unique id of a ServerQuery user?
    Permissions --> All clients --> Search by UID --> ServerQuery appears as the UID of the serverquery user.

  5. #5
    Join Date
    June 2008
    Posts
    18,513
    We can reproduce this. A ticket for the developer was created.

    Thank you!
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

  6. #6
    Join Date
    June 2008
    Posts
    18,513
    A new beta was released to fix the perfomance issues with SQLite/MariaDB


    It's a beta release
    Please make a backup of your exisiting databse!

    http://dl.4players.de/ts/releases/pr...0.11.2-Beta-4/
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [Resolved] Regression in PTT handling
    By oh3mqu in forum Windows
    Replies: 1
    Last Post: September 11th, 2012, 04:21 PM
  2. better performance for ServerQuery
    By catalin in forum Linux / FreeBSD
    Replies: 1
    Last Post: July 20th, 2012, 05:02 PM
  3. Linux TS3 Beta35 voice activation regression?
    By tommytom in forum Client Support
    Replies: 3
    Last Post: October 28th, 2010, 08:45 AM
  4. Performance
    By remopini in forum Linux / FreeBSD
    Replies: 3
    Last Post: December 22nd, 2009, 07:44 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •