maria-developers team mailing list archive

[Peter Laursen <peter_laursen@xxxxxxxxxx>]

Running mysql_upgrade did the trick.  Sorry!


C:\Program Files\MariaDB 10.0\bin>mysql_upgrade -uroot -p --port=3313
Enter password: ********
Phase 1/3: Fixing table and database names
Phase 2/3: Checking and upgrading tables
Processing databases
information_schema
mysql
mysql.columns_priv OK
mysql.db OK
..
..
Phase 3/3: Running 'mysql_fix_privilege_tables'...
OK

C:\Program Files\MariaDB 10.0\bin>mysql -uroot -p --port=3313
Enter password: ********
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 13
Server version: 10.0.8-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

MariaDB [(none)]> use performance_schema;
Database changed
MariaDB [performance_schema]> show tables like 'session%';
+-----------------------------------------+
| Tables_in_performance_schema (session%) |
+-----------------------------------------+
| session_account_connect_attrs |
| session_connect_attrs |
+-----------------------------------------+
2 rows in set (0.00 sec)

MariaDB [performance_schema]> exit
Bye

C:\Program Files\MariaDB 10.0\bin>


-- Peter


On Mon, Feb 24, 2014 at 7:29 PM, Peter Laursen <peter_laursen@xxxxxxxxxx>wrote:

> SELECT VERSION(); -- returns "10.0.8-MariaDB"
> USE `performance_schema`;
> SHOW TABLES LIKE 'session%'; -- empty set
>
> .. but  maybe I should run rememer to run mysql_upgrade before complaining
> about such things! :-)
>
>
> I will update in a couple of hours if mysql_upgrade did the trick. If not
> it could be Win-only problem.
>
>
> -- Peter
>
>
> On Mon, Feb 24, 2014 at 5:47 PM, Sergei Golubchik <serg@xxxxxxxxxxx>wrote:
>
>> Hi, Peter!
>>
>> On Feb 24, Peter Laursen wrote:
>> > BTW: the two tables do not exist in P_S in MariaDB 10.0.8
>>
>> What tables don't exist?
>>
>>   MariaDB [test]> SELECT * FROM performance_schema.session_connect_attrs;
>>   +----------------+-----------------+------------+------------------+
>>   | PROCESSLIST_ID | ATTR_NAME       | ATTR_VALUE | ORDINAL_POSITION |
>>   +----------------+-----------------+------------+------------------+
>>   |              2 | _os             | Linux      |                0 |
>>   |              2 | _client_name    | libmysql   |                1 |
>>   |              2 | _pid            | 28713      |                2 |
>>   |              2 | _client_version | 10.0.8     |                3 |
>>   |              2 | _platform       | x86_64     |                4 |
>>   |              2 | program_name    | mysql      |                5 |
>>   +----------------+-----------------+------------+------------------+
>>   6 rows in set (0.00 sec)
>>
>>   MariaDB [test]> SELECT VERSION();
>>   +----------------------+
>>   | VERSION()            |
>>   +----------------------+
>>   | 10.0.8-MariaDB-debug |
>>   +----------------------+
>>   1 row in set (0.00 sec)
>>
>> Regards,
>> Sergei
>>
>
>