Re: How do I determine if versions of phpMyAdmin before 4.8.5 is SQL Injectable using sqlmap?

Hello, On 4/17/2019 10:29 AM, Turritopsis Dohrnii Teo En Ming wrote: Subject/Topic: How do I determine if versions of phpMyAdmin before 4.8.5 is SQL Injectable using sqlmap? Good evening from Singapore, Our customer (company name is Confidential/not disclosed) reported that their MySQL

Re: Replication and user privileges

Hello Jim, On 2/25/2019 7:29 PM, Jim wrote: On 2/25/2019 5:46 PM, shawn l.green wrote: Hello Jim, On 2/25/2019 5:04 PM, Jim wrote: I have a question about mysql replication. I believe I understand most of it, but have a question about user privileges. I understand on the master

Re: Replication and user privileges

Hello Jim, On 2/25/2019 5:04 PM, Jim wrote: I have a question about mysql replication. I believe I understand most of it, but have a question about user privileges. I understand on the master, the replication user must have the Repl_slave_priv privilege as described here:

Re: Connections from mysql8.0 to mysql5.1 - bad handshake

Hi Jim, On 10/31/2018 7:12 PM, Halaasz Saandor wrote: 2018/10/31 15:15 ... Jim: Given the following bug report, what I am trying to do does not sound hopeful: https://bugs.mysql.com/bug.php?id=90994 ... Any thoughts or do I need to accept that what I'm attempting just isn't going to work?

Re: High cpu usage

sults from SELECT * FROM information_schema.INNODB_TRX; during the day as we get this issue regularly and will provide feedback. Regards (earlier thread below... ) ________ From: shawn l.green Sent: Thursday, 25 October 2018 9:54:10 PM To: mysql@lists.mysql.com Sub

Re: High cpu usage

Hello Machiel, On 10/25/2018 6:09 AM, Machiel Richards wrote: Good day all Hoping this mail finds you well. I am hoping someone can perhaps give us some guidance here as we now seem to be stuck on a problem and have not been able to find a solution after more than a month.

Re: what is the rationale for not allowing LOCK TABLES in a stored procedure

On 2018-08-18 23:59, shawn l.green wrote: Hello Jeff, On 8/13/2018 12:05 PM, j...@lxvi.net wrote: Hello, I have read through several pages of the reference manual, and I've seen several instances where it is stated that LOCK TABLES (and UNLOCK TABLES) is not allowed in a stored procedure, but so

Re: how to select the record with one sql statement?

Hello sea, On 8/13/2018 7:01 PM, sea wrote: helle, I have a table, like this: pigId dayweigt pig1 2018-1-121 pig2 2018-1-131 pig3 2018-1-141 pig1 2018-1-222 pig2 2018-1-2

Re: what is the rationale for not allowing LOCK TABLES in a stored procedure

Hello Jeff, On 8/13/2018 12:05 PM, j...@lxvi.net wrote: Hello, I have read through several pages of the reference manual, and I've seen several instances where it is stated that LOCK TABLES (and UNLOCK TABLES) is not allowed in a stored procedure, but so far, I haven't found an explanation as

Re: How to get the MySQL Command-Line Tool to display Unicode properly?

Hi Roger, (please note, this is a bottom-post forum) On 3/13/2018 7:54 PM, Roger House wrote: > > On 03/13/2018 03:11 PM, Reindl Harald wrote: >> >> >> Am 13.03.2018 um 22:59 schrieb Roger House: >>> In all respects except one, the treatment of Unicode works just fine. >>> I can write Unicode

Re: Optimize fails due to duplicate rows error but no duplicates found

. *From:* shawn l.green <shawn.l.gr...@oracle.com> *Sent:* 13 February 2018 09:51:33 PM *To:* mysql@lists.mysql.com *Subject:* Re: Optimize fails due to duplicate rows error but no duplicates found Hello Machiel, On 2/13/2018 3:02 AM, Machiel Richards

Re: Optimize fails due to duplicate rows error but no duplicates found

Hello Machiel, On 2/13/2018 3:02 AM, Machiel Richards wrote: Good day guys, I am hoping this mail finds you well. I am at a bit of a loss here... We are trying to run optimize against a table in order to reclaim disk space from archived data which has been removed.

Re: Examples of savepoints and transactions

