Kreh: I’m using mysql as the database

Ringeisen: And what version of WB?

Terhaar: Any performance_schema experts around?

Chananie: Asterismo: do you get some sort of error message?

Stecher: Wrong username or p***word

Bronn: But i’m sure i’m not getting the connection with the db

Tecson: I’m following this tutorial: http://pc-freak.net/blog/install-postfix-mail-server-dovecot-mysql-user-storage-debian-wheezy-7-linux/

Wolfley: Snoyes: 6.3, when you get the create table statement of a table

Kretzschmar: Thank you very much snoyes. Works perfectly!

Shebby: Completed tinyint1 NOT NULL DEFAULT ‘0’,

Floren: Asterismo: and what step of that tutorial are you on?

Maysonet: Bear: when you right click the table name, and do Send to SQL Editor?

Platko: Pointing my browser to http://localhost/mailadmin/

Misek: Snoyes: i changed the p***word of the database in the sql script

Kitchens: But i’m afraid there is some issue with the database user maybe

Delorenzo: Asterismo: the only mysql-relevant part of that tutorial is step 2. Everything else is a question for Postfix.

Ganesh: Bear: mine doesn’t do that, it shows b’0′. Can you put a screenshot someplace? If it shows just ‘0’ for a bit field, that’s a bug.

Marton: Snoyes: will do later – just logged off, but I can reproduce it every time

Shipp: Is it possible to access the generated auto increment id during an insert, i want to use it in another column also

Cecil: Guess a trigger should work then

Deible: A before trigger doesn’t have access to it, and an after trigger is too late to change the column.

Schlueter: Your choice are either generate your own sequence instead of relying on auto_increment, or update the table afterward rather than populating the second column in the same statement.

Josefy: Right. an insert and update with last_insert_id wrappen in a transaction then

Gauntt: Can anyone help me figure out why mysql is sitting at 66.7% in top constantly? http://pastie.org/10405627

Ribas: Morissette: Most of the memory in the running instance is being used by the InnoDB buffer pool, which you have set to 2G. This is a good thing.

Howen: Ribas, so not something I should worry about?

Cliffe: Or should I look into increasing RAM?

Nienaber: Had a warning of memusage in monitoring for 88.9% usage

Lungsford: Mem usage not sql memory

Ribas: Morissette: You may want to change the memory allocated to MySQL if you are running other services like http or mail services on the same machine. Otherwise, I wouldn’t be concerned

Bausch: There is http but that is all

Dutra: Hey all. im looking to count the occurrences of a word we’ll say ‘foo’ in a field in a mysql table.

Stollings: LENGTHcommands.output -LENGTHREPLACEcommands.output ,”foo”,” AS ‘Occurances’

Yasin: Can someone please help me out with the Vasko? thanks.

Messerli: Nvm. i got it. needed CHAR_LENGTH

Falkowski: One more try, anyone around who likes to play with performance_schema?

Dammann: SuperQ: do you have some specific question, or do you just want to chat about it?

Gallego: SuperQ: You don’t have to ask to ask, or state: “I have a question”, Don’t ask: “Is anyone around?” or “Can anyone help?”. Just Ask The Question. Also, please read: http://workaround.org/getting-help-on-irc

Dedmon: Any idea to optimize this query http://pastie.org/private/lrt5dtbznpcpsfd85xg ?

Ben: Kolbe: Yes, it’s moderately advanced.

Lapointe: I’m working on instrumenting about 150 mysql servers, gathering metrics from performance_schema.events_statements_summary_by_digest.

Trump: One minor “bug” I’ve found is that events that start with a BEGIN end up being rolled up, even if they’re different transactions