Windows x64

jfha73,

We need a lot more information that this.
What exactly do you mean by "running slowly"? What is slow – server startup, connecting to the server, queries updating the database, queries selecting from the database, if it's queries, then what exactly they are and how you measure the time, please provide examples.

I also don't quite understand what you mean by "speeding up in terms of development", could you please elaborate on this?

Thanks.

For example running phpMySQL it takes a minute to login or perform any action, while 5.5.45 takes just seconds.

While with my developments, y use MariaDB for my customers websites, when running on version10.x.x.x their websites run slower than when running version 5.5.x.

To me the time difference is so big that I'm thinking on telling my customers to use version 5.5.x or even use MySQL Community Edition so their websites run faster.

============
Jorge F. Hernandez

jfha73,
While there can of course be some performance problems that we don't know of, I am sure we would have heard numerous complaints if it was as simple as getting a minute-long slow down on any connection; and to my knowledge, it's the first time we are getting it, even though 10.0 has been around for quite a while. So, my first guess is that it's a configuration issue, second guess is that it somehow heavily depends on your data or its current state.

In any case, we are very interested to get to the bottom of the problem.

First of all, you mentioned 10.0 galera in the 'Affects version' field, was it intentional? Do you actually use a Galera cluster or binaries from MariaDB Galera cluster to run a stand-alone MariaDB server?

Secondly, did you run mysql_upgrade after upgrading your instance from 5.5 to 10.0? If you did not, please try it.

Further, would you be able to perform a side-by-side experiment on your 5.5 server and 10.0 server?

• enable general log, slow log, and higher level of log warnings on both machines

  SET GLOBAL general_log=ON, slow_query_log=ON, log_warnings=10;

  SELECT @@general_log_file, @@slow_query_log_file, @@log_error; # This is for you, to know where the logs will be

  # If any of these variables are empty, set them explicitly

• connect to each machine in the same way (which shows the distinct drop in performance on 10.0 comparing to 5.5), run some queries which are slower, disconnect;
• collect all files above (three log files from each instance), plus your ini files from both machines, and send them to us – either attach to this issue or, if you think there is anything confidential in there, you can upload them to our ftp.askmonty.org/private

Thanks.

Closing as incomplete for now; please comment to re-open if you have more information.