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

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 fine? If not, would it be easy to re-code php to work with this new, internal encryption? Starting with MysQL

Re: dump, drop database then merge/aggregate

Ah, ok, if I understand correctly within this context every record in the one table _should_ have a unique identifier. Please verify this is the case, though, if for example the primary key is an auto increment what I'm going to suggest is not good and Really Bad Things will, not may, happen. If

Re: dump, drop database then merge/aggregate

Totally with you, I had to get up and wash my hands after writing such filth =) On Mon, Feb 29, 2016 at 12:14 PM, Gary Smith wrote: > On 29/02/2016 16:32, Steven Siebert wrote: > >> >> At risk of giving you too much rope to hang yourself: if you use >> mysqldump to dump

Re: dump, drop database then merge/aggregate

On 29/02/2016 16:32, Steven Siebert wrote: At risk of giving you too much rope to hang yourself: if you use mysqldump to dump the database, if you use the --replace flag you'll convert all INSERT statements to REPLACE, which when you merge will update or insert the record, effectively

Re: dump, drop database then merge/aggregate

On 29/02/16 16:32, Steven Siebert wrote: What level of control do you have on the remote end that is collecting/dumping the data? Can you specify the command/arguments on how to dump? Is it possible to turn on binary logging and manually ship the logs rather than shipping the dump, effectively

Re: dump, drop database then merge/aggregate

What level of control do you have on the remote end that is collecting/dumping the data? Can you specify the command/arguments on how to dump? Is it possible to turn on binary logging and manually ship the logs rather than shipping the dump, effectively manually doing replication? I agree with

Re: dump, drop database then merge/aggregate

- Original Message - > From: "lejeczek" > Subject: Re: dump, drop database then merge/aggregate > > today both databases are mirrored/identical > tonight awkward end will dump then remove all the data, then > collect some and again, dump then remove > and these dumps

Re: dump, drop database then merge/aggregate

On 29/02/16 15:42, Gary Smith wrote: On 29/02/2016 15:30, lejeczek wrote: On 28/02/16 20:50, lejeczek wrote: fellow users, hopefully you experts too, could help... ...me to understand how, and what should be the best practice to dump database, then drop it and merge the dumps.. What I'd

Re: dump, drop database then merge/aggregate

On 29/02/2016 15:30, lejeczek wrote: On 28/02/16 20:50, lejeczek wrote: fellow users, hopefully you experts too, could help... ...me to understand how, and what should be the best practice to dump database, then drop it and merge the dumps.. What I'd like to do is something probably many have

Re: dump, drop database then merge/aggregate

On 28/02/16 20:50, lejeczek wrote: fellow users, hopefully you experts too, could help... ...me to understand how, and what should be the best practice to dump database, then drop it and merge the dumps.. What I'd like to do is something probably many have done and I wonder how it's done

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

