Dambrozio: So the SELECT main table is also one referenced in the view twice

Dambrozio: Process list shows it’s stuck in “Sending data”

Dambrozio: All the other queries are idling except that particular query and SHOW PROCESSLIST;

Mcguinn: EXPLAIN the query of the view separately

Dambrozio: That view is way slow

Dambrozio: Argh, broke but here it goes, the explain for the view http://pastie.org/10402669

Ecker: It looks like a good candidate for optimization

Hasak: Dambrozio: eliminating view altogether can give even better results than optimizing it

Dambrozio: Yeah, well, it should be replaced by a properly designed table

Dambrozio: That table contains start/stop events

Dambrozio: And they want a report on how long the events were, when they started and when they ended

Dambrozio: But it is also stopped if table “a” has a row for that event manual override

Dambrozio: So it’s handled by the left outer join to the very same table and then picked by subselect to guarantee that the id is that of the next stop event

Bogdan: Trying to repair my mysql databases. when set innodb_recovery to 4, i get the following in the syslog: /etc/mysql/debian-start13193: Triggering myisam-recover for all MyISAM tables

Cheung: Is it possible, when searching for word “tłum”, make mysql look for words “tłum” and “tlum” without providing both keywords ?

Filipek: Soee, use the right collation

Ogles: Q: Im confused. How to create 2 columns with timestamp type first will have CURRENT_TIMESTAMP on any UPDATE, but second CURRENT_TIMESTAMP only on insert

Cosden: I tried several times with different approaches and no success

Easterling: I have an active trigger on a table, which inserts records into a 2nd table to keep an update history. But when doing “show triggers” or querying information_schema I don’t see any triggers. I need to delete this trigger, but now I can’t find it. Any ideas?

Kasting: Nevermind, my user didn’t have permissions to view the triggers

Guzi: I am a little confused.

Schenz: Why concurrency control in databases so strange?

Ganotisi: Why innodb uses MVCC but also uses row-level and table-level locks in repeatable read and serializable levels?

Samas: For example Postgres never uses locks without ‘FOR UPDATE/SHARE’ clause.

Panebianco: Serializable level adds FOR UPDATE to every select

Whetstine: SELECT in REPEATABLE-READ doesn’t lock

Dymond: Guys why I get ERROR 1136 21S01: Column count doesn’t match value count at row 1 when running INSERT INTO notes note VALUES “This is a test!”, “This is another test.”, “And, yet again, another.”; ?

Varieur: Arunpyasi: obviously. 1 != 3

Varieur: Arunpyasi: INSERT INTO tbl col VALUES 1, 2, 3

Spirounias: Hi, whenever I try to generate an EER diagram on MySql Workbench, the tables of the DB show up ok, however, there are no relationships arrows in the graphic, and I have to add them manually for each EER

Stewarts: Do you know if there is a way to be able to generate the EER and detect the tables’ relationships automatically ?

Varieur: Canolucas: did you define FK constraints?

Perfecto: However I dont see them in the graph

Lansing: Canolucas: MySQL Workbench: http://mysql.com/products/tools/workbench/ it has its own chat channel #workbench

Guyot: Varieur, thanks a lot.

Uva: What is a good search library for obtaining ranked/relevance-based results out a specific selection of tables/columns? i asked about this in the past, i forgot the libraries i was suggested

Hiott: For example building an “omni search / smart search” box which will find relevant results out of first names, last names, addresses, phone numbers, company names, event descriptions, etc

Collington: Hi all! Is it possible to log ‘Access Denied’ actions in mysql 5.1.73 on centos ?