recentpopularlog in

mysql

« earlier   
MySQL Tutorial - Learn MySQL Fast, Easy and Fun.
MySQL Tutorial website provides you with the most comprehensive MySQL tutorial that helps you learn MySQL fast, easy & fun.
database  mysql  programming  sql  programming_improvement_plan 
yesterday by jonny
How to pass password to mysql command line - Unix & Linux Stack Exchange | https://unix.stackexchange.com/
It doesn't look like you can send a password to 'mysql' on stdin, even though that's where it seems to be expecting it from with the '-p' (no password) option.

So I ended up using the '--defaults-file' option.
mysql  cli  dba  commandline  pipes  subprocess  python  workaround  solution 
yesterday by kme
Don’t Waste Your Time With MySQL Full-Text Search – Hacker Noon
It’s executed in 50 seconds, which makes it unusable…

Please note this is the same query as above, with only one additional condition (id > 10000000). Moreover, the query doesn’t return any rows, because the additional condition excludes all rows (all IDs are below 10,000,000).

Why is it so slow? It’s because the term “commercial” used in my query is common (~300,000 documents contain the term) and because MySQL is not good at merging indexes. Basically, MySQL uses the full-text index to lookup for the term “commercial”, and then it does a kind of nested join to lookup for the 300,000 rows and check the condition on id. The former is very quick, but the latter is extremely slow.

It would be really great for MySQL to be able to combine multiple index using an in memory bitmap. This would make the built-in full-text search a lot more useful. In the meantime, I have to find an alternate solution.

If you have any idea about how to solve this without switching to another database engine, please reach out to me.
MySQL  SearchTechnologies  Search 
2 days ago by cnk
Innotop for MySQL 8.0 – lefred's blog: tribulations of a MySQL Evangelist
Recently, I did some maintenance on Innotop and I merged several pull requests including one to support MySQL 8.0 (thank you yoku0825 for the contribution).
Innotop  MySQL  PerformanceAnalysis  MySQL8.0  LeFred  blog  2018 
2 days ago by dlb
Innotop - a real-time, advanced investigation tool for MySQL
In this article I will show what are my favorite features of this little tool, that you probably were not aware of. It is not my intention to show all the functionality here, so to get quick idea of the base tool capabilities, check the sample screenshots.
innotop  Percona  2013  intro  Tutorial  MySQL  PerformanceAnalysis  blog  PrzemysławMalkowski 
2 days ago by dlb

Copy this bookmark:





to read