The ibtmp1 once created can’t be shrink by any method without restarting mysql service. There are two ways to handle it: Precaution : At the time of server start you should limit the size of this file as: innodb_temp_data_file_path = ibtmp1:12M:autoextend:max:5G where max 5G means this file size limits to 5GB. Cure : If file … Read more
Some examples of how to query a json data type field: SELECT * FROM users WHERE JSON_EXTRACT(meta_data, “$.first_name”) = ‘bob’; SELECT * FROM users WHERE JSON_EXTRACT(meta_data, “$.age”) IS NOT NULL; SELECT * FROM users WHERE JSON_EXTRACT(meta_data, “$.accepted_policy”) = true; With mysql 5.7.9 + You can also just do this (shortcut for JSON_EXTRACT): SELECT * FROM … Read more
I just came across this problem working with the JSONB column type – the binary version of the JSON type, which doesn’t map to TEXT. For future reference, you can define a custom type in H2 using CREATE DOMAIN, as follows: CREATE domain IF NOT EXISTS jsonb AS other; This seemed to work for me, … Read more
You have to initialize the data directory by running the following command mysqld –initialize [with random root password] mysqld –initialize-insecure [with blank root password]
InnoDB: page_cleaner: 1000ms intended loop took 4013ms. The settings might not be optimal. (flushed=1438 and evicted=0, during the time.) The problem is typical of a MySQL instance where you have a high rate of changes to the database. By running your 5GB import, you’re creating dirty pages rapidly. As dirty pages are created, the page … Read more
There’s so many answers out there saying to reinstall mysql or use some combo of mysqld_safe –skip-grant-tables and / or UPDATE mysql.user SET Password=PASSWORD(‘password’) and / or something else … … None of it was working for me Here’s what worked for me, on Ubuntu 18.04, from the top With special credit to this answer … Read more
Thanks @wchiquito for pointing me right direction. I solved the problem. Here is how I did it. mysql> select * from t1; +—————————————-+——+ | data | id | +—————————————-+——+ | {“key1”: “value1”, “key2”: “VALUE2”} | 1 | | {“key2”: “VALUE2”} | 2 | | {“key2”: “VALUE2”} | 1 | | {“a”: “x”, “b”: “y”, “key2”: … Read more
Here is what I do to remove the validate password plugin: Login to the mysql server as root mysql -h localhost -u root -p Run the following sql command: uninstall plugin validate_password; If last line doesn’t work (new mysql release), you should execute UNINSTALL COMPONENT ‘file://component_validate_password’; I would not recommend this solution for a production … Read more