Q: Profiler shows activity on the server side, but does not show any queries or sessions
A: Don’t forget to press the Start button to start capturing.
Q: I connected to MySQL but Sessions are not shown.
A: Neor Profile SQL works as proxy server. It can show sessions which go via profiler only. Your app (or site) must work with profiler as well as with MySQL server. The Profiler need only TCP incomming-connections. And you will see results in Tab Sessions.
Q: Why are there some queries in Session with zero time?
A: Queries with zero time run very fast without delay. Such requests can be cached database or run very quickly, for example if you have a powerful server and a well optimized table.
Q: What does Time % and Duration % of the Session mean?
A: "Time %" — is the proportion of the total execution time of the Session. "Duration %" — is the proportion of the longest query in the session (the ratio of the very long request).
Q: I'm using JetProfiler and it settings are simpler.
A: JetProfiler gets information from MySQL server by 'show status' command and can't get all information of sessions. It works discrete. Neor Profile SQL sniffs all queries to the database. And for that needs to get flow from your app.
Q: Button Profile in the SQL editor tab does not show result
A: The Profile function in the SQL editor works through command SHOW PROFILES. Which added in MySQL Community Server since 5.0.37 version. Check your version of the MySQL Server.
Q: How can I use the profiler with console?
A: For console you shall use the log method with command tail. Or use one of special console tool. Neor Profile SQL is the developer's product in windowed OS.
Q: The Profiler works, but main live histogram doesn't shown data?
A: This graph may not work if your account not able to start command SHOW STATUS. If you have not rights to your database. Try to check your rights on DB server.
Q: How to run installer in the Silent mode?
sqlprofiler-4.1.1.exe /S /D:C:Program Files (x86)Neor Profile SQL
Mac OS X
Q: Profiler cannot connect to MAMP MySQL server.
A: Connection problem in bind network connections in MySQL config:
Free version – copy standart MySQL config file in folder
Pro version – open menu FILE – EDIT – MySQL template
- in config my.cnf remove string
- in Profiler Settings change DB server host localhost to
Changing MySQL port in your scripts
Default port of Neor Profile SQL is 4040. For catching SQL queries you must change in your script default host and port 3306 of MySQL connection. Below shows how it to do.
$ link = mysql_connect('127.0.0.1:4040', 'YOUR_DATABASE', 'YOUR_PASSWORD');
$ dsn = 'mysql:dbname=YOUR_DATABASE;host=127.0.0.1;port=4040';
URL = jdbc:mysql://127.0.0.1:4040/YOUR_DATABASE?user=YOUR_USER&password=YOUR_PASSWORD
string connStr = "server=127.0.0.1;port=4040;database=YOUR_DATABASE;user=YOUR_USER;password=YOUR_PASSWORD;";
con = Mysql.new '127.0.0.1:4040', 'YOUR_USER', 'YOUR_PASSWORD'
con = _mysql.connect('127.0.0.1:4040', 'YOUR_USER', 'YOUR_PASSWORD', 'YOUR_DATABASE')
Changing DB port in popular CMS/Framework
DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=4040
'mysql' => [ 'driver' => 'mysql', 'url' => env('DATABASE_URL'), 'host' => env('DB_HOST', '127.0.0.1'), 'port' => env('DB_PORT', '4040'), 'database' => env('DB_DATABASE', 'YOUR_DB'), 'username' => env('DB_USERNAME', 'YOUR_USER'), 'password' => env('DB_PASSWORD', 'YOUR_PASS'), 'unix_socket' => env('DB_SOCKET', ''), 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'prefix' => '', 'prefix_indexes' => true, 'strict' => true, 'engine' => null, 'options' => extension_loaded('pdo_mysql') ? array_filter([ PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'), ]) : , ],
$ databases = array ( 'default' => array ( 'default' => array ( 'database' => 'YOUR_DB', 'username' => 'YOUR_USER', 'password' => 'YOUR_PASS', 'host' => 'localhost', 'port' => '4040', 'driver' => 'mysql', 'prefix' => '', ),
public $ host = 'localhost:4040';
$ DBHost = "localhost:4040";
return array ( 'default' => array ( 'driver' => 'mysql', 'host' => 'localhost:4040', 'username' => 'YOUR_USER', 'password' => 'YOUR_PASS', 'database' => 'YOUR_DB' ) );
$ dbhost = "localhost:4040";
define('DB_SERVER', 'localhost:4040');File: includes/configure.php
'DB' => array( 'database' => 'YOUR_DB', 'extTablesDefinitionScript' => 'extTables.php', 'host' => 'localhost:4040', 'password' => 'YOUR_PASS', 'username' => 'YOUR_USER', ),
array ( 'db_host_name' => 'localhost', 'db_host_instance' => 'SQLEXPRESS', 'db_user_name' => 'YOUR_USER', 'db_password' => 'YOUR_PASS', 'db_name' => 'YOUR_DB', 'db_type' => 'mysql', 'db_port' => '4040', 'db_manager' => 'MysqliManager', ),