Re: undiscribe

WTF look at the "List-Unsubscribe:" header in every list message and say thanks to fools using DMARC enabled domains on mailing-lists resulting in list footers are removd everywhere no mailing list unsubsribe on planet earth works that way spam every subscriber, you got a welcome message as you

Re: Estimate mysqldump size

Am 28.11.18 um 10:00 schrieb Olivier: > Is there a way that gives an estimate of the size of a mysqldump such a > way that it would always be larger than the real size? keep in mind that a dump has tons of sql statements not existing that way in the data -- MySQL General Mailing List For list

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

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 to database tables, read it, display it, etc., with no problems. The exception is mysql, the MySQL Command-Line Tool. When I execute a SELECT statement to see

Re: mysql_upgrade then mysqld. I feel very ID-10-T PEBKAC today

Am 23.02.2018 um 15:15 schrieb Bob Eby: 2018-02-23T14:02:33.962240Z 0 [ERROR] [MY-010735] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. How do I run mysql_upgrade if the mysqld server won't start? post the *full* errorlog and watch for invaluid config stuff most

Re: monitoring mysql performance

Am 02.11.2017 um 20:09 schrieb Miguel González: I have a VPS Web server (Apache 2.4/PHP 7.x + Varnish 4.1) running with MySQL 5.6. I have 20 Gb of RAM. I serve Wordpress sites mainly all using innodb. So I´m thinking of ways of improving MySQL performance and of course for that, you need

Re: mysqld_multi

Am 01.06.2017 um 00:01 schrieb Matthew Black: I DON'T RUN SYSTEMD, so that's not an option. At all. Why is that so hard to grasp? then just clone the sysvinit script as i have done years ago before syetemd on dozens of machines without ever touch mysqld_multi - why is that so hard to

Re: mysqld_multi

Am 31.05.2017 um 17:48 schrieb Matthew Black: # mysql -uroot -p --socket=/MySQLdb/cba/mysql.sock mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password'; mysql> quit I was simply seeking those three commands, but the reference manual did not provide a real-world example. they don't

Re: mysqld_multi

can't you just stop reply-all so that responses are going back to the list Am 20.05.2017 um 12:01 schrieb Johan De Meersman: He means a database, not a schema. Instance would have been clearer as terminology goes, admittedly, but in a MySQL context the two are identical. database and

Re: mysqld_multi

created one from scratch since 2003 because they are portable between windows/linux/osx and i just rsync the folder or a baisc install and that's it -Original Message- From: Reindl Harald [mailto:h.rei...@thelounge.net] Sent: Friday, May 19, 2017 9:27 AM To: mysql@lists.mysql.com Subject

Re: mysqld_multi

Am 19.05.2017 um 18:19 schrieb Matthew Black: 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 the new

Re: Ssd vs mix of ssd and spinning disk

Am 08.05.2017 um 19:53 schrieb Shain Miley: 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. I am

Re: tcmalloc mysql 5.7.14

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 processes. This has been logged as a bug with mysql dev team however they do not see this

Re: Can not add foreign key constraints

Am 24.04.2017 um 16:18 schrieb David Mehler: I'm trying to add a table to an existing database. I'm wanting it to get one of it's fields from an already existing table. I've done this before in this database. This works: CREATE TABLE `virtual_users` ( `id` int(11) NOT NULL

Re: MySQL server has gone away

temporary error? anything which takes more then 30 seconds needs to be fixed proper and then the timeout would not have been a probkem at all On Monday, April 3, 2017 11:37 PM, Reindl Harald <h.rei...@thelounge.net> wrote: Am 03.04.2017 um 20:41 schrieb Mahmood N: Good news! I c

Re: MySQL server has gone away

Am 03.04.2017 um 20:41 schrieb Mahmood N: Good news! I changed wait_timeout=30 to wait_timeout=600 and now the error disappears... I don't know if long_query_time=1 has effect. well, who did set it that low?

Re: MySQL server has gone away

Am 03.04.2017 um 19:45 schrieb Mahmood N: So I set long_query_time=5 and restarted the service. Test the email page again. Still the logs are empty WTF - you had it set to 5 seconds 2 hours ago i am out here... Am 03.04.2017 um 18:11 schrieb Mahmood N: > The my.conf file contains >

Re: MySQL server has gone away

Am 03.04.2017 um 19:26 schrieb Mahmood N: given that a reasonable server should be able to handle hunredts to thousands of requests per second anything above 1 second is a alert sign Excuse me, do you mean higher values are better? I didn't understand. I said in my posts that when I submit

Re: MySQL server has gone away

Am 03.04.2017 um 18:11 schrieb Mahmood N: The my.conf file contains log_error=/var/log/mysql/error.log slow_query_log=1 slow_query_log_file=/var/log/mysql/error_slow.log max_connections=200 max_user_connections=30 wait_timeout=30 interactive_timeout=50 long_query_time=5

Re: MySQL server has gone away

Am 03.04.2017 um 17:52 schrieb Mahmood N: Dear all, Currently max_allowed_packet is set to 8M. That test email is simply a test email containing some basic information in the message body to assure that the email system works. Thing that can help me is to put mysql in the debug mode in one

Re: multiple domain names mapped to a single IP

Am 02.03.2017 um 16:41 schrieb Bruce Ferrell: There are two ways to approach this: 1.) Turn off name resolution in MySQL and only do the ACL by IP. This is probably best as name resolution can slow the database and cause outright app failure if DNS fails for any reason. 2.) Make absolutely

Re: multiple domain names mapped to a single IP

Am 02.03.2017 um 16:01 schrieb Kaushal Shriyan: Is there any pros and cons to multiple domain names mapped to a single IP work in MySQL client server setup like in case of httpd webserver there is a concept of VHost having multiple domain names mapped to a single IP? For example :-

Re: Changing a field's data in every record

Am 20.02.2017 um 10:35 schrieb Lucio Chiappetti: On Sat, 18 Feb 2017, debt wrote: How does one "grab" the existing data and then change it? Can this be done solely in MySQL I am not sure to understand your question ... you usually manipulate data inside mysql ... but here it seems

Re: Changing a field's data in every record

Am 19.02.2017 um 11:11 schrieb Peter Brawley: On 2/18/2017 15:13, debt wrote: I’ve been asked to post a question here for a friend. Is there a formula to change the format of the data in a single field in every record of a table? She has a "timestamp” in a text field formatted as

Re: rescue Inno tables from an abandoned data directory?

Am 03.12.2016 um 21:23 schrieb Martin Mueller: In my case, I can reproduce Time machine backups of data directories at varying times. At one point I was able to replace the non-working installation with an earlier installation, but then it failed unpredictably. Are the Inno tables on Time

Re: Mysql 5.6, Centos 7 and errno: 24 - Too many open files - Again

Am 01.12.2016 um 08:26 schrieb Götz Reinicke - IT Koordinator: it happend again and I can't fix it, may be someone has a working solution and information on that: surely -> man systemd LimitNOFILE=infinity LimitMEMLOCK=infinity OOMScoreAdjust=-1000 I installed the most recent mysql 5.6

Re: Update to Percona CVE-2016-6662 Vulnerability Communication

Am 16.09.2016 um 00:21 schrieb Johan De Meersman: - Original Message - From: "Reindl Harald" <h.rei...@thelounge.net> Sent: Friday, 16 September, 2016 00:12:26 frankly - mysqld_safe needs to go away and life is beautiful without for years here and yes taht worked for

Re: Update to Percona CVE-2016-6662 Vulnerability Communication

Am 16.09.2016 um 00:05 schrieb Johan De Meersman: This is probably of interest to many of you, and I've not seen it on the list yet. Kenny Gryp's blog about the vulnerability is at https://www.percona.com/blog/2016/09/12/database-affected-cve-2016-6662/ . For those who use it, there's an

Re: MySQL Platform Migration

of asshole first" and i assure you the next time you start the same game as 08/2015 with 70 mails within 3 days which deserved a special folder in my archive you will regret it deeply On Sep 13, 2016, at 06:39, Reindl Harald <h.rei...@thelounge.net> wrote: Am 13.09.2016 um 12:13 sch

Re: MySQL Platform Migration

Am 13.09.2016 um 12:13 schrieb Johan De Meersman: - Original Message - From: "Ryan Coleman" Subject: Re: MySQL Platform Migration Because they want to be belittled by european jackasses online. The thing is, while he has a bit of a rough edge, his technical

Re: MySQL Platform Migration

Am 13.09.2016 um 12:09 schrieb Johan De Meersman: - Original Message - From: "Reindl Harald" <h.rei...@thelounge.net> Subject: Re: MySQL Platform Migration why shouldn't it when the identical software is running? it's just a bunch of files used by mysql Littl

Re: MySQL Platform Migration

BUSINESS Your fight to change mailing lists is one which only you seem to share. what fight? what is the point in producing mail copies? Goodnight. to say it with your words: go away! On Sep 12, 2016, at 7:27 AM, Reindl Harald <h.rei...@thelounge.net> wrote: first: get rid of "re

Re: MySQL Platform Migration

e level of expertise involved. the golden standard for any sysadmin is to know where his datafiles and configuration files are stored and how they work together - independent of the software type Regards, Harrie On 12 September 2016 at 11:03, Reindl Harald <h.rei...@thelounge.net <mai

Re: MySQL Platform Migration

Am 12.09.2016 um 10:48 schrieb Harrie Robins: Ok let's drop this. Simply copying files to migrate a server is not the approach to take (in my humble opinion) And why? When you start with "Get the same release-version of mysql running on the target platform" and dump/load what's the point

Re: MySQL Platform Migration

Am 11.09.2016 um 20:27 schrieb Ryan Coleman: Because they want to be belittled by european jackasses online. if you insist in not get any mail from me just shut up when nobody asked you - mind your own business On Sep 10, 2016, at 11:56 PM, Reindl Harald <h.rei...@thelounge.net>

Re: MySQL Platform Migration

are done - why do people these days not just try out things, look if it works and when it don't asking questions? - Original Message - From: Reindl Harald <h.rei...@thelounge.net> To: mysql@lists.mysql.com Sent: Saturday, September 10, 2016 7:19 PM Subject: Re: MySQL Platform Mig

Re: MySQL Platform Migration

Am 11.09.2016 um 00:26 schrieb Suresh Rajagopal: Is there any documentation for migrating mysql 5.0 database from darwin to Linux what do you need to migrate? shutdown mysqld, copy the datadir to the new machine, stat mysqld with adopted configuration ion the new machine - done P.S:

Re: MacOS Server 5 problem after upgrade

Am 04.09.2016 um 16:17 schrieb Matthias Schmidt: Am 04.09.2016 um 16:29 schrieb Reindl Harald <h.rei...@thelounge.net>: Am 04.09.2016 um 08:40 schrieb Matthias Schmidt: 2016-09-04 15:25:19 85518 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysq

Re: MacOS Server 5 problem after upgrade

Am 04.09.2016 um 08:40 schrieb Matthias Schmidt: 2016-09-04 15:25:19 85518 [ERROR] /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/data/mysqld.local.pid' (Errcode: 102 - Operation not supported on socket) 2016-09-04 15:25:19 85518 [ERROR] Can't start server: can't

Re: parallel installations of mysql

Am 03.07.2016 um 04:47 schrieb Martin Mueller: If port 3306 is taken, how is one supposed to know that 3307 is a good alternative? Why not 3317 or 3703 seriously? when this is your point about bad documentation than you just don't have a point - there is no "good alternive". ist's only a

Re: parallel installations of mysql

Am 03.07.2016 um 00:49 schrieb Martin Mueller: After struggling for several hours with installing an alternate installation of MySQL, I’ve concluded that this may be beyond my feeble powers but also that the official instructions are not very good. They are written for system administrators

Re: corrupt INNO table

Am 02.07.2016 um 16:49 schrieb Martin Mueller: I run MySQL 5.6 on OS 10.11. There is a table that appears to be corrupt: it does not respond to queries, and the command to drop it does not execute. The database seems to be OK in other respects. What can I do to get rid of the table? Would

Re: Precautions to not run out of disk space?

Am 21.06.2016 um 09:41 schrieb Götz Reinicke - IT Koordinator: we recently had a software bug who wrote gigs of data to our database in a loop and finally filled the whole system. O.K. we could serverside use a separate partition/storage for the database directory, but I was wondering is mysql

Re: slave to master

Am 29.04.2016 um 20:49 schrieb william drescher: On 4/28/2016 5:20 PM, Thomas wrote: Hi, I have setup an master slave replication. This works fine. I have running an Apache webserver and some other programms accessing the master. Whats the standard pocedure if master fail? I want to start

Re: slave to master

be a single point of failure. why should max scale care *what* your mysql-client is? anything which can talk to your mysql server will talk the same way to max scale, it acts like a ordinary mysql server from the view of any client On Fri, Apr 29, 2016 at 5:34 PM, Reindl Harald <h.

Re: slave to master

Am 29.04.2016 um 17:27 schrieb Mahmoud Alshinhab: I also like the MariaDB Max scale that Reindl Harald Sent -Thanks- However I don't know if it is possible to use 2 servers of the max scale with a load balancer in front of them or not. I always try to avoid the Single Point of Failure get

Re: slave to master

Am 29.04.2016 um 17:20 schrieb Mahmoud Alshinhab: Master/slave connection selection It’s the application that has to decide to use master or slave connection (the master connection is set by default). Switching the type of connection is done by using JDBC connection.setReadOnly(boolean

Re: slave to master

Am 29.04.2016 um 15:07 schrieb Johan De Meersman: From: "Mahmoud Alshinhab" Subject: Re: slave to master I think you should have a look at MariaDB Connector[1]. It provides Load balancing and failover as Failover occurs when a connection to a primary database

Re: need help from the list admin

Am 01.04.2016 um 21:09 schrieb Lentes, Bernd: - Am 1. Apr 2016 um 17:45 schrieb shawn l.green shawn.l.gr...@oracle.com: You said, "This is done on the master, written in the log and then replicated to the slave, " The INSERT would not appear in the Binary log until after session 1

Re: need help from the list admin

Am 30.03.2016 um 19:26 schrieb Lentes, Bernd: - 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

Re: need help from the list admin

Am 30.03.2016 um 18:56 schrieb Lentes, Bernd: - On Mar 28, 2016, at 9:53 PM, shawn l.green shawn.l.gr...@oracle.com wrote: I read that the converting is not difficult. But has the code of our webapp to be changed ? It's written in php and perl. What i understand is that

Re: need help from the list admin

Am 28.03.2016 um 21:36 schrieb Lentes, Bernd: - 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 behaviors

Re: need help from the list admin

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 behaviors (transactional and non-transactional) within the scope of a single transaction. But if you cannot convert them, using MIXED will be

Re: does anyone else have problems sending mails to this list ?

Am 22.03.2016 um 02:05 schrieb Jan Steinman: please refrain from answering when you have no clue how DNS blacklists are working and what about others are talking Well, excuse me! Someone put on their bossy pants this morning! A simple “That’s not what’s going on here” would have been

Re: does anyone else have problems sending mails to this list ?

Am 20.03.2016 um 20:22 schrieb Reindl Harald: Am 20.03.2016 um 20:16 schrieb Jan Steinman: From: Reindl Harald <h.rei...@thelounge.net> Date: 17 March 2016 at 06:27:22 PDT Am 17.03.2016 um 14:06 schrieb Lentes, Bernd: i still can't send my question to the ML. Our outgoing Mailer has

Re: does anyone else have problems sending mails to this list ?

Am 20.03.2016 um 20:16 schrieb Jan Steinman: From: Reindl Harald <h.rei...@thelounge.net> Date: 17 March 2016 at 06:27:22 PDT Am 17.03.2016 um 14:06 schrieb Lentes, Bernd: i still can't send my question to the ML. Our outgoing Mailer has a new IP which is not listed (http://mxtoolb

Re: need help from the list admin

Am 18.03.2016 um 14:56 schrieb Chris Knipe: Blah blah blah... Delivery to the following recipient failed permanently: mysql@lists.mysql.com Technical details of permanent failure: Your message was rejected by the server for the recipient domain lists.mysql.com by lists-mx.mysql.com.

Re: need help from the list admin

Am 19.03.2016 um 15:23 schrieb Reindl Harald: Am 19.03.2016 um 15:17 schrieb Lentes, Bernd: one further question: if some of my e-mails get through (like this one) and others don't, it does not depend on theh reputation of our domain or mailserver ? Right ? So the reason has

Re: need help from the list admin

Am 19.03.2016 um 15:17 schrieb Lentes, Bernd: one further question: if some of my e-mails get through (like this one) and others don't, it does not depend on theh reputation of our domain or mailserver ? Right ? So the reason has to be that particular e-Mail? both a spamfilter is typically

Re: need help from the list admin

Am 19.03.2016 um 15:08 schrieb Lentes, Bernd: Ok. I tried again: pc53200:~ # nslookup 20.103.107.146.score.senderscore.com. Server: 146.107.8.88 Address:146.107.8.88#53 Non-authoritative answer: Name: 20.103.107.146.score.senderscore.com Address: 127.0.4.62 My result is

Re: need help from the list admin

Am 18.03.2016 um 15:25 schrieb Lentes, Bernd: - Am 18. Mrz 2016 um 14:52 schrieb Johan De Meersman vegiv...@tuxera.be: and yet, both of those messages made it through :-p Stick your domain in http://mxtoolbox.com to see if there's any problems that might be worth solving. If the

Re: does anyone else have problems sending mails to this list ?

Am 17.03.2016 um 14:06 schrieb Lentes, Bernd: i still can't send my question to the ML. Our outgoing Mailer has a new IP which is not listed (http://mxtoolbox.com/SuperTool.aspx?action=blacklist%3a146.107.103.20=toolpage#), our domain is not listed

Re: does mysql alert about all the duplicates?

Am 16.03.2016 um 13:38 schrieb lejeczek: hi everybody just another beginner's question. if I insert into table and there are duplicate primary keys - does mysql alert about all the duplicates or just the first one and then exits/abandon the rest of the insert without any alerts for potential

Re: does anyone else have problems sending mails to this list ?

Am 09.03.2016 um 11:44 schrieb Lentes, Bernd: i tried yesterday several times to send an e-Mail to this list. E-Mail is formatted as plain-text, has no links included and no attachment but is declined as spam. This is what is bounced: : host

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

Am 03.03.2016 um 16:40 schrieb lejeczek: how to backup in a way that this in-database-encryption will be taken advantage of? does any of present backup solutions can do it? many thanks think once again what "transparent encryption" means the most effective backup is anyways running slave

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

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" the is no degree, but or if Onc

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

Am 29.02.2016 um 20:30 schrieb shawn l.green: 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

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

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 fine? If not, would it be easy to re-code php to work with

Re: Mysql devel

Am 23.02.2016 um 13:12 schrieb Larry Martell: On Tue, Feb 23, 2016 at 7:07 AM, Larry Martell <larry.mart...@gmail.com> wrote: On Tue, Feb 23, 2016 at 6:16 AM, Reindl Harald <h.rei...@thelounge.net> wrote: Am 23.02.2016 um 04:47 schrieb Larry Martell: I am trying to install the

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

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

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

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

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

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

rs and set OS disk quota for them, but be prepared for data loss sooner or later 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 adjust my.cnf to co

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

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?

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

Re: When to create a new user?

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 a perl module that will manage

Re: When to create a new user?

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 a perl module that will manage the connections (issue database handles ). As new users sign up for the application should

Re: mysql Digest 12 Aug 2015 13:08:20 -0000 Issue 5317

Am 12.08.2015 um 16:49 schrieb Bob Eby: converting from MyISAM to innodb would certainly pose problems, I guess the main question would be is MyISAM functionality a strict sub-set of innodb? I'm not sure, but maybe someone else here knows better no it is for sure not signature.asc

Re: Changing storage engine in dump file.

Am 12.08.2015 um 15:07 schrieb geetanjali mehra: I am in the process of creating a new slave. On my master, there is a mix of innodb and myisam tables. I want all my tables to be created in innodb on slave. I have planned to change the value of storage engine from innodb to myisam in dump file

Re: innodb log sequence problem

Am 05.08.2015 um 17:06 schrieb Csepregi Árpád: 150805 17:02:31 InnoDB: Page dump in ascii and hex (16384 bytes): hex... 150805 17:02:31 InnoDB: Page checksum 1094951825, prior-to-4.0.14-form checksum 1449969277 InnoDB: stored checksum 1467223489, prior-to-4.0.14-form stored checksum 87759728

Re: password problem

and didn't find any open doors. well, you have a bad mix * missing knowledge * a blackbox with a installer * refusing to read more than the begin of docs On 7/31/15 3:36 AM, Reindl Harald h.rei...@thelounge.net wrote: first: don't reply off-list, a answer on a mailing-list is no invitation

Re: password problem

/resetting-permissions.html#resetting-permissions-generic On 7/31/15 9:12 AM, Reindl Harald h.rei...@thelounge.net wrote: Am 31.07.2015 um 15:40 schrieb shawn l.green: 1. Log on to your system as the Unix user that the MySQL server runs as (for example, mysql). Everything that executes

Re: password problem

Northwestern University -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Thanks and Regards: Nikhil Anand +91 9650024197 -- Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / CISO

Re: password problem

Am 31.07.2015 um 15:40 schrieb shawn l.green: 1. Log on to your system as the Unix user that the MySQL server runs as (for example, mysql). Everything that executes on a Linux/Unix/Mac machine executes in the context of some kind of user account (the system login). By default, mysqld (the

Re: password problem

als root On 7/30/15, 19:22, Reindl Harald h.rei...@thelounge.net wrote: Am 31.07.2015 um 01:41 schrieb Martin Mueller: I have installed mysql 5.1.73 on an old Mac Pro running OS Lion. I cannot run the mysql command because it challenges me for a password. But I did not set any password, either

Re: password problem

Am 31.07.2015 um 01:41 schrieb Martin Mueller: I have installed mysql 5.1.73 on an old Mac Pro running OS Lion. I cannot run the mysql command because it challenges me for a password. But I did not set any password, either for the root, for mysql, or for myself as a user. So the installation

Re: Unsubscribing my sql mailing list

why do you think we could do that for you and what do you think is that link in every mail for? YES i send this to the list hopefully to save a few of this meh i can't handle my mail. To unsubscribe:http://lists.mysql.com/mysql Am 22.07.2015 um 18:08 schrieb Charles Turner: Dear

Re: can't start mariadb with client certs specified

Am 22.07.2015 um 06:39 schrieb Tim Dunphy: Hey guys, I'm trying to setup multi master replication using SSL under MariaDB 10.20. I've been able to specify my client certs on the second node (db2) with no issue and start up the mysql service what about running mysql_upgrade *directly* after

Re: can't start mariadb with client certs specified

Am 22.07.2015 um 16:24 schrieb Tim Dunphy: Hi Reindl, what about running mysql_upgrade *directly* after the major update and *before* touch anything else? That was precisely what happened. In setting up the new database machine, puppet had installed version 5 of mariadb. Before even

Re: can't authenticate ssl user account

Am 21.07.2015 um 05:03 schrieb Tim Dunphy: I see absolutely NO indication as to why the login for the 'slave2' user (that requires SSL) is failing So my questions are 1) how to I bump up the verbosity on the logs so I can get an indication as to why this is failing? 2) what is the best way to

Re: Unable to start mysql after power Failure

Am 04.07.2015 um 06:24 schrieb Jatin Davey: We are trying to High Availability solution for our database. We have our application running on a node-1 and the DB running on the shared storage which is shared across node-1 node-2. Whenever there is a power Failure on node-1 , we start our

Re: Sending a fax

Am 15.06.2015 um 19:24 schrieb Trianon 33: Jim, It's just a fax to email service I would like to test.. and WHY THE FUCK don't you call some buddy instead spam large, public mailing-lists? creep away! signature.asc Description: OpenPGP digital signature

  1   2   3   4   5   6   >