On 29/02/16 14:38, Steven Siebert wrote: Simple answer is no. What are you trying to accomplish? I was hoping that with this new feature (google's) where mysql itself, internally uses keys to encrypt/decrypt tables or tablespaces I could just secure data, simply. Chance is I don't quite get

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

Simple answer is no. What are you trying to accomplish? S On Mon, Feb 29, 2016 at 8:31 AM, 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 fine? > If not, would it be

can I just encrypt tables? what about the app?

hi everybody a novice type of question - having a php + mysql, can one just encrypt (internally in mysql) tables and php will be fine? If not, would it be easy to re-code php to work with this new, internal encryption? thanks. -- MySQL General Mailing List For list archives:

dump, drop database then merge/aggregate

fellow users, hopefully you experts too, could help... ...me to understand how, and what should be the best practice to dump database, then drop it and merge the dumps.. What I'd like to do is something probably many have done and I wonder how it's done best. A box will be dumping a database

Indexes strangeness

Hi All, Can someone please fill me in as what I am seeing here... I have two identical tables, with identical indexes, having different records. Both tables have +- 15m records in it... mysql> EXPLAIN SELECT ArticleID, DateObtained, DateAccessed, TimesAccessed FROM IDXa ORDER BY DateAccessed

Re: Mysql devel

Am 23.02.2016 um 13:12 schrieb Larry Martell: On Tue, Feb 23, 2016 at 7:07 AM, Larry Martell wrote: On Tue, Feb 23, 2016 at 6:16 AM, Reindl Harald wrote: Am 23.02.2016 um 04:47 schrieb Larry Martell: I am trying to install the mysql devel

Re: Mysql devel

On Tue, Feb 23, 2016 at 7:07 AM, Larry Martell wrote: > On Tue, Feb 23, 2016 at 6:16 AM, Reindl Harald wrote: >> >> >> Am 23.02.2016 um 04:47 schrieb Larry Martell: >>> >>> I am trying to install the mysql devel libs (so I can build MySQLdb). >>>

Re: Mysql devel

On Tue, Feb 23, 2016 at 6:16 AM, Reindl Harald wrote: > > > Am 23.02.2016 um 04:47 schrieb Larry Martell: >> >> I am trying to install the mysql devel libs (so I can build MySQLdb). >> This is on RHEL 6. It's failing as shown below. Can anyone help with >> this? > > > you

Re: Mysql devel

Am 23.02.2016 um 04:47 schrieb Larry Martell: I am trying to install the mysql devel libs (so I can build MySQLdb). This is on RHEL 6. It's failing as shown below. Can anyone help with this? you are mixing remi and other repos Package mysql-community-devel.x86_64 0:5.7.11-1.el6 will be

ANN: DAC for MySQL 3.0.3 is out!

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 allows you to create Delphi/C++Builder applications without BDE, ODBC, ADO and without libmysql.dll.

Mysql devel

I am trying to install the mysql devel libs (so I can build MySQLdb). This is on RHEL 6. It's failing as shown below. Can anyone help with this? # yum install mysql-devel Loaded plugins: dellsysid, product-id, refresh-packagekit, security, subscription-manager Setting up Install Process Package

Re: SAP Customers DB

Am 12.02.2016 um 16:23 schrieb MELISSA White: Would you be interested in acquiring SAP Users contact information in excel sheet for unlimited marketing usage? creep away spammer or your company domain ends in a Sender-Filter (envelope and To-headers) - who do you think you are that you are

RE: Select Earliest Related Row

Select class_name, GROUP_CONCAT(DISTINCT cl_date ORDER BY cl_date DESC SEPARATOR ', ') (select min(cl_date) from CLASS_DATES where item_id = c.item_id and cl_date > Now()) From CLASSES c Join CLASS_DATES cd on (c.item_id = cd.item_id) Group

Select Earliest Related Row

I have a two tables where I am adding CLASSES and CLASS_DATES for people to register for. Table Name = tl_items (Parent) item_id class_name table_name = tl_items_classes (Children) class_date_id item_id cl_date “tl_items" will have 0 to Many “tl_items_classes" using the “item_id” as the KEY

MySQL Community Server 5.7.11 has been released

Dear MySQL users, MySQL Server 5.7.11, a new version of the popular Open Source Database Management System, has been released. MySQL 5.7.11 is recommended for use on production systems. For an overview of what's new in MySQL 5.7, please see

MySQL Community Server 5.5.48 has been released

Dear MySQL users, MySQL Server 5.5.48 is a new version of the 5.5 production release of the world's most popular open source database. MySQL 5.5.48 is recommended for use on production systems. MySQL 5.5 includes several high-impact enhancements to improve the performance and scalability of the

MySQL Community Server 5.6.29 has been released

Dear MySQL users, MySQL Server 5.6.29, a new version of the popular Open Source Database Management System, has been released. MySQL 5.6.29 is recommended for use on production systems. For an overview of what's new in MySQL 5.6, please see

Query Statistics...

Hi All, Perhaps a bit of a trivial question, but in terms of query statistics (i.e. how many SELECT / INSERT / DELETE / etc. queries has been ran against the server)... When you take an INSERT ... ON DUPLICATE KEY UPDATE ... Under the two conditions (i.e. either INSERT, or UPDATE if the record

Re: my.cnf authencication

- Original Message - > From: "Harrie Robins" > Subject: my.cnf authencication > > mysqldump --defaults-file dbase > c:\sql\dbase.sql 2>> c:\log.tct Might just be a typo in your mail, but you'll need to actually pass the defaults-file, too:

RE: my.cnf authencication

Thanks for the reply - that was indeed a typo. I resolved this buy making these changes: mysqldump --defaults-extra-file="c:\sql\dump.cnf" dname > c:\loc with my cnf containing: [client] user = user password = pass Looks like I misplaced "" and or [client] / [mysqldump] in the cnf Thanks

my.cnf authencication

I'm running a mysqldump in windows and I'm mailing 2>> output, right now I get this annoying 'insecure' error that pollutes my log. So I figured I use --defaults-file and set: In c:\sql\dump.cnf [mysqldump] user = myuser password = pass my line looks like this mysqldump --defaults-file

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 wrote: On 1/28/2016 3:32 PM, Larry Martell wrote: On Thu, Jan 28, 2016 at 2:13 PM, shawn l.green wrote: On 1/28/2016 1:14 PM, Larry Martell

Re: using alias in where clause

On Fri, Jan 29, 2016 at 11:15 AM, shawn l.green wrote: > > > On 1/28/2016 6:30 PM, Larry Martell wrote: >> >> On Thu, Jan 28, 2016 at 5:45 PM, shawn l.green >> wrote: >>> >>> >>> >>> On 1/28/2016 3:32 PM, Larry Martell wrote: On

Re: using alias in where clause

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, >>IFNULL(f_tag_ch_x_bottom, >>

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 wrote: 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

Re: using alias in where clause

On Thu, Jan 28, 2016 at 2:13 PM, shawn l.green wrote: > > > 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,

Re: using alias in where clause

On Thu, Jan 28, 2016 at 5:45 PM, shawn l.green wrote: > > > On 1/28/2016 3:32 PM, Larry Martell wrote: >> >> On Thu, Jan 28, 2016 at 2:13 PM, shawn l.green >> wrote: >>> >>> >>> >>> On 1/28/2016 1:14 PM, Larry Martell wrote: On

C++ comment in binary_log_types.h header

Hi all, In version 5.7.10, I found a C++ comment in the .h headers: #endif // __cplusplus Should be: #endif /* __cplusplus */ To avoid: cc -g -fsanitize=address -fno-omit-frame-pointer -W -Wall -pedantic -Wmissing-prototypes \ -Wno-long-long -Werror -fPIC \

Re: using alias in where clause

2016/01/25 19:16 ... Larry Martell: SELECT IFNULL(f_tag_bottom, IFNULL(f_tag_bottom_major_axis, IFNULL(f_tag_bottom_minor_axis, IFNULL(f_tag_ch_x_bottom, IFNULL(f_tag_ch_y_bottom, NULL) as ftag,

bytes in Recv-Q not processed by mysql

Hi All In my application while writing to DB , i could see the following output from netstat for a single connection to the mysqld DB. *** tcp 18 0 :::127.0.0.1:3306 :::127.0.0.1:43029 ESTABLISHED 30850/mysqld keepalive (3517.74/0/0)

Re: using alias in where clause

On Mon, Jan 25, 2016 at 9:32 PM, Larry Martell wrote: > On Mon, Jan 25, 2016 at 8:26 PM, Johnny Withers > wrote: > > You should probably turn this into a UNION and put an index on each > column: > > > > SELECT f_tag_ch_y_bottom AS ftag FROM

Re: using alias in where clause

On Mon, Jan 25, 2016 at 8:26 PM, Johnny Withers wrote: > You should probably turn this into a UNION and put an index on each column: > > SELECT f_tag_ch_y_bottom AS ftag FROM data_cst WHERE f_tag_ch_y_bottom = > 'E-CD7' > UNION ALL > SELECT f_tag_ch_x_bottom AS ftag FROM

Re: using alias in where clause

You should probably turn this into a UNION and put an index on each column: SELECT f_tag_ch_y_bottom AS ftag FROM data_cst WHERE f_tag_ch_y_bottom = 'E-CD7' UNION ALL SELECT f_tag_ch_x_bottom AS ftag FROM data_cst WHERE f_tag_ch_x_bottom = 'E-CD7' UNION ALL SELECT f_tag_bottom_minor_axis AS ftag

Re: using alias in where clause

Am 26.01.2016 um 01:16 schrieb Larry Martell: I know I cannot use an alias in a where clause, but I am trying to figure out how to achieve what I need. If I could have an alias in a where clause my sql would look like this: SELECT IFNULL(f_tag_bottom,

Re: using alias in where clause

Have you tried using a select case statement for ftag? > On Jan 25, 2016, at 6:39 PM, Larry Martell wrote: > > On Mon, Jan 25, 2016 at 7:27 PM, Reindl Harald wrote: >> >> >> Am 26.01.2016 um 01:16 schrieb Larry Martell: >>> >>> I know I

using alias in where clause

I know I cannot use an alias in a where clause, but I am trying to figure out how to achieve what I need. If I could have an alias in a where clause my sql would look like this: SELECT IFNULL(f_tag_bottom, IFNULL(f_tag_bottom_major_axis,

Re: using alias in where clause

On Mon, Jan 25, 2016 at 7:27 PM, Reindl Harald wrote: > > > Am 26.01.2016 um 01:16 schrieb Larry Martell: >> >> I know I cannot use an alias in a where clause, but I am trying to >> figure out how to achieve what I need. >> >> If I could have an alias in a where clause my

Re: using alias in where clause

On Mon, Jan 25, 2016 at 8:01 PM, Rebecca Love wrote: > Have you tried using a select case statement for ftag? How would that help? Unless I'm missing something, I'd still have to have a reference to the column alias in the where clause. >> On Jan 25, 2016, at 6:39 PM, Larry

mysql\innodb_table_stats.ibd. Cannot open tablespace

Hi, Hoping someone can help me identify why I keep having to restore my database. You can see below, that my machine shut down normally, yet when I restarted the machine back up, I'm getting the error 'mysql\innodb_table_stats.ibd. Cannot open tablespace' and am having to delete the current

Re: mysql\innodb_table_stats.ibd. Cannot open tablespace

The error is stating that your innodb log sequence is higher that that of the actual data files...any chance your data partition is full after your restore? On Fri, Jan 22, 2016 at 3:23 PM, Neil Tompkins wrote: > Hi, > > Hoping someone can help me identify why I

Re: mysql\innodb_table_stats.ibd. Cannot open tablespace

Hi Neil, When you say you delete the current database, do you mean the database files only? Are you doing a complete restore? On Fri, Jan 22, 2016 at 1:23 PM, Neil Tompkins wrote: > Hi, > > Hoping someone can help me identify why I keep having to restore my >

Re: mysql\innodb_table_stats.ibd. Cannot open tablespace

My disk drive has about 3 gb free space. The sequence of events is 1. Create database 2. Restore the data 3. Use the database, SELECT data etc 4. Shut down PC 5. When I restart PC I get this error

Re: mysql\innodb_table_stats.ibd. Cannot open tablespace

Sorry to clarify; I have my database schema, and when the database crashes at the moment, I delete that crashed database, create the new database using the schema, and then restore the data using a import routine I have written in C Sharp, to import data from a CSV file to MySQL tables. The

Re: mysql\innodb_table_stats.ibd. Cannot open tablespace

One point to add, that might be of interest is that the primary key and foreign key for two of related tables is a VARCHAR(255), and my MySQL version is '5.6.12-log' On Fri, Jan 22, 2016 at 8:47 PM, Lisa Smith wrote: > Hi Neil, > > When you say you delete the current database,

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

MySQL Connector/C++ 1.1.7 has been released

Dear MySQL Users, A new GA (general availability) version of MySQL Connector/C++ has been made available: MySQL Connector/C++ 1.1.7 GA. The MySQL Connector/C++ provides a C++ API for connecting client applications to the MySQL Server 5.5 or newer. You can download the production release at:

MySQL Cluster 7.2.23 has been released

Dear MySQL Users, MySQL Cluster is the distributed, shared-nothing variant of MySQL. This storage engine provides: - In-Memory storage - Real-time performance (with optional checkpointing to disk) - Transparent Auto-Sharding - Read & write scalability - Active-Active/Multi-Master

MySQL Cluster 7.4.9 has been released

Dear MySQL Users, MySQL Cluster is the distributed, shared-nothing variant of MySQL. This storage engine provides: - In-memory persistent storage - Real-time performance - Transparent Auto-Sharding - Read & write scalability - Active-Active/Multi-Master geographic replication - 99.999%

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)

MySQL for Excel 1.3.6 has been released

Dear MySQL users, The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.6. This is a maintenance release for 1.3.x. It can be used for production environments. MySQL for Excel is an application plug-in enabling data analysts to very easily access and

Re: commands out of sync, you can't run this command now'

Am 08.01.2016 um 10:14 schrieb Nitin Mehta: Looks like some kind of locking mechanism in the application. Should not be a database issue. no true - this is a native mysql error message! honestly both of you should have used Google

Re: commands out of sync, you can't run this command now'

On 1/8/2016 3:14, Nitin Mehta wrote: Looks like some kind of locking mechanism in the application. Should not be a database issue. On Friday, January 8, 2016 10:47 AM, geetanjali mehra wrote: Hi all, Suddenly I have started getting below error from

commands out of sync, you can't run this command now'

Hi all, Suddenly I have started getting below error from our web site: 'commands out of sync, you can't run this command now' This error is generated sometimes when opening a page ,and immediately after refreshing the page, error gone. Can you please help me to troubleshoot this issue, so that

MySQL for Visual Studio 1.2.6 has been released

Dear MySQL users, The MySQL Windows Experience Team is proud to announce the release of MySQL for Visual Studio 1.2.6. This is a maintenance release for 1.2.x. It can be used for production environments. MySQL for Visual Studio is a product that includes all of the Visual Studio integration

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

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) )// CREATE TRIGGER TEST_TRIGGER BEFORE INSERT ON Test FOR EACH

Re: help with query to count rows while excluding certain rows

On Fri, Jan 1, 2016 at 9:31 PM, Peter Brawley wrote: > On 1/1/2016 19:24, Larry Martell wrote: >> >> On Fri, Jan 1, 2016 at 2:12 PM, Peter Brawley >> wrote: >>> >>> On 12/31/2015 0:51, Larry Martell wrote: I need to count the

Re: help with query to count rows while excluding certain rows

On Fri, Jan 1, 2016 at 2:12 PM, Peter Brawley wrote: > On 12/31/2015 0:51, Larry Martell wrote: >> >> I need to count the number of rows in a table that are grouped by a >> list of columns, but I also need to exclude rows that have more then >> some count when grouped

Re: help with query to count rows while excluding certain rows

On 12/31/2015 0:51, Larry Martell wrote: I need to count the number of rows in a table that are grouped by a list of columns, but I also need to exclude rows that have more then some count when grouped by a different set of columns. Conceptually, this is not hard, but I am having trouble doing

help with query to count rows while excluding certain rows

I need to count the number of rows in a table that are grouped by a list of columns, but I also need to exclude rows that have more then some count when grouped by a different set of columns. Conceptually, this is not hard, but I am having trouble doing this efficiently. My first counting query

Start mysqld 5.7.7 with new disk

Hello I had to replace the datadisk where mysql had its innodb files. But after I had added a new disk I'm not able to initialize mysql files any more: # mysqld --initialize --user=mysql 2015-12-23T13:07:08.216472Z 0 [ERROR] Plugin 'InnoDB' init function returned error.

Re: Start mysqld 5.7.7 with new disk

Am 23.12.2015 um 14:11 schrieb Jørn Dahl-Stamnes: I had to replace the datadisk where mysql had its innodb files. But after I had added a new disk I'm not able to initialize mysql files any more: # mysqld --initialize --user=mysql 2015-12-23T13:07:08.216472Z 0 [ERROR] Plugin 'InnoDB' init

Re: Start mysqld 5.7.7 with new disk

On Wednesday, December 23, 2015, Jørn Dahl-Stamnes wrote: > Hello > > I had to replace the datadisk where mysql had its innodb files. > > But after I had added a new disk I'm not able to initialize mysql files any > more: > > # mysqld --initialize --user=mysql > 2015-12-23T13:07:08.216472Z 0

ANN: DAC for MySQL 3.0.2 is out!

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 allows you to create Delphi/C++Builder applications without BDE, ODBC, ADO and without libmysql.dll.

Announcing release for MySQL 5.5 and 5.6 on CentOS Linux 6 and 7 x86_64 SCL

I am pleased to announce the immediate availability of versions 5.5 and 5.6 of the MySQL on CentOS Linux 6 and 7 x86_64, delivered via a Software Collection (SCL) built by the SCLo Special Interest Group (https://wiki.centos.org/SpecialInterestGroup/SCLo). QuickStart -- You can get

Re: mysql dump global read lock

Artem, You have --add-locks listed which will run LOCK TABLES prior to each table dump. --single-transaction is for InnoDB tables and ensures that they are copied in a consistent state. I hope this helps! On Thu, Dec 17, 2015 at 4:24 PM, Artem Kuchin wrote: > Hello! > > Hereis

ANN: PHP Generator for MySQL 15.12 released

Hi! SQL Maestro Group announces the release of PHP Generator for MySQL 15.12, a powerful GUI frontend for Windows that allows you to generate feature-rich CRUD web applications for your MySQL database. http://www.sqlmaestro.com/products/mysql/phpgenerator/ Online demo:

select contiguous addresses that start on a bit boundary

I need help creating a select that returns 4 records that have contiguous addresses that start on a bit boundary. If 4 do not exist, I need a return of zero records. I would like to do this in one statement and I do not have ownership of this mysql server, so fancy views, temporary tables,

Narrow A First Set Of Records

Hey gang, I need the ability to produce this end result: condition a) All clients who have had at least 2 appointments in the last 24 months condition b) but have NO appointments in the last 6 months I am able to get the clients with >= 2 appointments with this query SELECT c.client_id,

Re: select contiguous addresses that start on a bit boundary

I should have said consecutive addresses, rather than contiguous. I care about a set of consecutive addresses, and there is no guarantee of record order. On 12/17/2015 07:35 AM, John Stile wrote: > I need help creating a select that returns 4 records that have > contiguous addresses that start on

Narrow A First Set Of Records

Hey gang, I need the ability to produce this end result: condition a) All clients who have had at least 2 appointments in the last 24 months condition b) of the set of “condition a” rows, which of those have NO appointments in the last 6 months I am able to get the clients with >= 2

Re: Narrow A First Set Of Records

Hi Don, On 17.12.15 16.14, Don Wieland wrote: Hey gang, I need the ability to produce this end result: condition a) All clients who have had at least 2 appointments in the last 24 months condition b) of the set of “condition a” rows, which of those have NO appointments in the last 6 months

Re: select contiguous addresses that start on a bit boundary

I have a solution. SELECT start_bit_boundary FROM ( SELECT min(address) as start_bit_boundary, status, count(*) as CT FROM MAC_addresses WHERE status = 0 GROUP BY address >> 2 ) AS _INNER WHERE _INNER.CT = 4 ORDER BY start_bit_boundary LIMIT 0,1; It returns the first of 4

mysql dump global read lock

Hello! Hereis my mysqldump command line mysqldump -u root --events --complete-insert --skip-opt --single-transaction --add-drop-table --add-locks --create-options --disable-keys -- extended-insert --quick --set-charset --routines --triggers --hex-blob DB_NAME But i see tons of Waiting for

Upscene releases Database Workbench 5.1.10

Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: Database Workbench 5.1.10 This release adds a few small features and includes Windows Terminal Server support. The full version 5.1.x change log is available here:

MySQL Workbench 6.3.6 GA has been released

Dear MySQL users, The MySQL developer tools team announces 6.3.6 as our GA release for MySQL Workbench 6.3. For the full list of changes in this revision, visit http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html For discussion, join the MySQL Workbench Forums:

Global read lock on delete

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 LOCK_MODE LOCK_DURATION

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

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 MDL_INTENTION_EXCLUSIVE MDL_STATEMENT Global

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: Global read lock on delete

Artem - > |THREAD_ID LOCK_MODE LOCK_DURATION LOCK_TYPE TABLE_SCHEMA > TABLE_NAME > 268871 MDL_INTENTION_EXCLUSIVE MDL_EXPLICITGlobal read lock > 270022 MDL_INTENTION_EXCLUSIVE MDL_STATEMENT Global read lock > 268871 MDL_SHARED_NO_READ_WRITEMDL_EXPLICITTable

Re: Global read lock on delete

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 about that. Can you be a little more

MySQL Community Server 5.7.10 has been released

Dear MySQL users, MySQL Server 5.7.10, a new version of the popular Open Source Database Management System, has been released. MySQL 5.7.10 is recommended for use on production systems. For an overview of what's new in MySQL 5.7, please see

MySQL Cluster Manager 1.4.0 has been released

Hello all, MySQL Cluster Manager 1.4.0, has been released and can be downloaded from the My Oracle Support (MOS) website. It will also be available on Oracle Software Delivery Cloud at http://edelivery.oracle.com with the next monthly update MySQL Cluster Manager is an optional component of the

MySQL Connector/J 5.1.38 has been released

Hello all, MySQL Connector Java 5.1.38, a maintenance release of the production 5.1 branch, has been released. Connector/J is a Type-IV pure-Java JDBC driver for MySQL. It is suitable for use with MySQL server versions 5.5, 5.6, and 5.7. It is also the first release of MySQL Connector/J to

MySQL Community Server 5.6.28 has been released

Dear MySQL users, MySQL Server 5.6.28, a new version of the popular Open Source Database Management System, has been released. MySQL 5.6.28 is recommended for use on production systems. For an overview of what's new in MySQL 5.6, please see

QxOrm 1.4.1 released : new documentation (user guide), and boost::serialization becomes optional

Hello, *QxOrm 1.4.1 just released !* Changes in version QxOrm 1.4.1 : *!!! IMPORTANT NOTE ABOUT THIS VERSION !!!* : it is strongly recommended to read the QxOrm.pri configuration file of this new version (compilation

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

Hi, you can check your file limits with $ ulimit -Hn $ ulimit -Sn The limits are configured in /etc/security/limits.conf If you google for it, you will find, how to set. After changing, new opend shells will have the new parameters. After changing them, your first error message " Changed

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

Am 13.11.2015 um 17:12 schrieb jim Zhou: 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 0 [Warning]

<    3   4   5   6   7   8   9   10   11   12   >