Reputation
13,642
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 10 26
Newest
 Scholar
Impact
~927k people reached

19h
comment Is Mongodb a smart decision for a social network?
Would you prefer to learn SQL or have to re-invent it in your own code?
21h
comment MySQL server refuses remote connection when under high load
Are you running a hosted service? I heard of one that drops max_connections when the load gets too high. (I have 4-letter words for describing them.)
1d
comment MySQL server refuses remote connection when under high load
What are the values of max_connections and Max_used_connections?
1d
answered How to set mysqldump using /*!40101 SET character_set_client = utf8mf4 */;?
1d
comment Cant initialize MySQL. “mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended”
Another permission check: Was mariadb being run as mysql?
1d
answered pick data from multiple tables
1d
revised Could not connect to the specific instance. MySQL error number 1045. Access denied for user 'root'@'my public ip' (using password:YES)
clean up numbered list
1d
comment MySql Error : Database page corruption on disk
Let's see my.cnf; although probably nothing there could have caused trouble. The 'instructions' in mysqld.err are what to work with. You may have to reload the data. You could file a bug at mariadb.com .
1d
comment MySQL 5.6 performance_schema not showing queries from application
If you remove the WHERE clauses and LIMIT, do you see your query?
2d
comment Maximum number of TEXT/BLOB columns per table/performance of table with many of them?
1000 tables is a lot, but that might be the better approach. Or JSON.
2d
comment Maximum number of TEXT/BLOB columns per table/performance of table with many of them?
Are the CSVs similar in that they have approximately the same columns but in a _different_order? If so, rearrange them as you load them.
2d
answered MariaDB - cannot set max_connections and wait_timeout through my.cnf
2d
answered MySql: Migration from 5.1 to 5.5
2d
comment MySql: Migration from 5.1 to 5.5
That last link was debunked as hardware error by the OP.
2d
comment Completely reset innodb logs and files
Deleting all those files will delete all the tables and databases; you will have no data.
2d
comment Completely reset innodb logs and files
Which log is "in the future"? If it is a replication log, there is a simple fix.
2d
comment Slow search by LIKE and other values (1 million rows+)
I see an "array" of kode, etc, splayed across columns. Don't design schema that way; use multiple rows in another table.
2d
comment Slow search by LIKE and other values (1 million rows+)
Sometimes you can speed things up by turning OR into a UNION of SELECTs. You could try it on the first two things OR'd -- if you are not using a leading wild card. INDEX(navn), INDEX(keywords), Or you could try it on the last 4 things OR'd. INDEX(forretningsadresse_fylke, forretningsadresse_kommune).
2d
comment Slow search by LIKE and other values (1 million rows+)
OR is a performance killer. LIKE '%...' is a performanc killer. Neither allow for using indexes. For your select, the entire table will be scanned.
2d
comment MySQL database repair - innodb tables
Let's see the actual messages from mysqld.err.