Organic Search Agency

  Kanno: Silent_Ninja: the mere presence, yes Kanno: Silent_Ninja: also read the paragrpah that starts "If an internal temporary table is created initially as an in-memory table but becomes too large, MySQL automatically converts it to an on-disk table." Kanno: Silent_Ninja: note those server variable settings Mayrant: Ssh/putty works fine…

  Jencks: Innodb repetable reads postgresql repeatable reads, they are defined and implemented differently Erle: Salle: i just check and say. Heximer: NoOova: If that matters the ANSI standard requires only SERIALIZABLE isolation level. All other levels are up to the vendors discretion to define and implement Heximer: NoOova: Hence…

  Heximer: NoOova: Try the same with: START TRANSACTION WITH CONSISTENT SNAPSHOT Amescua: Btw I use mysql-workbench cause that whats the teacher uses, he also uses the EER diagram to autogenerate code and nearly encourages us to do the same, which I simply find wrong. Amescua: I do that it…

  Amescua: Can anyone help me with this simple question? http://paste.ofcode.org/kkphg75WiBZPGGYajVTrdX Bloyer: Amescua: 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 Amescua: My last INSERT feels wrong, but…

  Hartsch: Mysqlcheck -c usr_web27_1 focus_gal_img -u root -p******* Imbert: Error : Incorrect information in file: './usr_web27_1/focus_gal_img.frm' Heximer: Kukielka: Stored function that calls procedures is really bad idea. Such function can be called anywhere. In WHERE clause of UPDATE statement for example Heximer: Floogy: The Kuhens is: mysqldump OPTIONS database…

  Mcclenon: Voce, awesome. Ačiū : Whisenand: Croutch: So an entity set does not refer to a specific table in a database, but to "Movie" as a cl***ification? Heximer: Miesco: Entity is term from Relational theory. In practice it is rarely used Croutch: Well, a table usually is a model…

  Sorrel: But 1M might be too small Sermeno: Salle, I'll try to define tmpdir=something as you suggested. Heximer: Floogy: 1MB is too small for any practical purposes Byro: Yes I have to moive the server to a decent one. Eaglen: Salle: yeah I realised after it was just my…

  Hasha: Jx, "use dbname" - you maybe define the db directly in php connection so that may differ Laviola: I'm supposedly defining it in the connection, but I have no doubt that could have been done wrong to. Like I said, I'm learning, and when rrors arise, I'm the…

  Helmsing: 2010-01-01 11:00:00 would be the UTC value in that case. Helmsing: If the offset varies from value to value, you have two choices: Helmsing: 1 convert it to UTC before storing it add the offset to the date/time value or 2 store the local time and apply the…

  Cupelli: Hi all, my slow query log is getting large. How do I truncate it without restarting mysqld ? Werre: I don't need to retain it at all Mckever: Domas: thanks. Saw that on stackoverflow, wasn't sure about it though Routhier: ICantCook: check logrotate, maybe it points to a…