nuary, 2018 23:19:29 Subject: Re: Examples of savepoints and transactions Den 22-01-2018 kl. 22:01 skrev shawn l.green: Hello Lars, On 1/21/2018 3:37 PM, Lars Nielsen wrote: Hi, I have a system that uses begin and commit transactions. It works like a dream! ;) Now I want to test it by creating test da

Re: Examples of savepoints and transactions

Hello Lars, On 1/21/2018 3:37 PM, Lars Nielsen wrote: Hi, I have a system that uses begin and commit transactions. It works like a dream! ;) Now I want to test it by creating test data. This how ever cannot be rolled back. I think the solution for rolling back test data is to use savepoints

Re: Can't get my query to return wanted data

Hello Chris, On 1/19/2018 12:50 AM, Chris Roy-Smith wrote: Hi I am running mysql 5.7.20 in ubuntu linux 17.10 I have 2 tables, member and status with contents like member: ident, given, surname 1 fredjones 2 johnhoward 3 henry wales 4 jenny brown status:

Re: Question about contributing a patch

On 10/9/2017 3:27 AM, Xiaoyu Wang wrote: Hello,I reported a bug, at https://bugs.mysql.com/bug.php?id=87637, as well as a patch. And Bogdan, the bug hunter, told me this patch would show up on the dev contribution report. So, could anyone please tell me how to contact dev team, or how can I

Re: innodb_read_only issues

Hello Josh, On 9/6/2017 11:01 PM, Josh Paetzel wrote: I've followed the instructions at https://dev.mysql.com/doc/refman/5.7/en/innodb-read-only-instance.html Which starts with: 14.6.2 Configuring InnoDB for Read-Only Operation You can now query InnoDB tables where the MySQL data directory

Fwd: Re: Something strange here...

ryone else. Humbly embarrassed, Shawn Forwarded Message Subject: Re: Something strange here... Date: Wed, 14 Jun 2017 14:04:02 -0400 From: shawn l.green <shawn.l.gr...@oracle.com> Organization: Oracle Corporation To: Chris Knipe <sav...@savage.za.org> Hello Chris,

Re: mysqld_multi

Hello Matthew, On 5/19/2017 12:19 PM, Matthew Black wrote: I just installed MySQL Enterprise Edition 5.7 on RHEL 6.8 to replace an aging 5.1 system running on RHEL 5. We run mysqld_multi with multiple instances, each database on its own TCP Port 33xx. I'm having trouble creating a database on

Re: Ssd vs mix of ssd and spinning disk

Hi Shain, On 5/8/2017 1:53 PM, Shain Miley wrote: Hello, We have traditionally setup our mysql database servers with a mix of ssd and spinning disk drives. We use the ssd drives (Raid-1) for the mysql tablespace data, and we use the spinning disks (15 sas in Raid-1) for the index data, etc.

Re: tcmalloc mysql 5.7.14

(yes, I recognize how late this reply is) On 5/8/2017 7:56 AM, Reindl Harald wrote: Am 08.05.2017 um 13:51 schrieb Machiel Richards: We are having an issue with memory allocations on mysql 5.7.14 whereby mysql is not releasing the memory that is being allocated during mysqldump

Re: Can not add foreign key constraint

