I’m testing MySQL clients (GUI) on openSUSE and I have run into a problem. So far I have found 2 clients that suits me: Valentina Studio (VStudio) and Navicat.
The first was Valentina Studio but I noticed at the start that it is extremely slow (connecting to server, loading tables, views etc.) so I kept looking for another application.
The next I have found was Navicat (it runs through wine but whole package including wineprefix is provided) but it turned out that it is slow too.
I have no such problems with dbForge on Windows which runs as Virtual Machine on my Leap 42.2 and with mysql-workbench on Linux. I also tested DataGrip and I think it doesn’t make that problem either.
My father is helping me finding that client as he is also using Leap 42.2 and he doesn’t have those problems, everything runs smoothly.
I’ve already posted that on Facebook openSUSE group but I was told to post it here as some output might be required. So what should I give you to help me solving that problem?
Determine if your problem is based on running both your client and server on the same machine. Deploy on different machines.
Is there latency after your tables are loaded? Particularly if there is a lot of data, loading into a client can take awhile.
View disk I/O (eg iotop) looking for latencies related to different activity.
Are you running in virtualization? Is your file system virtualized? If so, verify you don’t have disk block mis-alignment (see my following write-up and others on the web). In fact, look through a number of articles I’ve written about optimizing virtualized deployments https://en.opensuse.org/User:Tsu2#Virtualization
Verify you’re not experiencing memory pressure. Besides the memory optimization article in my above link for virtualization, the following is my write-up for how to use the Free memory utility (it’s also displayed in top) https://en.opensuse.org/User:Tsu2/free_tool