mysql   98889

« 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 
2 days ago by jonny
How to pass password to mysql command line - Unix & Linux Stack Exchange |
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 
2 days ago 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 
3 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 
3 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 
3 days ago by dlb

« earlier    

related tags

2013  2018  admin  administration  all  amp  analytics  apache  app  apparmor  apps  aws  backup  bash  binning  blog  cap  centos  cheatsheet  cli  cluster  column  command  commandline  comparisons  consul  containers  create  data  database  dataframe  datamasking  db  dba.stackexchange  dba  debug  design  distributedsystems  django  docker  documentation  dovecot  drop  dump  ecto  elixir  error  errormessage  example  excel  export  failover  file  files  for  frame  free  freeze  full  geirhoydalsvik  genomebrowser  geodata  gis  github  go  golang  grants  guide  ha  haproxy  howto  hybrid  import  including  innodb  innotop  into  intro  itsslow  ivansvaljek  java  jesperwisborgkrogh  jochemfuchs  laravel  learning  lefred  line  linux  lock  locks  logging  mac  macos  macosx  mailhog  mailserver  manual  mariadb  maybesolution  memcached  miguelaraujo  minimalism  monitoring  myisam  mysql5.7  mysql8.0  mysqladmin  mysqldump  mysqlrouter  mysqlshell  mysqltuner  names  nginx  ngrok  nodejs  officialsite  olap  oltp  opensource  optimization  osx  outage  pandas  percona  perconalive2018  performance  performanceanalysis  performanceschema  perl  permissions  php  pipes  play  postfix  postgres  postgresql  postmortem  privacy  privileges  procedure  processlist  programming  programming_improvement_plan  prometheus  przemysławmalkowski  python  python2.7  query  rails  rds  redhat  redis  reference  relational_database  replication  root  ruby  scale  scottnoyes  script  scripts  search  searchtechnologies  security  separate  server  shell  show  simplicity  single  slick  slideshare  software  solution  spatial  sql  sqlserver  srid  stackexchange  stackoverflow  statement  storage  stored  subprocess  svetasmirnova  syntax  sysadmin  table  tables  thaw  tips  tolearn  tools  toread  totry  tounderstand  troubleshooting  tuner  tutorial  tutorials  types  ubuntu  ucsc  users  vagrant  virtualbox  vmware  volumes  w3chools  waiting  webutvikling  windowfunctions  with  wordpress  workaround  备份  阿里云 

Copy this bookmark: