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

Am 13.11.2015 um 17:37 schrieb jim Zhou: I change socket=/tmp/mysql.sock in my.cnf file and I am still having the same error. ls -lha /var/lib/mysql the directory is not empty. those .pem files are created by the service even I deleted them. write a bugreport if they are really created by

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

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 0 [Warning] Changed limits: table_open_cache: 431

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

Am 13.11.2015 um 17:46 schrieb Axel Diehl: what kind of OS do you have? pretty sure Fedora/CentOS7 because "yum" and the package name, if i would be him i would just install mariadb which is the default mysql implementation these days on most linux distributions and hence the packages are

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

Hi, what kind of OS do you have? Regards, Axel -Ursprüngliche Nachricht- Von: jim Zhou [mailto:jim.jz.z...@gmail.com] Gesendet: Freitag, 13. November 2015 17:12 An: mysql@lists.mysql.com Betreff: --initialize specified but the data directory has files in it. Aborting. Hi, I did "yum

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

[root@deweyods1 ~]# cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.6 (Santiago) On Fri, Nov 13, 2015 at 8:56 AM, Reindl Harald wrote: > > > Am 13.11.2015 um 17:46 schrieb Axel Diehl: > >> what kind of OS do you have? >> > > pretty sure Fedora/CentOS7

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

ANN: DAC for MySQL 3.0.0 with RAD Studio 10 Seattle support 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.

ANN: 20% discount on Database Workbench Basic or Pro!

Dear reader, We're offering a 20% Mid Autumn Discount on our database design and development product "Database Workbench", available in Basic and Pro edition. Use coupon code MAD15 while ordering, valid until November the 9th. You can find more information about Database Workbench here:

MySQL for Visual Studio 1.2.5 has been released

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

MySQL for Visual Studio 1.2.5 has been released

Dear MySQL users, MySQL for Visual Studio is a product that includes all of the Visual Studio integration functionality to create and manage MySQL databases when developing .NET applications. This is a maintenance release for 1.2.x. It is feature complete and is suitable for production

Re: Query Summary Help...

You need to GROUP BY those fields NOT in the aggregate function. Like: SELECT f.id,f.name,sum(p.price) FROM fruit f left join purchase p on f.id = p.fruit where p.price is not null group by f.id,f.name; 1, 'Apples', 2 2, 'Grapes', 6.5 4, 'Kiwis', 4 On 2015-10-23 04:15, Don Wieland wrote: Hi

MySQL for Excel 1.3.5 has been released

Dear MySQL users, The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.5. 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

ANN: 20% discount on Database Workbench Basic or Pro!

Dear reader, We're offering a 20% Mid Autumn Discount on our database design and development product "Database Workbench", available in Basic and Pro edition. Use coupon code MAD15 while ordering. You can find more information about Database Workbench here:

MySQL Community Server 5.7.9 (GA) has been released (part 1/2)

Dear MySQL users, MySQL Server 5.7.9 (GA) is a new version of the world's most popular open source database. This is the first official release of MySQL 5.7. [Due to size limitations on forum/email, this announcement had to be split into two parts. This is part 1.] The new features in this

MySQL Community Server 5.7.9 (GA) has been released (part 2/2)

[This is part 2 of the announcement] Bugs Fixed, cont. * Replication: The group replication applier channel does not support DATABASE as the slave_parallel_type; when group replication is started, this is checked for explicitly, and handled correctly. However, it

Re: Query Help...

On 10/22/2015 11:48 AM, Don Wieland wrote: On Oct 20, 2015, at 1:24 PM, shawn l.green 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 results.

Re: Query Summary Help...

I'm not at a terminal but have you tried grouping by p.pk_ProductID instead of i.fk...? It is the actual value you are selecting as well as being on the primary table in the query. On Thu, Oct 22, 2015, 5:18 PM Don Wieland wrote: > Hi gang, > > I have a query: > > SELECT >

Re: Query Summary Help...

> On Oct 22, 2015, at 2:41 PM, Michael Dykman wrote: > > I'm not at a terminal but have you tried grouping by p.pk_ProductID instead > of i.fk...? It is the actual value you are selecting as well as being on > the primary table in the query. Yeah I tried that - actually the

Query Summary Help...

Hi gang, I have a query: SELECT p.pk_ProductID, p.Description, i.Quantity FROM invoice_invoicelines_Product p JOIN invoice_InvoiceLines i ON p.pk_ProductID = i.fk_ProductID AND i.fk_InvoiceID IN (1,2,3) WHERE p.pk_ProductID IN (1,2,3); It produces a list like the following:

Re: Query Summary Help...

One more guess: Try explicitly aliasing the fields of interest and using those aliases exclusively throughout the rest of the expression. SELECT p.pk_ProductID as pid, p.Description as dsc, SUM(i.Quantity) as totl FROM invoice_invoicelines_Product p JOIN invoice_InvoiceLines i ON pid =

MySQL Workbench 6.3.5 GA has been released

Dear MySQL users, The MySQL developer tools team announces 6.3.5 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:

Re: Query Help...

> On Oct 20, 2015, at 1:24 PM, shawn l.green 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 results. (sometimes it is a good idea to look at the raw,

MySQL Enterprise Backup 4.0.0 has been released

Dear MySQL users, MySQL Enterprise Backup v4.0.0, a new version of the online MySQL backup tool, is now available for download from the My Oracle Support (MOS) website as our latest GA release. This release will be available on eDelivery (OSDC) after the next upload cycle. MySQL Enterprise

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

- Original Message - > From: "Shawn Green" > Subject: Re: Query optimizer-miss with unqualified expressions, bug or > feature? > > On a more serious note, indexes with limited cardinality are less useful > than those with excellent cardinality. Cardinality is

Re: Query Help...

On 2015-10-20 12: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

Query Help...

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 ht.orphan_id = o.orphan_id LEFT JOIN

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

MySQL Connector/NET 6.9.8 has been released

Dear MySQL users, MySQL Connector/Net 6.9.8 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 MySQL server versions 5.5-5.7. It is now available in source and binary form from

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

I have noticed that an unqualified boolean expression cannot be optimized by MySQL to use an index in 5.6.24. For example: CREATE TABLE t ( i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, a BOOLEAN NOT NULL, KEY a (a) ) ENGINE=InnoDB; This will hit key 'a': SELECT * FROM t WHERE a = TRUE;

Re: a

You’re the one in grade school that always reminded us the teacher might be coming back soon and we should behave, right? > On Oct 18, 2015, at 4:40 PM, Reindl Harald wrote: > > what about stop that bullshit or at least purge the list after press > reply-all? > > Am

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

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 might make a significant result to something? Ben. On 2015-10-19 14:19, Roy Lyseng

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

Hi Ben, On 19.10.15 15.10, Ben Clewett wrote: I have noticed that an unqualified boolean expression cannot be optimized by MySQL to use an index in 5.6.24. For example: CREATE TABLE t ( i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, a BOOLEAN NOT NULL, KEY a (a) ) ENGINE=InnoDB; This

Re: a

No, he's the one who already receives a ton of email and could do without "conversations" like this. I'm also in that boat. sent from my mobile On Oct 19, 2015 7:41 PM, "Ryan Coleman" wrote: > You’re the one in grade school that always reminded us the teacher might > be

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

Hi Shawn, On 19.10.15 22.33, shawn l.green wrote: 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

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: Query optimizer-miss with unqualified expressions, bug or feature?

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 might make a significant result to

MySQL Cluster 7.4.8 has been released

Dear MySQL Users, MySQL Cluster 7.4.8 (General Availability) is a new release for MySQL Cluster 7.4. 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) -

MySQL Cluster 7.2.22 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

Re: a

e Sent from my iPhone > On Oct 18, 2015, at 4:12 PM, Daevid Vincent wrote: > > d > >> -Original Message- >> From: ryan.esca...@gmail.com [mailto:ryan.esca...@gmail.com] On Behalf >> Of Ryan Escarez >> Sent: Friday, October 16, 2015 2:47 AM >> To: Ryan Coleman >> Cc:

RE: a

d > -Original Message- > From: ryan.esca...@gmail.com [mailto:ryan.esca...@gmail.com] On Behalf > Of Ryan Escarez > Sent: Friday, October 16, 2015 2:47 AM > To: Ryan Coleman > Cc: Dennis Ruiz; mysql-le...@lists.mysql.com > Subject: Re: a > > c > > On Fri, Oct 16, 2015 at 3:01 PM, Ryan

Re: a

what about stop that bullshit or at least purge the list after press reply-all? Am 18.10.2015 um 22:52 schrieb bluethu...@gmail.com: e Sent from my iPhone On Oct 18, 2015, at 4:12 PM, Daevid Vincent wrote: d -Original Message- From: ryan.esca...@gmail.com

MySQL Cluster 7.4.8 has been released

Dear MySQL Users, MySQL Cluster 7.4.8 (Milestone Release) is a public milestone release for MySQL Cluster 7.4. 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 space required for taking backup

Hi All I use mysqldump to take the backup of the entire DB. I want to know if there is way to find out how much disk space would mysqldump require to take the backup of the entire DB in .sql file. Currently what we are doing is to check the size of the /var/lib/mysql/data directory and

Re: a

b > On Oct 15, 2015, at 10:07 PM, Dennis Ruiz wrote: > > a > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql > -- MySQL General Mailing List For list archives:

Re: a

c On Fri, Oct 16, 2015 at 3:01 PM, Ryan Coleman wrote: > b > > > On Oct 15, 2015, at 10:07 PM, Dennis Ruiz wrote: > > > > a > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe:

Re: Where is mysql-workbench SCM?

Found it (after some days of searching): https://code.launchpad.net/ubuntu/+source/mysql-workbench must be the official repository according to https://dev.mysql.com/doc/refman/5.7/en/installing-development-tree.html. -Kalle Am 15.10.2015 um 22:11 schrieb Karl-Philipp Richter: > Hi, > The only

a

a -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

compile problem with newest version of mysql-server

Hi all, Recently, I got the newest version of mysql-server from the github, Bug I got some compile problem as follows: cmake -DCMAKE_INSTALL_PREFIX=/u04/my3306 \ -DMYSQL_DATADIR=/u04/my3306/data -DMYSQL_USER=mysql \ -DSYSCONFDIR=/etc -DWITH_MYISAM_STORAGE_ENGINE=1 \

MySQL Connector/J 5.1.37 has been released

Hello all, MySQL Connector Java 5.1.37, 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

Where is mysql-workbench SCM?

Hi, The only list of mysql-related SCM repositories I found was https://github.com/mysql which didn't contain a repository for `mysql-workbench`. I only found the source tarball at http://dev.mysql.com/downloads/workbench/. The development section at http://dev.mysql.com/downloads/workbench/

Re: When to create a new database

- Original Message - > From: "Ron Piggott" > Subject: Re: When to create a new database > > I would lean towards keeping it all together because of the speed > decrease between connecting to different databases. Heh, that consideration is a matter of

Re: When to create a new database

- Original Message - > From: "Reindl Harald" > Subject: Re: When to create a new database > > it makes zero sense since you can use different users for the same > database down to table and even column permissions No, it does make some sense in the case where

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

When to create a new database

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 database called "library" since they are used for

Re: When to create a new database

I would lean towards keeping it all together because of the speed decrease between connecting to different databases. What I would tend to do is put some type of prefix that would keep the sets of tables together --- like lib_sports lib_rules lib_statistical lib_definitions data_players

Re: When to create a new database

Am 10.10.2015 um 16:28 schrieb Richard Reina: 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: When to create a new database

When I read the OP I was thinking: This is one for Reindl. And here we go. When dealing with data of this specific kind, you most definitely would want a date reference. A very small computer will be able to handle mane years of all kinds of weird sports statistics. You need to define the

Upscene releases Database Workbench 5.1.6

Upscene releases Database Workbench 5.1.6 Upscene Productions is proud to announce a new release of the popular multi-DBMS development tool: “ Database Workbench 5.1.6 " This version is the next big release after version 5 and includes new features, enhancements and fixes. The full version

Re: How to get auto Increment ID of INSERT?

LAST_INSERT_ID() returns the latest ID for the current connection. As long as you yourself can guarantee that no other queries are executed using that connection, you're fine. If another record others is inserted using another connection, that connection will return a different

How to get auto Increment ID of INSERT?

If I insert a record into a table with an auto increment ID how can I get that records ID value? I have read about SELECT LAST_INSERT_ID() statement, however, do not two statements introduce the risk that another insert may occur in the interum? Is there a full proof way of getting the ID of the

Mysql 5.5 Dead Locks

Hi, I'm receiving MySQL 5.5 deadlocks. I enabled the innodb lock monitor using this command: CREATE TABLE innodb_lock_monitor(a int) ENGINE=INNODB; I got the following output: LATEST DETECTED DEADLOCK 151007 13:58:36 *** (1) TRANSACTION:

MySQL Community Server 5.6.27 has been released

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

Re: Relational query question

It better to LEFT join rather then NOT IN On Wed, Sep 30, 2015 at 6:00 PM, Mogens Melander wrote: > Maybe not the most optimal, but (probably) the most simple: > > SELECT * FROM fruit > where id not in (select fruit from purchase > where customer=1); > > 1, 'Apples' >

Re: Relational query question

Maybe not the most optimal, but (probably) the most simple: SELECT * FROM fruit where id not in (select fruit from purchase where customer=1); 1, 'Apples' 3, 'Oranges' On 2015-09-30 00:01, Richard Reina wrote: If I have three simple tables: mysql> select * from customer; +++ | ID

Relational query question

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> select * from fruit; ++-+ | ID | NAME| ++-+ | 1 | Apples | |

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: Relational query question

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> select * from fruit; ++-+ | ID |

MySQL Connector/Python 2.1.3 GA has been released

Dear MySQL users, MySQL Connector/Python 2.1.3 GA is the first GA version of 2.1 release series of the pure Python database driver for MySQL. It can be used for production environments. MySQL Connector/Python version 2.1.3 GA is compatible with MySQL Server versions 5.5 and greater. Python 2.6

Re: Trouble with LEFT JOIN

Peter, Thank you very much for your reply. Three weeks later I am realizing that the 'NOT IN' solution I had above does not work after all. Accordingly, I went back and looked at your solution and it is close but it only gives NULL results I am looking for something that excludes challenges that

RE: Trouble with LEFT JOIN

Hi There, If I interpreted what you are trying to do is to return all the rows from Challenge and reference Patrocinio excluding those rows in Patrocinio where PTRN_ID is 1? Not sure if the below is possible in MySQL but I've used this in other places when doing a left join and needing to

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: ENUM() vs TINYINT

> From: Richard Reina > > 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

ENUM() vs TINYINT

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 primarily be used in written descriptions. Is

Re: ENUM() vs TINYINT

I'm sure your enum is a fine option, but 0,1,2,3,4 would do the same thing. And you could add a comment to the table to describe it if desired. On Mon, Sep 21, 2015 at 8:03 AM, Richard Reina wrote: > I have a column name quarter which I need to have 5 possible inputs; 1,

ANN: DAC for MySQL 3.0.0-beta with RAD Studio 10 Seattle and mobile platforms support 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.

want to get newest mysql info

I want to get newest mysql info, thank you.

Re: want to get newest mysql info

hmm... i thought google made a whole search engine for this specific reason, maybe there is a bug in their code! https://www.google.ca/webhp?sourceid=chrome-instant=1=2=UTF-8#q=mysql+latest+version+information On Fri, Sep 11, 2015 at 5:22 AM, 王滨 wrote: > I want to get

mysql instance disk quota

Hello, We have some instances running in a hardware server, each instance has different port. For quota limits, we can adjust my.cnf to control each instance's memory usage, also can use cgroups to set CPU quota. But what's the general solution to setup the disk quota? For example, I want

Re: mysql instance disk quota

How to set OS disk quota? On 2015/9/6 17:52, Reindl Harald wrote: set OS disk quota for them -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: mysql instance disk quota

Am 06.09.2015 um 11:08 schrieb Ken Peng: We have some instances running in a hardware server, each instance has different port. For quota limits, we can adjust my.cnf to control each instance's memory usage, also can use cgroups to set CPU quota. But what's the general solution to setup the

Re: mysql instance disk quota

Hi, If disk quota is reached, an error can be threw out. we can accept this policy. Thanks. On 2015/9/6 17:28, Reindl Harald wrote: Am 06.09.2015 um 11:08 schrieb Ken Peng: We have some instances running in a hardware server, each instance has different port. For quota limits, we can

Re: mysql instance disk quota

Am 06.09.2015 um 11:37 schrieb Ken Peng: If disk quota is reached, an error can be threw out. we can accept this policy. Thanks. and damage will happen - jesus christ the worst thing for a database is "disk full", if you don't care just start the mysql instances as different users and set

Re: mysql instance disk quota

Am 06.09.2015 um 12:01 schrieb Ken Peng: How to set OS disk quota? that's hardly a mysql question http://lmgtfy.com/?q=linux+disk+quota On 2015/9/6 17:52, Reindl Harald wrote: set OS disk quota for them signature.asc Description: OpenPGP digital signature

Trouble with LEFT JOIN

