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
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
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
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
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
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
I've long used mysqltuner.pl and have recently heard that it may not be the
best tool for the job. what are others using? What experiences have you had
with mysqltuner.pl
Inquiring minds want to know
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hey Bruce,
Much of the output is inaccurate and the tool is rather dated.
A
On Wed, Apr 11, 2012 at 10:23 PM, Bruce Ferrell bferr...@baywinds.orgwrote:
I've long used mysqltuner.pl and have recently heard that it may not be
the best tool for the job. what are others using? What experiences
; Andrew Moore
Subject: Re: Reg...My Hung MYSQL instance
- Original Message -
From: Suresh Kuna sureshkumar...@gmail.com
Can you paste your error log and configuration file with the total
memory you have on the server.
Hey, someone posting something actually useful. You must be new
- Original Message -
From: Shafi AHMED shafi.ah...@sifycorp.com
Thank you everyone who have responded back...
The issue is fixed now after increasing the max connections param
Glad to hear that, but it seems unlikely, to me.
Certain things, like the query cache, index cache, etc.
Great, thank you sir!
Appreciate your comprehensive reply
Best Rgs,
Shafi AHMED
-Original Message-
From: Johan De Meersman [mailto:vegiv...@tuxera.be]
Sent: Thursday, August 25, 2011 1:30 PM
To: Shafi AHMED
Cc: mysql@lists.mysql.com
Subject: Re: Reg...My Hung MYSQL instance
Hello Shafi,
On 8/25/2011 02:02, Shafi AHMED wrote:
Thank you everyone who have responded back...
The issue is fixed now after increasing the max connections param
I disagree. I believe you only reduced the symptom of the problem. The
real problem was you had too many open connections. The
Dear, Today suddenly my database went into hung state due to Out of Memory
[ Killed process 1330 (mysqld) ].
Please advise me folks.This happens now often
Shafi
Get your world in your inbox!
Mail, widgets, documents, spreadsheets, organizer and much more with your
Sifymail WIYI id!
Log
It will only do what you let it. If your server ui consuming too much memory
it because you've let it.
On Aug 23, 2011 9:22 AM, Shafi AHMED shafi.ah...@sifycorp.com wrote:
Dear, Today suddenly my database went into hung state due to Out of Memory
[ Killed process 1330 (mysqld) ].
Please advise
Kill the Mysql process as of now set the proper buffer parameters as per
the usage. start the mysql instance.
On Tue, Aug 23, 2011 at 2:04 PM, Andrew Moore eroomy...@gmail.com wrote:
It will only do what you let it. If your server ui consuming too much
memory
it because you've let
Hello Shafi,
Can you paste your error log and configuration file with the total memory
you have on the server.
On Tue, Aug 23, 2011 at 2:04 PM, Andrew Moore eroomy...@gmail.com wrote:
It will only do what you let it. If your server ui consuming too much
memory
it because you've let it.
On
- Original Message -
From: Suresh Kuna sureshkumar...@gmail.com
Can you paste your error log and configuration file with the total
memory you have on the server.
Hey, someone posting something actually useful. You must be new here :-D
Ahmed, do you have more connections than you
on the same server,
apparently, so you'll have to decide which instance gets what part of cpu,
memory and other resources, you'll have to provide separate backup for all
instances, et cetera; while leaving things as they are is zero effort.
What is the problem with the current setup
, VMs w/single instance per or doesn't
matter?
Other people have answered with pros and cons of virtualisation, but I would
rather ask another question: why do you feel it necessary to split up the
database?
If it's only used for QC, it's probably not in intensive use. Why would you
go
through
I've always had a single physical server that is the qc mysql database for
all our applications but it's now up to 85 schemas so I want to break it up
along the same lines as production (where there's redundant pools of mysql
servers by application class).
my basic question is whether it's better
i would use virtual machines because port/socket/configuration
after running our whole infrastructure on vmware i can not understand
how i could live without machine-snapshots and auto-failover :-)
on hardware with virtualization support performance is also
not a problem and ESXi is free without
Just know that there is not-a-problem in running multiple instances on the
same host,
then all you have to do is to evaluate the performance factor.
In your case I would not introduce the overhead of the VMs,
but take advantage of this to learn how to manage multiple instances on the
same host
on different ports and go through all that hassle and
configuration. With VM's you can just clone one to setup a new instance,
you have fail-over, backups, they're easy to move to new hardware, they
have console GUIs, intelligent shuffling of resources, maximizing hardware,
minimizing costs (electric
Hi,
Can any body help me how to create new instance at the same mysql databas
server in 5.0.85 community version ?
Thanks
Jeetendra Ranjan
Can any body help me how to create new instance at the same mysql databas
server in 5.0.85 community version ?
You might find useful:
http://code.openark.org/blog/mysql/manually-installing-multiple-mysql-instances-on-linux-howto
At least i used that last time i had to set 2 instances on my
Hi,
MySQL query cache implementation is based on the Query_cache object (ref:
sql_cache.cc). But I cannot find where the instance for the object is
created ... (like new Query_cache qcache ...). Can anybody point me to the
file please?
Regards,
Raja
You might have better luck on the mysql-internals list
-Original Message-
From: Rajarshi Chowdhury [mailto:mailtorajar...@gmail.com]
Sent: Tuesday, July 21, 2009 4:58 AM
To: mysql@lists.mysql.com
Subject: Query_cache instance creation
Hi,
MySQL query cache implementation is based
On Mon, 9 Mar 2009, Sven wrote:
Hi folks
I am searching for a generic command to monitor that MySQL instance is
up and running. I don't have any know-how about the schema of the DB.
kind regards
Sven Aluoor
Hi
What about 'mysqladmin ping' ?
Regards,
Thomas Spahni
--
MySQL General Mailing
On 3/11/09, Thomas Spahni t...@lawbiz.ch wrote:
I am searching for a generic command to monitor that MySQL instance is
up and running. I don't have any know-how about the schema of the DB.
What about 'mysqladmin ping' ?
Hi Thomas
thank you. That was the command I searched.
kind regards
Hi folks
I am searching for a generic command to monitor that MySQL instance is
up and running. I don't have any know-how about the schema of the DB.
kind regards
Sven Aluoor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
you may like to try mytop
or
watch -n10 mysql -BNA databasename -e show full processlist
add user,host,databasename as needed
Sven schrieb:
Hi folks
I am searching for a generic command to monitor that MySQL instance is
up and running. I don't have any know-how about the schema of the DB
with --defaults-file=/home/mysql-instance-x/my.cnf
It works greatly and never had one problem (as long as you also start mysql
client with --defaults-file=/correct/my.cnf)
Question: Why on Certification Study Guide, Chapter 42, Page 576, First
Bullet it states:
Each server must have its own network
, different os user homedir,
different my.cnf (with different port/socket)
and start the server ecluding the possibility to read other than its own
my.cnf with --defaults-file=/home/mysql-instance-x/my.cnf
It works greatly and never had one problem (as long as you also start
mysql
client
port/socket)
and start the server ecluding the possibility to read other than its own
my.cnf with --defaults-file=/home/mysql-instance-x/my.cnf
It works greatly and never had one problem (as long as you also start
mysql
client with --defaults-file=/correct/my.cnf)
Question: Why
Hi Claudio,
I don't think its your English, I agree with you that its not just
confusing it is wrong.
Each server must have its own network interface
At least for my 10 years experience in IT and UNIX I would understand
network interface as physical network interface unless specified as
An interface by definition is a point of interconnection.
Maybe its a bit of a grey area where the interpretation can be different
depending on whether you think in terms of hardware or software.
Its the port which is used to communicate with the MySQL (or indeed any
other) server software so
John,
I don't want to argue too much on this but I'd also like the opinion of the
big heads in MySQL
I think there's no grey area here.
An interface is an interface and can be of any type and supporting any
protocol(TCP/IP on ethernet card, UDP idem. DSL on WAN card, PPP on POTS
modem)
A port is
including becoming mysql dba and dev certified amongst many other
certifications)
I would say in terms of the MySQL server the interface is either a TCP/IP
Port, a Named Pipe, shared memory or a UNIX Socket. Depending on the host
operating system it can use any of those interfaces but each instance
Quoting John Daisley john.dais...@mypostoffice.co.uk:
I would say in terms of the MySQL server the interface is either a TCP/IP
Port, a Named Pipe, shared memory or a UNIX Socket. Depending on the host
operating system it can use any of those interfaces but each instance must
have its own
, shared memory or a UNIX Socket. Depending on the
host
operating system it can use any of those interfaces but each instance
must
have its own interface.
Just to chip in on this, an interface can obviosly mean a lot of
things depending on the context and I accept the above discription
operating system it can use any of those interfaces but each instance must
have its own interface.
I believe you are confusing server hardware and server software. Do you
consider a server to be a physical machine or an application that runs on
a physical machine? Its the same difference. The network
For the purposes of the exam, which I think the original question related
to, I would say you have to accept mysql's interpretation of 'network
interface' as being a port, socket, pipe etc. Thats what it says in the
study guide and the reference manual and thats what they are going to test
you on.
Would you kindly supply the changes you made, for our collective education?
Thanks.
Arthur
On Mon, Apr 28, 2008 at 11:54 AM, Mark-E [EMAIL PROTECTED] wrote:
Hi Ian,
Thanks for the reply. I was specifying the new port of 3307. I actually
got it working over the weekend. Turns out I had to
Hi Arthur,
Sure, no problem!
This actually proved to be rather tricky because the first instance was
installed in /usr/local/mysql. It seems that by default, MySQL looks for things
in this locations so if you deviate from it, you have to be explicit with mysql
and tell it where to look
Hello,
I faced this issues a few years ago and I'd like to give my contributions.
The easy and clean way I've found:
--
-- One installation for each mysql instance
-- On each instance you can have as many databases as you want
-in to the new instance, are you specifying the new
port number to the client? If you don't give it the new port number,
then it will connect to the default port, which is presumably your
4.0.20 instance.
Mark-E wrote:
I have a Solaris box where MySQL 4.0.20 instance is running (to support
Mark,
When you try to log-in to the new instance, are you specifying the new
port number to the client? If you don't give it the new port number,
then it will connect to the default port, which is presumably your
4.0.20 instance.
Mark-E wrote:
I have a Solaris box where MySQL 4.0.20
I have a Solaris box where MySQL 4.0.20 instance is running (to support
Bugzilla 2.22). I have loaded mysql5.0 on the same box (for Bugzilla 3.0.3)
and created a new mysql50 user that I want to use to run this instance with.
I tried to start the instance on another port by running the following
have already tried are listed below:
*Turning off the Anti-virus
*Turning off Windows firewall
Thanks in advance!
-BeasC
--
View this message in context:
http://www.nabble.com/MySQL-Server-Instance-Config-Wizard-tp16497722p16497722.html
Sent from the MySQL - General mailing list archive
I will rerun later today
At 08:04 2008-03-10, you wrote:
That error message is usually when you try to login to MySQL by whatever
means (the Windows install Wizard may be attempting this in the final steps
upon starting up? But it should not be starting up as root...).
Can you complete the
Craig Huffstetler escribió:
Greetings again Andrew,
That error message is usually when you try to login to MySQL by whatever
means (the Windows install Wizard may be attempting this in the final steps
upon starting up? But it should not be starting up as root...).
Can you complete the
Hello
I just tried to install the mysql server and I am getting the
following error messgae for the Apply Security Setting:
The security settings could not be applied.
Error number 1045
Access denied for use '[EMAIL PROTECTED]' (using password:YES)
What does this mean and how do I fix it?
Greetings Andrew,
Make sure you have granted access to your user: (run command line)
mysql GRANT ALL ON databaseName.* TO 'your_mysql_name'@'your_client_host';
Sincerely,
Craig Huffstetler
P.S. - What version of MySQL, what operating system and are you using the
command line (I was assuming
Greetings again Andrew,
That error message is usually when you try to login to MySQL by whatever
means (the Windows install Wizard may be attempting this in the final steps
upon starting up? But it should not be starting up as root...).
Can you complete the installation using the wizard (I am
on a machine running Windows XP. I'm not an
advanced
user so I chose all the default configuration settings when I went
through
the setup wizard for the server instance. The database works fine
and I
can
access it when I'm sitting at the computer through the command line
client
and MySQL Query
computers to access server
instance?
Mysql restricts access outside the server after the installation (on not
all, but several cases) so i suggest to connect to the mysql database as
root and review the host values on the user table, that can give you an
idea of who is allowed and from where
I've installed MySQL5 on a machine running Windows XP. I'm not an advanced
user so I chose all the default configuration settings when I went through
the setup wizard for the server instance. The database works fine and I can
access it when I'm sitting at the computer through the command line
Hi,
Ferindo Middleton wrote:
I've installed MySQL5 on a machine running Windows XP. I'm not an advanced
user so I chose all the default configuration settings when I went through
the setup wizard for the server instance. The database works fine and I can
access it when I'm sitting
wizard for the server instance. The database works fine and I
can
access it when I'm sitting at the computer through the command line
client
and MySQL Query Browser. However, if I try to access the server instance
from another computer on my LAN via MySQL Query Browser, I get a message
saying
I am looking at data from a telephone call centre.
I have a table giving data on calls made including time and date with the
name CallDateTime. Each call has a number, CallId and each customer has a
number CustomerNo. Each row represents a different call.
I would like to create a column
Hi David,
David Scott wrote:
I am looking at data from a telephone call centre.
I have a table giving data on calls made including time and date with
the name CallDateTime. Each call has a number, CallId and each customer
has a number CustomerNo. Each row represents a different call.
I
Hi, I need to write a small middleware program that can capture, inspect
and redirect all queries to an old instance of mysql to a new instance.
Any help or pointers to get started would be greatly appreciated.
thanks,
Chike.
--
MySQL General Mailing List
For list archives: http
Hi,
Chibuike Muoh wrote:
Hi, I need to write a small middleware program that can capture, inspect
and redirect all queries to an old instance of mysql to a new instance.
Any help or pointers to get started would be greatly appreciated.
Perhaps this will help: http://jan.kneschke.de/projects
Hi,
I installed the noinstall package of mysql 5.0.41 on Windows Server 2003 R2
SP2. I manage an instance with mysqlmanager of this package. The my.ini is the
following:
[manager]
pid-file=mysqld37.pid
[mysqld37]
mysqld-path=D:/Programme/MySQL/mysql-5.0.41-win32/bin/mysqld-nt.exe
datadir=D
Thanks to all for so good responce.
Now I will experiment with it and reply earliest.
Thanks
CPK
--
Keep your Environment clean and green.
Dear friends,
thank you for your response.
but the problem is that when I try to install MySQL 5.0 from windows .msi
installer on windows XP with MySQL 5.0 already installed, the
installer does not shows any option regarding new installation. I can
just rapair/remove the installation. Why?
As I
It should be possible to do a manual install from the non-installer
download. Moreover, it should also be possible to run 2 instances
on 2 different ip-adresses on one computer.
It's been a while sincei ran MySQL on Windows, so my memory is
not clear on this, but scan the docs, and your questions
I am fairly newbie at MySQL in general, not to mention
MySQL on Windows which I've never used, but I'll trow
my 2 cents here.
Instead of installing a whole new set of files,
wouldn't that be easier just to start a 2nd instance
of the MySQL server using a different configuration
file? indicating
Is it possible to install more than instances on Linux of MySQL 5.0?
I am using WinXP SP 2 and MySQL 5.0.17.
Thanks
CPK
--
Keep your Environment clean and green.
--
Keep your Environment clean and green.
Is it possible to install more than instances on Linux of MySQL 5.0?
I am using WinXP SP 2 and MySQL 5.0.17.
Thanks
CPK
--
Keep your Environment clean and green.
No matter what I do, it fails at the step where it's supposed to install
and start the 'Windows service with an error 0. Is this a known issue?
It sure would be nice to get more information about the failure from
the wizard.
--
MySQL General Mailing List
For list archives:
When setting up several instances in the instance manager, if you don't want
them all to start at once, but you want to
start instances on demand (like when you have instances of different MySQL
versions) the only way I found to achieve
this goal is is to set the option nonguarded.
Then, when
On a Windows Server (Win2000 or WinXP) that is running a database instance
(or many database). If I run the antivirus from Trend Micro (Trend
ServerProtect) all my database instance service are stopped.
Do you have any idea ? already talk with TrendMicro?
Thx, Stéphane
--
MySQL General
Anthony,
Friday, October 11, 2002, 5:26:39 AM, you wrote:
AWM There is non-root user implementation of MySQL-Pro 4.0.4 linux binary in
AWM this users environment (RH 7.3).
AWM my.cnf has been modified to include individual user, port ,
AWM bind-address and host specifics (and etc) unique to
Victoria Reznichenko wrote:
Anthony,
Friday, October 11, 2002, 5:26:39 AM, you wrote:
AWM There is non-root user implementation of MySQL-Pro 4.0.4 linux binary in
AWM this users environment (RH 7.3).
AWM my.cnf has been modified to include individual user, port ,
AWM bind-address and host
There is non-root user implementation of MySQL-Pro 4.0.4 linux binary in
this users environment (RH 7.3).
my.cnf has been modified to include individual user, port ,
bind-address and host specifics (and etc) unique to that user and is
passed as --defaults-file through mysqld_safe script.
Alexander,
Wednesday, July 17, 2002, 11:32:19 PM, you wrote:
AB When I want to run two servers with different
AB configuration. Can I run in the same machine and two
AB running?
Yes, you can (it's not true for Windows):
http://www.mysql.com/doc/M/u/Multiple_servers.html
When I want to run two servers with different
configuration. Can I run in the same machine and two
running?
Alexander
sql, query
___
Yahoo! Encontros
O lugar certo para encontrar a sua alma gêmea.
different databases) but this approach is _extremely_ tricky to get working
reliably.
About the need of several server instances, you could use another MySQL
for production use (possibly with the normal port, stable table handlers
etc.), meanwhile having another instance for development use, running
as instance
variable in every servlet, so it can save sometime to
open new connection. However, I am not sure if it will
cause multi-thread problem? How and when i can close
the connection.
__
Find, Connect, Date! http
- Original Message -
From: bin cai [EMAIL PROTECTED]
To: mysql list [EMAIL PROTECTED]
Sent: Friday, May 17, 2002 10:59 AM
Subject: set connection as instance variable ( servlet and mysql)
Hi,
My application is about online exam with java servlet
as tool, tomcat 3.2.3 as server
Hi, all mysql team
As we know, use safe_mysqld or mysql.server
we can startup Mysql instance.
But how can i know when all the mysqld daemons
really startup except use command ps?
Thanks in advance.
Robert Li
Computer Associates
Robert,
`mysqladmin ping` will print mysqld is alive if the server is running,
or error message in any other case.
Peter
On Wed, 20 Feb 2002, Li, Robert wrote:
Hi, all mysql team
As we know, use safe_mysqld or mysql.server
we can startup Mysql instance.
But how can i know when all
-
From: Li, Robert [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 18, 2002 9:07 PM
To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Subject:get instance variable
Hi, all MySQL team
Here is another question
Hi, all
As we know, we can backup all dbs in one instance
using mysqldump --alldatabases all_db.sql,
so can we restore all of these dbs from all_db.sql in one time?
Mysql client program mysql can only restore one database
per time---mysql sample_db sample_db.sql.
Thanks in advance.
Best
At 13:13 +1100 2/19/02, Li, Robert wrote:
Hi, all
As we know, we can backup all dbs in one instance
using mysqldump --alldatabases all_db.sql,
so can we restore all of these dbs from all_db.sql in one time?
Mysql client program mysql can only restore one database
per time---mysql sample_db
Hi, all MySQL team
Here is another question.
I want to get individual MySQL instance's variable(like datadir, tmpdir etc)
using C API. Is there any function can do this?
I know that use mysqladmin and use query show variables
can do this.
Thanks and regards
Robert Li
Computer Associates
RD
Hi, all MySQL team
Here is another question.
I want to get individual MySQL instance's variable(like datadir, tmpdir etc)
using C API. Is there any function can do this?
I know that use mysqladmin and use query show variables
can do this.
Thanks and regards
Robert Li
Computer Associates
RD
Hi, all MySQL team
Here is another question.
I want to get individual MySQL instance's variable(like datadir, tmpdir etc)
using C API. Is there any function can do this?
I know that use mysqladmin and use query show variables
can do this.
Thanks and regards
Robert Li
Computer Associates
RD
On Sun, Dec 16, 2001 at 09:49:29AM -0600, Philip Molter wrote:
On Sun, Dec 16, 2001 at 02:00:58AM -0800, Jeremy Zawodny wrote:
: On Mon, Dec 10, 2001 at 01:25:07PM +0800, Ares Liu wrote:
:
: So, could you give me some advice that if it is feasible ? Or show
: me your successful cases of
On Mon, Dec 10, 2001 at 01:25:07PM +0800, Ares Liu wrote:
So, could you give me some advice that if it is feasible ? Or show
me your successful cases of using mySQL which is supporting very
large DB or tables with details ?
How about a table with 260 million rows? We've got one that is
On Sun, Dec 16, 2001 at 02:00:58AM -0800, Jeremy Zawodny wrote:
: On Mon, Dec 10, 2001 at 01:25:07PM +0800, Ares Liu wrote:
:
: So, could you give me some advice that if it is feasible ? Or show
: me your successful cases of using mySQL which is supporting very
: large DB or tables with
Is there any way to bind something other than the hostname to a MySQL
instance?
I'm going to be moving a database from one server to another, and would
like the scripts that reference that data to simply talk to
db.mydomain.com, rather than have to reconfigure things during launch
: binding a domain name to a MySQL instance
Is there any way to bind something other than the hostname to a MySQL
instance?
I'm going to be moving a database from one server to another, and would
like the scripts that reference that data to simply talk to
db.mydomain.com, rather than have to reconfigure
All,
Now I want to design a database which contains more than 10G data to use. I
think the largest table in my db will contains more than 30 million records
and the amount of this kind of table will be up to 7 or 10. In my instance
there won't be so many clients connecting. normally
seconds of querying normal
COLUMNs. I want to know query speed in larger table.
Regards
Ares
- Original Message -
From: [EMAIL PROTECTED]
To: Ares Liu [EMAIL PROTECTED]
Sent: Monday, December 10, 2001 1:28 PM
Subject: Re: How Huge of your mySQL database or table in your former
Instance
Hello helpful list!
For one of our customers we have to store russian and german text in a
database. Is is somehow possible to do this with one server instance or do I
have to split the data to be stored in two databases on two server
instances?
Thanks you very much,
Goeran Zaengerlein
I am planning for a migration from MS-SQL MY-SQL.
Does Mysql support database instance?
How can I configure Mysql to support transaction rollback ?
Regards
Peter Li
This message was sent through MyMail http://www.mymail.com.au
98 matches
Mail list logo