Grokbase › Groups › MySQL › mysql
FAQ

MySQL > mysql

Search Discussions

74,163 discussions - 230,246 posts

  • Dear MySQL users, MySQL Connector/Net 6.9.5 is a maintenance release for the 6.9.x series of the .NET driver for MySQL. It can be used for production environments. It is appropriate for use with ...
    Karen langfordKaren langford
    Nov 12, 2014 at 9:43 pm
    Nov 12, 2014 at 9:43 pm
  • Dear MySQL users, MySQL Connector/NET 6.7.6, a new version of the all-managed .NET driver for MySQL has been released. This is the GA, is feature complete. It is recommended for production ...
    Karen langfordKaren langford
    Nov 11, 2014 at 10:38 pm
    Nov 11, 2014 at 10:38 pm
  • Dear MySQL users, MySQL Connector/Net 6.6.7 is a maintenance release for the 6.6.x series of the .NET driver for MySQL. It can be used for production environments. It is appropriate for use with ...
    Karen langfordKaren langford
    Nov 11, 2014 at 10:08 pm
    Nov 11, 2014 at 10:08 pm
  • Can someone help explain something to me? When I use "mysql" to connect to my server, it can take upwards of 15 seconds. When I use any of the Ruby scripts I've written, it's so fast it's not even ...
    Ken D'AmbrosioKen D'Ambrosio
    Nov 10, 2014 at 5:04 pm
    Nov 10, 2014 at 5:04 pm
  • Looking for suggestions on how to best pull some data. I need to do some calcs but pull the data by year and month to make a table like such. 2012 2013 2014 Jan $243 $567 $890 Feb $123 $456 $908 Mar ...
    Steffan A. ClineSteffan A. Cline
    Nov 9, 2014 at 4:43 pm
    Nov 9, 2014 at 8:44 pm
  • Well what I'm interested in - and I was asking my original question about - is SIGNIFICANT difference. If everything I can count for is just "slight" improvements (by which I understand difference ...
    ZbigniewZbigniew
    Nov 6, 2014 at 9:48 pm
    Nov 6, 2014 at 9:48 pm
  • Hi, I have two servers Mysql 5.5 with master to master replication. The second server failed and I needed to remove it to repair the operating system. After this incident the application users have ...
    Camilo VieiraCamilo Vieira
    Nov 5, 2014 at 8:24 pm
    Nov 5, 2014 at 8:24 pm
  • Dear MySQL users, MySQL Utilities version 1.5.3 is a GA release for Utilities 1.5. MySQL Utilities version 1.5.3 is compatible with MySQL Server versions 5.5 and greater. Python v2.6 and v2.7 are ...
    Hery RamilisonHery Ramilison
    Nov 4, 2014 at 11:32 pm
    Nov 4, 2014 at 11:32 pm
  • Again, the suggestion for ENUM was to replace a constrained set of VARCHARs, and yet, you raise a valid point. What is the update frequency of those VARCHARs? If you're adding them often — or if you ...
    Jan SteinmanJan Steinman
    Nov 4, 2014 at 7:06 pm
    Nov 4, 2014 at 7:06 pm
  • Dear MySQL users, MySQL Connector/Python 2.0.2 GA is the second GA version of 2.0 release series of the pure Python database driver for MySQL. It can be used for production environments. MySQL ...
    Hery RamilisonHery Ramilison
    Nov 4, 2014 at 12:46 am
    Nov 4, 2014 at 12:46 am
  • I would hope that the query optimizer converts '2014-11-02' to the three-bytes internal representation of DATE before doing the query, in which case, DATE should actually be a tiny bit faster than ...
    Jan SteinmanJan Steinman
    Nov 2, 2014 at 7:24 pm
    Nov 2, 2014 at 7:24 pm
  • What about using ENUMs? They have nearly the performance of INTEGERs, but you don't have to maintain a string mapping in your programming logic. :::: Yes'm, old friends is always best, 'less you can ...
    Jan SteinmanJan Steinman
    Oct 31, 2014 at 4:37 am
    Nov 3, 2014 at 5:51 pm
  • What about using ENUMs? They have essentially the performance of INTEGERs, but you don't have to maintain a string mapping in your programming logic. :::: Yes'm, old friends is always best, 'less you ...
    Jan SteinmanJan Steinman
    Oct 31, 2014 at 2:32 am
    Oct 31, 2014 at 2:32 am
  • I'm going to establish a large database (ISAM) of simple structure, say the table with only 3 columns: - VARCHAR(80) - VARCHAR(40) - DATE The number of rows can be quite large, about hundred million ...
    ZbigniewZbigniew
    Oct 29, 2014 at 8:02 pm
    Oct 31, 2014 at 12:42 am
  • Hi All :) I am creating an environment based on about 15 hardware nodes. 6 of them will be for mysql databases. They will be divided into three pairs (3x2 nodes). Nodes in every pair will be ...
    Rafał RadeckiRafał Radecki
    Oct 29, 2014 at 9:17 am
    Oct 30, 2014 at 2:37 pm
  • This release introduces enhanced Reverse Engineering dialog, options to prevent annoying warning messages, full support for modern table row formats, support for BLACKHOLE storage engine. Full change ...
    Aleksander AndreevAleksander Andreev
    Oct 28, 2014 at 7:37 am
    Oct 28, 2014 at 7:37 am
  • Dear MySQL users, The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.3. This is a maintenance release for 1.3.x. It can be used for production ...
    Karen langfordKaren langford
    Oct 27, 2014 at 9:12 pm
    Oct 27, 2014 at 9:12 pm
  • Good Afternoon MySQL DBAs & Gurus, Preface: I am an Oracle RAC DBA at heart. I apologize if I'm making this more difficult than it needs to be. Setup: MySQL Community General Linux version 5.6.19 ...
    Tyfanie WineriterTyfanie Wineriter
    Oct 24, 2014 at 12:04 am
    Oct 24, 2014 at 12:04 am
  • Hello, I am looking to post stuff on the mysql community mailing list. Please let me know if there is any additional information you need.
    Max scalfMax scalf
    Oct 22, 2014 at 1:32 pm
    Oct 22, 2014 at 1:32 pm
  • Hey gang, I need a few hours of support from a LAMP developer to resolve a few issues via TeamViewer or GoToMeeting. Anyone who is interested, has the skills, and can offer this to me, please contact ...
    Don WielandDon Wieland
    Oct 15, 2014 at 3:46 pm
    Oct 15, 2014 at 3:46 pm
  • Ubuntu 14.04 LTS, MySQL 5.5.38 I have a setup with multiple tables in one database. One is a memory table. I have replication running to a remote computer for a hot backup. I read the manual forwards ...
    William drescherWilliam drescher
    Oct 15, 2014 at 2:42 pm
    Oct 16, 2014 at 11:32 am
  • Hi all, I'm pleased to announce the call for participation for the FOSDEM 2015 MySQL & Friends devroom. Every year we beat the attendees expectation ! Like every year, FOSDEM takes place the first ...
    Frederic DescampsFrederic Descamps
    Oct 14, 2014 at 7:37 pm
    Oct 14, 2014 at 7:37 pm
  • Hi, I have this problem among several different instaces of 5.6.20. I take all the steps as stated in http://dev.mysql.com/doc/refman/5.6/en/tablespace-copying.html and get no errors neither ...
    Ruben CardenalRuben Cardenal
    Oct 10, 2014 at 12:12 pm
    Oct 10, 2014 at 12:40 pm
  • I often use CASE WHEN ... to pivot tables. For example, splitting sales data by year: SELECT s_product.name AS `Product`, SUM(CASE WHEN YEAR(sales.Date)='2007' THEN sales.Total ELSE NULL END) AS ...
    Jan SteinmanJan Steinman
    Oct 8, 2014 at 6:45 pm
    Oct 9, 2014 at 12:16 am
  • I have a dual-boot OS X/Ubuntu 12.04 arrangement on a mac mini. The ubuntu system has failed and I am unable to boot it. I have one database on the ubuntu partition that was not backed up. I am able ...
    Tim JohnsonTim Johnson
    Oct 5, 2014 at 7:36 pm
    Oct 5, 2014 at 11:54 pm
  • MicroOLAP Direct Access Components for MySQL and Delphi/C++ Builder (also known as MySQLDAC) is a Borland Delphi/C++Builder component set for direct connect to MySQL database server. DAC for MySQL ...
    Aleksander AndreevAleksander Andreev
    Oct 1, 2014 at 8:26 am
    Oct 1, 2014 at 8:26 am
  • Dear MySQL users, MySQL Connector/Net 6.9.4 is a maintenance release for the 6.9.x series of the .NET driver for MySQL. It can be used for production environments. It is appropriate for use with ...
    Karen langfordKaren langford
    Sep 26, 2014 at 10:04 pm
    Sep 26, 2014 at 10:04 pm
  • Dear MySQL users, This is the GA release for Utilities 1.5. MySQL Utilities version 1.5.2 is compatible with MySQL Server versions 5.5 and greater. Python v2.6 and v2.7 are supported. In addition to ...
    Hery RamilisonHery Ramilison
    Sep 26, 2014 at 6:31 pm
    Sep 26, 2014 at 6:31 pm
  • Dear MySQL users, MySQL Cluster 7.4.1 (Milestone Release) is the first public milestone release for MySQL Cluster 7.4. The MySQL Cluster 7.4.1 DMR can be downloaded from the “Development Releases” ...
    Hery RamilisonHery Ramilison
    Sep 26, 2014 at 10:56 am
    Sep 26, 2014 at 10:56 am
  • [Due to length restrictions, this announcement is split into three parts. This is part 3.] Bugs Fixed [contd...] * With DTrace support enabled, certain other compilation options could cause the build ...
    Bjorn MunchBjorn Munch
    Sep 25, 2014 at 9:12 pm
    Sep 25, 2014 at 9:12 pm
  • [Due to length restrictions, this announcement is split into three parts. This is part 2.] Bugs Fixed * Performance; Replication: When processing the dump thread, a semisynchronous replication master ...
    Bjorn MunchBjorn Munch
    Sep 25, 2014 at 9:03 pm
    Sep 25, 2014 at 9:03 pm
  • [Due to length restrictions, this announcement is split into three parts. This is part 3.] Bugs Fixed [contd...] * With DTrace support enabled, certain other compilation options could cause the build ...
    Bjorn MunchBjorn Munch
    Sep 25, 2014 at 8:59 pm
    Sep 25, 2014 at 8:59 pm
  • Dear MySQL users, MySQL Connector/Python 2.0.1 GA is the first GA version of 2.0 release series of the pure Python database driver for MySQL. It can be used for production environments. MySQL ...
    Hery RamilisonHery Ramilison
    Sep 25, 2014 at 10:05 am
    Sep 25, 2014 at 10:05 am
  • Hi, I hope you are the right person to discuss about The Marine Industry Database which includes complete contact details and verified email addresses of - Key Decision makers List, All C-level ...
    AmyAmy
    Sep 23, 2014 at 7:54 pm
    Sep 23, 2014 at 7:54 pm
  • Can anybody please mention the internals that works when we use mysqldump as follows: *mysqldump --single-transaction --all-databases backup_sunday_1_PM.sql* MySQL manual says: This backup operation ...
    Geetanjali mehraGeetanjali mehra
    Sep 23, 2014 at 11:19 am
    Oct 8, 2014 at 11:18 am
  • Hey list, I noticed a table that was trying to fill the disk before the weekend, so I quickly set up an event to gradually clean it out. Yesterday, however, I returned to find 400+ jobs in state ...
    Johan De MeersmanJohan De Meersman
    Sep 23, 2014 at 9:19 am
    Sep 23, 2014 at 9:19 am
  • Dear MySQL users, The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.2. This is a GA release for 1.3.x. It can be used for production environments ...
    Hery RamilisonHery Ramilison
    Sep 23, 2014 at 9:00 am
    Sep 23, 2014 at 9:00 am
  • Dear MySQL users, The MySQL Windows Experience Team is proud to announce the release of MySQL Notifier version 1.1.6, the latest addition to the MySQL Installer for Windows. MySQL Notifier enables ...
    Karen langfordKaren langford
    Sep 22, 2014 at 9:44 pm
    Sep 22, 2014 at 9:44 pm
  • MicroOLAP Direct Access Components for MySQL and Delphi/C++ Builder (also known as MySQLDAC) is a Borland Delphi/C++Builder component set for direct connect to MySQL database server. DAC for MySQL ...
    Aleksander AndreevAleksander Andreev
    Sep 22, 2014 at 10:52 am
    Sep 22, 2014 at 10:52 am
  • I need to do upserts and I need cross-database compatibility. I'd hate to drop support for MySQL in my product. Does MySQL plan to support the ANSI-standard MERGE command for upserts? -- MySQL ...
    CcleveCcleve
    Sep 19, 2014 at 7:14 pm
    Sep 19, 2014 at 7:58 pm
  • the target folder don't matter that is clearly a *MySQL error* that your *MYSQL user* lack the needed permissions
    Reindl HaraldReindl Harald
    Sep 19, 2014 at 2:57 pm
    Sep 22, 2014 at 10:56 am
  • Hi! I want to say sorry in advance for my ignorance. I was wondering how can I extract year-month-day-hour in one go. For example: From "2014-09-17 12:22:16" to "2014-09-17 12" The reason for this is ...
    Jopoy SolanoJopoy Solano
    Sep 18, 2014 at 10:32 pm
    Sep 19, 2014 at 5:40 am
  • Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: " Database Workbench 5 " Version 5.0.2 fixed some issues that came to light after the initial major ...
    Martijn Tonies (Upscene Productions)Martijn Tonies (Upscene Productions)
    Sep 18, 2014 at 9:05 am
    Sep 18, 2014 at 9:05 am
  • I have a question. The “CREATE INDEX Syntax” can not assign a collation. What collation to use to create a index on a column? Thanks Zhigang.
    Zhigang ZhangZhigang Zhang
    Sep 11, 2014 at 4:00 am
    Sep 11, 2014 at 6:02 am
  • Dear MySQL Users, The MySQL developer tools team announces 6.2.2 RC - the final release candidate for MySQL Workbench 6.2. MySQL Workbench 6.2 is the upcoming major update for the official MySQL ...
    Karen langfordKaren langford
    Sep 8, 2014 at 2:29 pm
    Sep 8, 2014 at 2:29 pm
  • The TABLES table in MySQL's information_schema has a TABLE_COMMENT column. Could one use that for ad hoc and manual annotation of that table? And if so, could one change its length? Or are there ...
    Martin MuellerMartin Mueller
    Sep 7, 2014 at 11:49 pm
    Sep 8, 2014 at 3:47 am
  • Hi Brad, I would start looking for an old transaction. You can use SHOW ENGINE INNODB STATUS or the information_schema.INNODB_TRX table to look for that. Best regards, Jesper Krogh MySQL Support -- ...
    Jesper Wisborg KroghJesper Wisborg Krogh
    Sep 7, 2014 at 9:12 am
    Sep 11, 2014 at 11:00 pm
  • so why do you not just try to update first? 5.5.39 is recent and contains *a lot* of bufixes look at the changelogs - there are tons of replication related bugixes with each minor update
    Reindl HaraldReindl Harald
    Sep 6, 2014 at 5:19 pm
    Sep 6, 2014 at 7:49 pm
  • Can anyone tell me why this query is generating an ERROR: DROP TRIGGER rtsadven_development.content_assets_after_insert_subtypes; CREATE TRIGGER ...
    Don WielandDon Wieland
    Sep 6, 2014 at 4:12 pm
    Sep 6, 2014 at 4:12 pm
  •  БАЛАНС - ЭФФЕКТИВНОЕ РЕШЕНИЕ ДЛЯ УМНОГО УЧЕТА "http://djv-com.net/?attachment_id=381" * Ищем Партнеров: Беспроводная Система Комплексного Учета Энергоресурсов. Сбытовые компании: электричества, ...
    DJV-COM AMR/AMM/AMI ProviderDJV-COM AMR/AMM/AMI Provider
    Sep 6, 2014 at 10:13 am
    Sep 6, 2014 at 10:13 am
Latest
Group Navigation
period‹ prev | Latest | first ›
Group Overview
groupmysql @
categoriesmysql
discussions74,163
posts230,246
users35,571
websitemysql.com
irc#mysql

Top users

Sinisa: 5344 posts Paul DuBois: 3108 posts Egor Egorov: 2151 posts Victoria Reznichenko: 1999 posts Sasha: 1921 posts Gerald_clark: 1779 posts Michael Widenius: 1776 posts Gleb Paharenko: 1664 posts Sgreen: 1611 posts Jeremy D . Zawodny: 1559 posts Heikki Tuuri: 1351 posts Sinisa: 1234 posts Paul DuBois: 1193 posts Thimble Smith: 1108 posts Michael Stassen: 1029 posts Benjamin Pflugmann: 952 posts Dnelson: 945 posts Martijn Tonies: 945 posts Jeremy Zawodny: 898 posts Monty: 884 posts
show more
Archives