I have the following two tables; mysql> select * from challenge; +++-++--+-+--+ | ID | PLR_ID | ACC_TYPE_ID | season | year | CHAR_ID | +++-++--+-+--+ | 1 | 1 |

Re: Trouble with LEFT JOIN

On 2015-09-04 9:40 AM, Richard Reina wrote: I have the following two tables; mysql> select * from challenge; +++-++--+-+--+ | ID | PLR_ID | ACC_TYPE_ID | season | year | CHAR_ID |

Re: Trouble with LEFT JOIN

2015-09-04 11:18 GMT-05:00 Peter Brawley : > On 2015-09-04 9:40 AM, Richard Reina wrote: > >> I have the following two tables; >> >> mysql> select * from challenge; >> +++-++--+-+--+ >> | ID | PLR_ID |

Re: Trouble with LEFT JOIN

On 2015-09-04 11:39 AM, Richard Reina wrote: 2015-09-04 11:18 GMT-05:00 Peter Brawley >: On 2015-09-04 9:40 AM, Richard Reina wrote: I have the following two tables; mysql> select * from challenge;

Re: Free load balancing and sharding

Am 02.09.2015 um 09:55 schrieb S.Mohammad Emami Razavi: I want to cluster MySQL to several servers and have no idea to start. Some questions have stuck to my mind such as How to balance connections and How to make mesh of shards and ... Can you show me a way to do these tasks correctly?

Free load balancing and sharding

I want to cluster MySQL to several servers and have no idea to start. Some questions have stuck to my mind such as How to balance connections and How to make mesh of shards and ... Can you show me a way to do these tasks correctly? Many Thanks,

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

MySQL Utilities 1.6.2 Beta has been released

Dear MySQL users, This is the BETA release for Utilities 1.6. MySQL Utilities version 1.6.2 is compatible with MySQL Server versions 5.5 and greater. Python v2.6 and v2.7 are supported. MySQL Utilities v1.6.2 BETA is available for download from http://dev.mysql.com/downloads/tools/utilities/ A

Mysql-Proxy Return prior to Execution

Hi Everyone, Does anyone by chance have a working example of mysql-proxy lua script that can: - First return OK to a client - Then actually execute the query on server, ignoring the results. Thanks in advance! -- Stefan Certic *Chief Technology Officer* ste...@cs-networks.net

Re: Mysql-Proxy Return prior to Execution

Hi Martin, Application benchmarking purposes - i don't want any latency for updates to complete. Still, data is needed. But i don't want application nor server to handle the logic wether sql went fine or not. The idea is: Fire an update / insert, return ok to application, execute query - while

Re: Mysql-Proxy Return prior to Execution

Managed to solve, just in case anyone else needs the same: function read_query( packet ) if string.byte(packet) == proxy.COM_QUERY then condition. if (condition) then print(replaced with .. query ) proxy.queries:append(1, string.char(proxy.COM_QUERY)

Need a little admin help

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 the SQL admin, I used the following commands to set up the

Re: moving inno tables

From: Martin Mueller martinmuel...@northwestern.edu I moved the data directory of a MySQL installation from one computer to another. This works for MyISAM tables. Unfortunately I inadvertently created some INNO tables, and it doesn't seem to work. Oh dear. Hope you have a backup. I fought

Re: When to create a new user?

From: Richard Reina gatorre...@gmail.com I am writing a web application... As new users sign up for the application should each get their own MySQL username and password or is okay to execute their queries with the same (one generic) MySQL username and password? As others have said, it

Re: moving inno tables

Am 20.08.2015 um 23:06 schrieb Martin Mueller: I moved the data directory of a MySQL installation from one computer to another. This works for MyISAM tables. Unfortunately I inadvertently created some INNO tables, and it doesn't seem to work. The show tables command accurately lists the

moving inno tables

I moved the data directory of a MySQL installation from one computer to another. This works for MyISAM tables. Unfortunately I inadvertently created some INNO tables, and it doesn't seem to work. The show tables command accurately lists the following the tables from a longer list pospairs

Re: When to create a new user?

On 8/19/2015 9:24 AM, Reindl Harald wrote: Am 19.08.2015 um 15:18 schrieb Jim: On 8/19/2015 8:40 AM, Reindl Harald wrote: Am 19.08.2015 um 14:29 schrieb Richard Reina: I am writing a web application in perl that will create, edit, update and delete data from a MySQL database. I have written

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