On 4/24/2017 2:10 PM, Peter Brawley wrote: On 4/24/2017 12:28, David Mehler wrote: ...snip Adding in a dummy Create Table for the missing referenced `virtual_domains`, we have ... drop table if exists lastauth, virtual_users, virtual_domains; CREATE TABLE virtual_domains ( id int

Re: DATETIME vs CHAR for "timestamp"

On 4/14/2017 3:11 PM, SSC_perl wrote: I have creation date/time fields in my script that are formatted as |MM|DD|hh|mm|ss. Short of changing the script, should I set the field type in MySQL to DATETIME, or would it be better in terms of speed and efficiency to set it as

Re: MySQL server has gone away

On 4/3/2017 8:15 AM, Mahmood N wrote: When I click on the submit button in Moodle and it is waiting for refresh, I execute the mysql command but the output is not meaningful mahmood@ce:/var/www/html/courses$ mysql -u moodle -p Enter password: Welcome to the MySQL monitor. Commands end with

Re: check_mysql_health poll

On 7/15/2016 6:58 AM, Johan De Meersman wrote: Hey, I just happened upon your poll, so I'm sending you brief mail because I have a different opinion still :-) I'm also CCing the MySQL list, as I feel that more input on this might be a good thing - and it's worth some exposure anyway. I

Re: signal handling in mysql cli

Hello Sebastien, You should stop top-posting, it inverts the flow of your investigation making it harder to follow. (see bottom) On 6/21/2016 12:45 PM, Sebastien FLAESCH wrote: The process list show my (killed) thread as follows: mysql> show processlist;

Re: Adding values returned by GREATEST

On 5/14/2016 2:57 PM, Peter Brawley wrote: On 5/14/2016 11:16, shawn l.green wrote: Hello Sukhjinder, On 5/3/2016 8:55 AM, Sukhjinder K. Narula wrote: Hello, i have a question regarding the GREATEST function of mysql. I would like to add the values returned by GREATEST function is mysql

Re: Adding values returned by GREATEST

Hello Sukhjinder, On 5/3/2016 8:55 AM, Sukhjinder K. Narula wrote: Hello, i have a question regarding the GREATEST function of mysql. I would like to add the values returned by GREATEST function is mysql, so a query is like below: For example table t has 6 fields with values as follows: A =

Re: parallel installations of mysql

On 4/20/2016 2:04 PM, Martin Mueller wrote: I am running MySQL 5.6.22 on an iMac as a desktop database. I would like to install 5.7.12. Can I install it as a parallel and independent instance? And if so, are there special problems to watch out for? Why would I want to do this? Well, I

Re: threads in cleaning up mode

On 4/2/2016 10:36 AM, geetanjali mehra wrote: Hi to all, For many days, I am struggling with the problem of increasing history list length on mysql 5.6.29. Application that this server is running IOT based. Also, this server has so many threads running in sleeping mode. SHOW ENGINE INNODB

Re: need help from the list admin

On 4/1/2016 10:08 AM, Lentes, Bernd wrote: - On Apr 1, 2016, at 3:12 PM, Bernd Lentes bernd.len...@helmholtz-muenchen.de wrote: Btw: i read about isolation levels. REPEATABLE READ is the default for InnoDB. http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_repeatable_read says:

Re: need help from the list admin

On 4/1/2016 9:12 AM, Lentes, Bernd wrote: - On Mar 25, 2016, at 9:54 PM, shawn l.green shawn.l.gr...@oracle.com wrote: "Unsafe" in that sense replies to the fact that certain commands can have a different effect when processed from the Binary Log than they did when they wer

Re: need help from the list admin

On 3/30/2016 1:26 PM, Lentes, Bernd wrote: - On Mar 30, 2016, at 7:04 PM, Reindl Harald h.rei...@thelounge.net wrote: So i should use the default (autocommit=1)? no, you should what is appropriate for your application if you don't care about inserts/updates triggered by let say a

Re: need help from the list admin

Hello Bernd, On 3/28/2016 3:36 PM, Lentes, Bernd wrote: - On Mar 27, 2016, at 2:49 PM, Reindl Harald h.rei...@thelounge.net wrote: Am 27.03.2016 um 14:34 schrieb Lentes, Bernd: You would be better served by first converting your MyISAM tables to InnoDB to stop mixing storage engine

Re: mysql query for current date accounting returns NULL

On 3/26/2016 4:36 PM, shawn l.green wrote: On 3/25/2016 6:39 AM, JAHANZAIB SYED wrote: I have Freeradius 2.x with MySQL 5.5 in Ubuntu. I want to query user quota for current date. I am using following code SELECT (SUM(acctinputoctets)+SUM(acctoutputoctets)) AS Total FROM radacct where

Re: mysql query for current date accounting returns NULL

On 3/25/2016 6:39 AM, JAHANZAIB SYED wrote: I have Freeradius 2.x with MySQL 5.5 in Ubuntu. I want to query user quota for current date. I am using following code SELECT (SUM(acctinputoctets)+SUM(acctoutputoctets)) AS Total FROM radacct where (acctstarttime between

Re: need help from the list admin

Hello Bernd, Sorry for the delay, I wanted to make sure I had enough time to address all of your points. On 3/22/2016 7:07 AM, william drescher wrote: sent for Bernd, and to see if it works from another sender -- Lentes, Bernd wrote: Hi, i know

Re: can I just encrypt tables? what about the app?

On 3/3/2016 10:40 AM, lejeczek wrote: On 02/03/16 00:51, shawn l.green wrote: On 3/1/2016 6:26 PM, lejeczek wrote: On 29/02/16 21:35, shawn l.green wrote: On 2/29/2016 3:13 PM, Reindl Harald wrote: Am 29.02.2016 um 20:54 schrieb Gary Smith: On 29/02/2016 19:50, Reindl Harald wrote

Re: characters oddity

On 3/2/2016 11:29 AM, McGranahan, Jamen wrote: Have two virtual machines, both running RedHat 7. Both are also running MySQL 5.6.29 and both have the same data. We have two databases, however, that keep throwing odd characters on one system but it's OK on the other and we've not been able

Re: can I just encrypt tables? what about the app?

On 3/1/2016 6:26 PM, lejeczek wrote: On 29/02/16 21:35, shawn l.green wrote: On 2/29/2016 3:13 PM, Reindl Harald wrote: Am 29.02.2016 um 20:54 schrieb Gary Smith: On 29/02/2016 19:50, Reindl Harald wrote: cryptsetup/luks can achieve that way better Only to a degree

Re: can I just encrypt tables? what about the app?

On 2/29/2016 3:13 PM, Reindl Harald wrote: Am 29.02.2016 um 20:54 schrieb Gary Smith: On 29/02/2016 19:50, Reindl Harald wrote: cryptsetup/luks can achieve that way better Only to a degree. no - not only to a degree - when the question is "not store anything unencrypted on the disk"

Re: can I just encrypt tables? what about the app?

Hi Reindl, On 2/29/2016 2:16 PM, Reindl Harald wrote: Am 29.02.2016 um 20:07 schrieb Jesper Wisborg Krogh: Hi Lejeczek, On 1/03/2016 00:31, lejeczek wrote: hi everybody a novice type of question - having a php + mysql, can one just encrypt (internally in mysql) tables and php will be

Re: using alias in where clause

On 1/28/2016 6:30 PM, Larry Martell wrote: On Thu, Jan 28, 2016 at 5:45 PM, shawn l.green <shawn.l.gr...@oracle.com> wrote: On 1/28/2016 3:32 PM, Larry Martell wrote: On Thu, Jan 28, 2016 at 2:13 PM, shawn l.green <shawn.l.gr...@oracle.com> wrote: On 1/28/2016 1:14 PM, L

Re: using alias in where clause

On 1/28/2016 1:14 PM, Larry Martell wrote: On Tue, Jan 26, 2016 at 8:40 AM, Hal.sz S.ndor wrote: 2016/01/25 19:16 ... Larry Martell: SELECT IFNULL(f_tag_bottom, IFNULL(f_tag_bottom_major_axis, IFNULL(f_tag_bottom_minor_axis,

Re: using alias in where clause

On 1/28/2016 3:32 PM, Larry Martell wrote: On Thu, Jan 28, 2016 at 2:13 PM, shawn l.green <shawn.l.gr...@oracle.com> wrote: On 1/28/2016 1:14 PM, Larry Martell wrote: On Tue, Jan 26, 2016 at 8:40 AM, Hal.sz S.ndor <h...@tbbs.net> wrote: 2016/01/25 19:16 ... Larry Martel

Re: mysql\innodb_table_stats.ibd. Cannot open tablespace

Hello Neil, On 1/22/2016 3:23 PM, Neil Tompkins wrote: 2016-01-22 19:43:48 2556 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/innodb_table_stats uses space ID: 1 at filepath: .\mysql\innodb_table_stats.ibd. Cannot open tablespace sportstrader/event

Re: Renaming a table that has a trigger, then attempting to drop that trigger results in 'table doesn't exist' error.

Hello Michael, On 1/6/2016 12:51 PM, Michael Vaughan wrote: If you execute the script below, you will get the following error: 'Error Code: 1146. Table 'testschema.TestRenamed' doesn't exist" delimiter // CREATE TABLE Test( id int not null primary key auto_increment, name varchar(255)

Re: Global read lock on delete

On 12/9/2015 9:59 AM, Artem Kuchin wrote: Hello! I am actually using MariaDB, but they do not seem to have any public discussion system and i suppose that engine is the same basically, so, problems are probably the same. Today i setup the server to show locks and notice this: |THREAD_ID

Re: Global read lock on delete

On 12/9/2015 12:06 PM, Artem Kuchin wrote: 09.12.2015 19:35, shawn l.green пишет: INSERT operations are special as you can enable a mode to allow INSERTs to happen only at the end of the file and not be blocked while one of the other two operations are in progress. Cannot find anything

Re: Global read lock on delete

On 12/9/2015 11:59 AM, Artem Kuchin wrote: 09.12.2015 19:35, shawn l.green пишет: On 12/9/2015 9:59 AM, Artem Kuchin wrote: Hello! |THREAD_ID LOCK_MODE LOCK_DURATION LOCK_TYPE TABLE_SCHEMATABLE_NAME 268871 MDL_INTENTION_EXCLUSIVE MDL_EXPLICITGlobal read lock 270022

Re: --initialize specified but the data directory has files in it. Aborting.

Hello Jim, On 11/13/2015 11:12 AM, jim Zhou wrote: Hi, I did "yum install myswl-community-server" and "service mysqld start" I got the error Initializing MySQL database: 2015-11-13T15:54:01.203931Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2015-11-13T15:54:01.204205Z

Re: Query Help...

On 10/22/2015 11:48 AM, Don Wieland wrote: On Oct 20, 2015, at 1:24 PM, shawn l.green <shawn.l.gr...@oracle.com> wrote: Which release of MySQL are you using? Version 5.5.45-cll How many rows do you get if you remove the GROUP_CONCAT operator? We don't need to see the r

Re: Query Help...

On 10/20/2015 1:54 PM, Don Wieland wrote: Hi all, Trying to get a query working: SELECT ht.*, CONCAT(o.first_name, " ", o.last_name) AS orphan, GROUP_CONCAT(DISTINCT hti.rec_code ORDER BY hti.rec_code ASC SEPARATOR ", ") AS alloc FROM hiv_transactions ht LEFT JOIN tk_orphans o ON

Re: Query optimizer-miss with unqualified expressions, bug or feature?

On 10/19/2015 3:48 PM, Roy Lyseng wrote: Hi Ben, On 19.10.15 16.07, Ben Clewett wrote: Hi Roy, Thanks for the clear explanation. I guess (hypothetically) the optimizer could see if it has a key, and then use two starts: one on 'a > 0' and one on 'a < 0', taking a union of the result? Which

Re: When to create a new database

On 10/10/2015 10:28 AM, Richard Reina wrote: If I were keeping tract of high school sports statistics and thus designed the following tables: sports, rules, statistical definitions and players, teams, games Would it be a good or bad idea to put the first set of tables in a separate

Re: Relational query question

On 9/29/2015 1:27 PM, Ron Piggott wrote: On 29/09/15 13:01, Richard Reina wrote: If I have three simple tables: mysql> select * from customer; +++ | ID | NAME | +++ | 1 | Joey | | 2 | Mike | | 3 | Kellie | +++ 3 rows in set (0.00 sec) mysql>

Re: ENUM() vs TINYINT

On 9/21/2015 9:03 AM, Richard Reina wrote: I have a column name quarter which I need to have 5 possible inputs; 1, 2, 3, 4, or OT. Because of the OT possibility I am leaning towards ENUM. Hence, I am also thus considering ENUM('first', 'second', 'third', 'fourth', 'overtime') as the input will

Re: Need a little admin help

Hello Steve, On 8/27/2015 9:11 PM, Steve Matzura wrote: I have a Wordpress user who is setting up a Website and says he can't connect to his database. Both I and the Wordpress admin are new to this, so I've probably done something wron when I set him up initiallyg. Once I connected to SQL as

Re: pid-file quite

Hello Martin, Sorry about the delay. My normal support duties don't allow as much time as I like to spend on community issues like this. On 7/31/2015 10:41 AM, Martin Mueller wrote: Dear Mr. Green, first I'd like to thank you for your very clear explanations, which helped. 'mysql' is an

Re: password problem

On 7/31/2015 8:40 AM, Martin Mueller wrote: Sorry for the off-list reply. It was an oversight. That said, the instructions for resetting a forgotten root password have a section for Windows and a section for Unix. The Unix section begins as follows: 1. Log on to your system as the Unix

Re: table design question

Hi Richard, On 7/29/2015 10:19 AM, Richard Reina wrote: If I were to create a database table(s) to tract most common repairs to different appliances I can't decide if it would be better to create one table with a long ENUM column that contains repairs that could be attributed to any appliance

Re: MySQL 5.5 Slow performance to insert

On 7/24/2015 4:35 PM, Camilo Vieira wrote: Hi, My MySQL server is performing very slow inserts. Does somebody could help me to understand what's happening? ... snip ... ---TRANSACTION 31D6D74, ACTIVE 27107 sec mysql tables in use 8, locked 8 7470 lock struct(s), heap size 801208, 849088 row

Re: Post-installation config and startup questions

On 6/23/2015 10:59 AM, Steve Matzura wrote: I'm building a mail system with Dovecot, Postfix and Mailman with MySQL. I have the other three products installed but not yet configured. I'll do that after I get MySQL running. The documentation at

Re: Refresh slave state

On 6/18/2015 2:10 PM, Ben RUBSON wrote: Hello, In order for the slave to quickly show a communication issue between the master and the slave, I set slave_net_timeout to 10. show slave status then quickly updates, perfect. I would also like the master to quickly show when the slave is no more

Re: Why does a group_concat on a join change aggregate values?

Hi Paul, On 5/7/2015 10:17 AM, Paul Halliday wrote: Fighting a bit with this one... If I do something like (pseudo): SELECT count(val) AS n, GROUP_CONCAT(types) AS c_types FROM tbl1 returns something like: n c_types 1 t9 when I add a left join though: SELECT count(val) AS n,

Re: store search result as new table in memory

On 4/7/2015 4:12 PM, Rajeev Prasad wrote: hello Masters, I am a novice, and I am wanting to know how to achieve this: 1million plus row in a table. user runs a search, gets some results. I want to store this result in memory in a way, so that user can fire more SQL searches on this result.

Re: longtext fields in a row

Hi Andrew, On 4/1/2015 1:58 PM, Andrew Wallace wrote: I thought that TEXT fields only stored a pointer to the actual data in the table, not the data itself - storing 9 to 12 bytes in the table: |BLOB| https://dev.mysql.com/doc/refman/5.0/en/blob.htmland|TEXT|

Re: duplicate rows in spite of multi-column unique constraint

Hi Chris, On 3/24/2015 10:07 AM, Chris Hornung wrote: Thanks for the suggestions regarding non-printing characters, definitely makes sense as a likely culprit! However, the data really does seem to be identical in this case: mysql select id, customer_id, concat('-', group_id, '-') from

Re: Help improving query performance

Hi Larry, On 2/1/2015 4:49 PM, Larry Martell wrote: I have 2 queries. One takes 4 hours to run and returns 21 rows, and the other, which has 1 additional where clause, takes 3 minutes and returns 20 rows. The main table being selected from is largish (37,247,884 rows with 282 columns). Caching

Re: Help improving query performance

Hi Larry, On 2/4/2015 3:18 PM, Larry Martell wrote: On Wed, Feb 4, 2015 at 2:56 PM, shawn l.green shawn.l.gr...@oracle.com wrote: Hi Larry, On 2/1/2015 4:49 PM, Larry Martell wrote: I have 2 queries. One takes 4 hours to run and returns 21 rows, and the other, which has 1 additional where

Re: Help improving query performance

Hello Larry, On 2/4/2015 3:37 PM, Larry Martell wrote: On Wed, Feb 4, 2015 at 3:25 PM, shawn l.green shawn.l.gr...@oracle.com wrote: Hi Larry, On 2/4/2015 3:18 PM, Larry Martell wrote: On Wed, Feb 4, 2015 at 2:56 PM, shawn l.green shawn.l.gr...@oracle.com wrote: Hi Larry, On 2/1/2015 4

Re: Upgrading How To

Hi Grant, On 12/26/2014 11:18 AM, Grant Peel wrote: Reindl, I am sorry, in my original post, I forgot to mention that the OLD box and the NEW box are the same physical machine. I need to be able to save all data into files on a memstick or portable disc and restore them to the newly staged

Re: Function

On 12/12/2014 2:38 PM, Alexander Syvak wrote: Hello! How is actually a function done internally in MySQL after CREATE FUNCTION statement? Why can't there be a dynamic SQL inside a function? Sorry for the delay. The answer is embedded in this description of what is or is not allowed

Re: DB redolog

Hi Frank, On 12/17/2014 2:11 AM, xiangdongzou wrote: HI all: As we know,when we shutdown the database cleanly,the database can do a checkpoint.So we don't need redo log againg.In mysql(innodb),we can restart normaly.But oracle database also need redo log group(current), why? While

Re: update and control flow

Hello Martin, On 12/9/2014 9:25 AM, Martin Mueller wrote: I'm trying to get my feet wet with 'if' and 'when' uses in mysql. it would be very useful for update operations, but I can't get it right. If I read the documentation correctly, it should be possible to say something like UPDATE X if

Re: forum vs email

On 12/9/2014 9:10 PM, h...@tbbs.net wrote: 2014/12/09 15:20 -0600, Peter Brawley Nope. And why not? Because no one bothered to implement it? Now I (for the first time?) looked at forums.mysql.com and see more topics than on lists.mysql.com. The former is just more with-it, I guess. I

Re: table-for-column

On 12/1/2014 6:09 AM, Johan De Meersman wrote: - Original Message - From: peter brawley peter.braw...@earthlink.net Subject: Re: table-for-column I wonder if anyone knows why sites like Stack Overflow and those of ours I mentioned are seeing more volume, while this list and all

Re: Help optimize query.

Hello Mimko, Sorry for the late reply. I had a bunch of work to take care of before vacation, then there was the vacation itself. :) On 11/13/2014 2:34 PM, Mimiko wrote: Hello. I have this table: show create table cc_agents_tier_status_log: CREATE TABLE cc_agents_tier_status_log ( id

Re: mysqldump with single-transaction option.

Hello Geetanjali, On 9/23/2014 7:14 AM, geetanjali mehra wrote: 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 acquires a global read lock

Re: When will MySQL support the ANSI SQL MERGE command?

Hello ccleve, On 9/19/2014 3:06 PM, ccleve wrote: 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? You appear to be looking for one of these commands

Re: table comments

Hello Martin, On 9/7/2014 7:42 PM, Martin Mueller wrote: 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 better ways of producing table notes

Re: purge thread

Hello Geetanjali, On 8/26/2014 1:16 AM, geetanjali mehra wrote: I want to understand how to tune innodb_max_purge_lag http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_max_purge_lag when history list length is high. Could anyone explain me. Best Regards,

Re: fragmentation in innodb index

Hello Geetanjali, On 8/26/2014 1:11 AM, geetanjali mehra wrote: Hello to all, I want to know whether my innodb index is fragemented. Is it possible to know? Best Regards, Geetanjali Mehra Senior Oracle and MySQL DBA Corporate Trainer and Database Security Specialist Just like every other

Re: next-key lock

On 8/26/2014 1:12 AM, geetanjali mehra wrote: Hello to all, In repeatable read isolation level, when we issue: Select * from new where c1 between 12 and 17 for update; this range will be locked by innodb by using next-key locks. But, why is is preventing any other session to insert any

Re: inconsistent optimization

Hi Jim, On 8/20/2014 11:04 AM, Jim wrote: Without going into specific details on queries... Using mysql 5.1 as provided with CentOS6, I've noticed some queries providing what I can best explain as inconsistent optimization. The database can be quieted to just controlled queries and at times

Re: how to access Synology's mysql (mariadb) on the command line

Hi Wybo, On 8/20/2014 3:47 PM, Wybo wrote: My Synology station is on 192.168.178.27, the database listens to port 3306, on my FritzBox I forwarded port 3306 to 192.168.178.27, I /can/ connect to the database on http://192.168.178.27/phpMyAdmin/ But when I try: mysql --host=192.168.178.27

Re: how to access Synology's mysql (mariadb) on the command line

Hello Wybo, I cleansed your reply and cc:'ed the list again to share the answer. On 8/20/2014 4:24 PM, Wybo wrote: Hi Shawn, Thanks for your prompt reply - I suppose I'll have to do that query via phpMysqlAdmin. When I do that, the only host that appears is localhost. However, when I browse

Re: Simplifying Queries

Hello Surya, Part of the problem may be that you are so focused on the details that might have lost sight of the purpose. On 7/12/2014 8:24 AM, Surya Savarika wrote: Hi, I have two query series that I wonder whether they can be compacted into a single query: FIRST QUERY SERIES

Re: How to get all known bugs on specified mysql version?

Hello, On 7/6/2014 7:42 PM, 娄帅 wrote: Hi, all, I want to use MySQL 5.6.18 in production, so i want to get all known bugs on this version. Now i check the bugfix section in MySQL 5.6.19 and above version. Am i doing the right thing? Or Do you have a better method? Any input will be

Re: Optimizing InnoDB tables

Hello Antonio, On 6/27/2014 9:31 AM, Antonio Fernández Pérez wrote: ​Hi Reindl, Thanks for your attention. Following the previous mail, I have checked my MySQL's configuration and innodb_file_per_table is enabled so, I think that this parameter not affects directly to fragmented tables in

Re: Optimizing InnoDB tables

Hello Antonio, On 6/24/2014 7:03 AM, Antonio Fernández Pérez wrote: ​Hi list, I was trying to optimize the InnoDB tables. I have executed the next query to detect what are the fragmented tables. ​​SELECT TABLE_SCHEMA,TABLE_NAME FROM TABLES WHERE TABLE_SCHEMA NOT IN (information_schema,mysql)

Re: Optimizing InnoDB tables

Hello Reindl, On 6/24/2014 3:29 PM, Reindl Harald wrote: Am 24.06.2014 21:07, schrieb shawn l.green: It makes a huge difference if the tables you are trying to optimize have their own tablespace files or if they live inside the common tablespace. http://dev.mysql.com/doc/refman/5.5/en

Re: access denied fpr user 'root'@'localhost' (using password: NO)

Hello Érico On 5/29/2014 2:22 PM, Érico wrote: I have ran the following to test a fix for an app issue : delete from mysql.user where user=''; 2lines got effected after this I can´t connect through command line anymore : ./mysqladmin -u root password pwd I get access denied for user

Re: access denied fpr user 'root'@'localhost' (using password: NO)

Hello Érico, On 5/29/2014 3:51 PM, Érico wrote: I am really sorry about this one .. the connection is ok ... I had not checked that I was using mysqladmin instead of mysql now please how can I check what is wrong with my application ( My SQL Admin ) at its login page it asks for user / pwd

Re: Advices for work with big tables

Hello Antonio, On 5/16/2014 9:49 AM, Antonio Fernández Pérez wrote: Hi, I write to the list because I need your advices. I'm working with a database with some tables that have a lot of rows, for example I have a table with 8GB of data. How you design your tables can have a huge impact on

Re: multilple mysql engines, one set of shared table spaces?

Hello Bruce, On 5/14/2014 2:11 PM, Bruce Ferrell wrote: OK, put away the flamethrowers, I KNOW it's dumb. I've been asked for the upteenth time is this possible and if so under what conditions? So I pose the question to the community, is it? Under what conditions? Is it reliable or not? Are

Re: multilple mysql engines, one set of shared table spaces? (addendum)

On 5/14/2014 3:45 PM, shawn l.green wrote: Hello Bruce, On 5/14/2014 2:11 PM, Bruce Ferrell wrote: OK, put away the flamethrowers, I KNOW it's dumb. I've been asked for the upteenth time is this possible and if so under what conditions? So I pose the question to the community, is it? Under

Re: libmysql.lib

Hello David, On 4/29/2014 4:14 PM, David Clark wrote: mysql is open source as I understand it. I have one project out of about 6 that is failing. I want to debug into libmysql.lib to get a better idea what might be going on... even if it is a problem in my code. Where might I find the

Re: Data masking for mysql

Hello Reena, On 4/16/2014 2:57 AM, reena.kam...@jktech.com wrote: Client never give production db with sensitive data to oursourced dev team. But outsourced testing team need a clone of production db for testing. For that client can give a copy of production db with masked sensitive data.

Re: Excluding MySQL database tables from mysqldump

Hello Tim, On 4/4/2014 10:27 PM, Tim Johnson wrote: * Tim Johnson t...@akwebsoft.com [140404 17:46]: Currently I'm running mysql on a Mac OSX partition. I have installed an ubuntu dual-booted partition and put mysql on it. I have already set up a mysql user on the ubuntu OS. In the past I

  1   2   >