[Bug 56706] New: AppDB does not properly separate the Bugzilla DB
https://bugs.winehq.org/show_bug.cgi?id=56706 Bug ID: 56706 Summary: AppDB does not properly separate the Bugzilla DB Product: WineHQ Apps Database Version: unspecified Hardware: x86-64 OS: Linux Status: NEW Severity: normal Priority: P2 Component: appdb-unknown Assignee: wine-bugs(a)winehq.org Reporter: jnewman(a)codeweavers.com Distribution: --- We would like to split the AppDB and Bugzilla databases onto different hosts. But right now this is impossible due to some queries doing a joins between bugzilla and the appdb. These will need to be re-written to do it in a different way. The worst offender is testData.php ShowVersionsTestingTable method on line 685. I'm sure there are other places as well. -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=56706 Jeremy Newman <jnewman(a)codeweavers.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|normal |major --- Comment #1 from Jeremy Newman <jnewman(a)codeweavers.com> --- Bumping this up in priority. If I could split the databases for appdb and bugs into different servers then that will surely help the performance of both sites. -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
https://bugs.winehq.org/show_bug.cgi?id=56706 Ken Sharp <imwellcushtymelike(a)gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |57151 -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=56706 wineryyyyy(a)gmail.com changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |wineryyyyy(a)gmail.com --- Comment #2 from wineryyyyy(a)gmail.com --- (In reply to Jeremy Newman from comment #1)
Bumping this up in priority.
If I could split the databases for appdb and bugs into different servers then that will surely help the performance of both sites.
In case this is still has bumped priority, please see: https://gitlab.winehq.org/winehq/appdb/-/merge_requests/13 -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=56706 Jeremy Newman <jnewman(a)codeweavers.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|wine-bugs(a)winehq.org |jnewman(a)codeweavers.com Status|NEW |ASSIGNED --- Comment #3 from Jeremy Newman <jnewman(a)codeweavers.com> --- With AppDB MR 13 live, there are no blockers against splitting the DB. I will work on dumping the AppDB DB onto a new VM and switching over to that. -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=56706 Jeremy Newman <jnewman(a)codeweavers.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |RESOLVED Resolution|--- |FIXED --- Comment #4 from Jeremy Newman <jnewman(a)codeweavers.com> --- I've split the database VMs. The AppDB and Bugzilla MariaDB instances are now on separate hosts. Load on one will no longer affect the other. This can now be closed out. -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=56706 Ken Sharp <imwellcushtymelike(a)gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |CLOSED --- Comment #5 from Ken Sharp <imwellcushtymelike(a)gmail.com> --- Closing -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
participants (1)
-
WineHQ Bugzilla