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
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
t users 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
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
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
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 exampl
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 wrote:
> 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
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 unsubscribe
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
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
- Original Message -
> From: "Shafi AHMED"
>
> 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. are allocated once, a
; Andrew Moore
Subject: Re: Reg...My Hung MYSQL instance
- Original Message -
> From: "Suresh Kuna"
>
> 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 n
- Original Message -
> From: "Suresh Kuna"
>
> 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 used to? Some of the m
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 wrote:
> 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
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 wrote:
> It will only do what you let it. If your server ui consuming too much
> memory
> it because you've let it.
&
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" wrote:
> Dear, Today suddenly my database went into hung state due to Out of Memory
> [ Killed process 1330 (mysqld) ].
>
> Please advise me folks.This happ
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 on
Sid Lane
>Cc: MySql
>Subject: Re: best practice: mysql_multi, 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
#x27;re staying 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 th
setup mySQL 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,
m
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 that
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
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
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,
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
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 the
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
On 3/11/09, Thomas Spahni 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
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
you may like to try "mytop"
or
watch -n10 mysql -BNA -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 an
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.mysq
"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.
IX Socket. Depending on the host
> 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 r
gt; 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 interface.
>>
>
>
> Just to chip in on this, an "interface" can obviosly mea
Quoting John Daisley :
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 interface.
Just to chip in on
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
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
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 the
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 a
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
>
t os user, 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 s
--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 ne
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
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 for
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 ha
u 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 wher
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
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
iguring this out. Things I 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 - Genera
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 inst
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 installat
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 ass
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 yo
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?
Th
How do you allow external 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 c
e:
> 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
uration 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 Browser. However, if I try to access the server instance
> from another
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
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 t
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 wou
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 whic
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 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,
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.
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
f
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
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 k
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: http://lists.mysql.co
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&qu
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
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-
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
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
http://
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
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.
http://br.encontros.yahoo.c
- 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 j
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
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.
>
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
ssage-
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
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
R
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"
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
R
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
R
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 ca
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 d
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
inding 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 t
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
r table in your former
Instance
> > 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
>
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, ther
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
