2018/09/28 07:48 ... Machiel Richards:
During the times when it experiences issues, I found that there is always about
4-5 processes on mysql that gets stuck on "closing table" state and once the
software (opensips) is restarted due to a sigfault, then these queries are killed as well.
indian spammer
please take me off your list
*Warm Regards*
__
Verzicht und Vertraulichkeitanmerkung
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterl
use Google :)
On Wed, Aug 11, 2010 at 10:02 PM, PRATIKSHA JAISWAL <
pratikshadjayswa...@gmail.com> wrote:
> Hi Prabhat,
>
> Thanks a ton for sharing your blogs with us.
>
> I am learning mysql database. I am very good at PostgreSQL.
>
> Do you have any other material where in i can go for Mysql C
check this,
http://adminlinux.blogspot.com/2009/12/mysql-tips-calculate-database-and-table.html
Thx
On Wed, Aug 11, 2010 at 5:23 PM, PRATIKSHA JAISWAL <
pratikshadjayswa...@gmail.com> wrote:
> Hi,
>
> Thanks all for your help.
>
> >>
> ---Database & Table wise Size in MB---
> SELECT TABLE_SCHE
Hi,
Thanks all for your help.
>>
---Database & Table wise Size in MB---
SELECT TABLE_SCHEMA AS 'Database', TABLE_NAME AS 'Table',
CONCAT(ROUND(((DATA_LENGTH + INDEX_LENGTH - DATA_FREE) / 1024 / 1024),2),"
Mb") AS Size FROM INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA = "dbname";
>>---Database &
Hello Pratiksha,
To get the uptime of the MYSQL instance :-
mysql>\s
as given above just give the above command " \s "
For Total number of users connected to server :-
mysql>show global status like '%user%';
---Database & Table wise Size in MB---
SELECT TABLE_SCHEMA AS 'Database', TABLE_NAME
For most of your questions, use:
SHOW GLOBAL STATUS;
SHOW GLOBAL VARIABLES;
(7) Database performance statistics queries
(8) Top 5 queries taking more time for executions.
(9) Engine information.
For these, you need to enable the slow query log, gather queries over a given
interval of time, the
Hi Green & Eugene,
Thanks a lot.
On Fri, 2006-03-10 at 09:57 -0500, [EMAIL PROTECTED] wrote:
> Косов Евгений <[EMAIL PROTECTED]> wrote on 03/10/2006 07:53:37 AM:
>
> > Hm... It seems to me In MySQL there's no such thing as "database owner".
>
> > Or am I missing something?
> >
> > Mohammed A
Косов Евгений <[EMAIL PROTECTED]> wrote on 03/10/2006 07:53:37 AM:
> Hm... It seems to me In MySQL there's no such thing as "database owner".
> Or am I missing something?
>
> Mohammed Abdul Azeem пишет:
> > Hi,
> >
> > How to check for the database owner for a particular database ? The
way
>
Hm... It seems to me In MySQL there's no such thing as "database owner".
Or am I missing something?
Mohammed Abdul Azeem пишет:
Hi,
How to check for the database owner for a particular database ? The way
"show procedure status" command lists the "definer" column, Is there a
command that shows
You should be asking the snort people whether it works with mysql version 4.
Alternatively you should provide more information if you are getting
errors from mysql.
[EMAIL PROTECTED] wrote:
Could you let me know if
mysql-standard-4.1.13-sun-solaris2.9-sparc works with snort-2.4.0.
I was not
Hi,
thank you very much for your reply.
Now I answer you about your additional questions:
Now the daemon is installed on a machine different than DB Server, so I
use DBServer NIC IP Address for connect to it from the daemon (So I don't
use Unix Sockets).
But, looking at the Network Bandwidth, th
Alfredo,
I have just a few additional questions that you did not already answer in
your very well-formed post. I normally wouldn't worry about ANY of these
issues but you seem to be exploring the envelope of performance on your
system and every little bit counts:
Which communication path are you
On Fri, Jan 03, 2003 at 11:10:38AM -0600, Dana Diederich wrote:
> Yup, MySQL works quite well as a lock server; we've been using it as such
> for years.
Yeah, do we.
> I would suggest looking at the get_lock() function specifically. It's
> designed to do exactly what you're looking for, and it w
Yup, MySQL works quite well as a lock server; we've been using it as such
for years.
I would suggest looking at the get_lock() function specifically. It's
designed to do exactly what you're looking for, and it won't require
knowledge of any tables or rows.
Cheers.
-Dana
> -Original Message-
Marco,
Thursday, November 28, 2002, 3:36:22 PM, you wrote:
MAS> One of my friend, with MySQL v. 3.22.32 and with this commands :
MAS> CREATE TABLE phpgw_chat_channel (con int(11) auto_increment, name
MAS> varchar(10) NOT NULL, title char(50) NOT NULL, UNIQUE(con))
MAS> have this error:
MAS> MyS
* Marco Andriolo-Stagno
> One of my friend, with MySQL v. 3.22.32 and with this commands :
>
> CREATE TABLE phpgw_chat_channel (con int(11) auto_increment, name
> varchar(10) NOT NULL, title char(50) NOT NULL, UNIQUE(con))
>
> have this error:
>
> MySQL complains:
> Column 'con' is used with UN
- Original Message -
From: "K-Tech S.r.l." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 15, 2002 3:33 AM
Subject: Info about XA support
> I'm trying to configure a XA datasource on Bea WebLogic 6.1, i'm using the
Connector/J.
> If i use two different database in an
> When you say "bystander", are you referring to yourself of me?
Poor grammar, my bad. I am the bystander.
> Indeed Microsoft, Lotus, Word Perfect, Borland, Oracle and every other major
> software manufacturer in the world has missed deadlines, stuff happens.
So we have a software company that
On Wed, Aug 28, 2002 at 01:02:11PM -0400, Will French wrote:
> >> So they gave you all the details they could.
>
> Did they? That was my whole argument. Over the past 6 months I have read
> no fewer than 10 responses from the team which have, in effect, said "we
> don't know, quit bugging us."
On Tue, Aug 27, 2002 at 10:51:09PM -0400, Will French wrote:
>
> Obviously you don't agree with me and that is something I readily
> accept. I do have difficulty with the fact that you clearly spent
> more time typing your response than considering my points, which
> were intended to be construct
Hello.
On Wed 2002-08-28 at 17:16:59 -0400, [EMAIL PROTECTED] wrote:
> >Do you (all) realize you can only complain about this (falling so far
> >from their prediction), because they happened to give out some
> >estimate in the first place?
> >
> >Sounds only reasonable to me to try to avoid the
sql query
Benjamin Pflugmann wrote:
>Do you (all) realize you can only complain about this (falling so far
>from their prediction), because they happened to give out some
>estimate in the first place?
>
>Sounds only reasonable to me to try to avoid the same situation by not
>giving out estimatio
Hello.
On Wed 2002-08-28 at 09:19:46 -0500, [EMAIL PROTECTED] wrote:
[...]
> serious. It becomes harmful to MySQL in general when a release that was
> once predicted in 2001, becomes no where in sight in late 2002.
Do you (all) realize you can only complain about this (falling so far
from their
I wrote >> Ironically, the fact that I pay no license fees to MySQL AB is
based upon...
Dean Ellis wrote >> Ahhh, I see. So, you are _completely irrelevant_.
My relevance stems from the fact that I am a very good prospect to a company
that has a stated interest in growing their community of sa
on their website to keeping everyone up
to date about these same details and update it a couple times a month? This
would seem to me to be more effecient for both them and us.
Thanks again for your thoughtful response.
Will
-Original Message-
From: Joel Rees [mailto:[EMAIL PROTECTED]]
Se
ss to Beta and Alpha code.
rm wrote:
>
>>From: Joel Rees <[EMAIL PROTECTED]>
>>To: Will French <[EMAIL PROTECTED]>
>>Cc: [EMAIL PROTECTED]
>>Subject: Re: Info on 4.0.x release date
>>Date: 28 Aug 2002 14:41:51 +0900
>>
>>I know I'm n
> From: Joel Rees <[EMAIL PROTECTED]>
> To: Will French <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: Re: Info on 4.0.x release date
> Date: 28 Aug 2002 14:41:51 +0900
>
> I know I'm not really involved here, but I would like to suggest a few
>
ons would give everyone the
warm-fuzzies. Is there a specific Web page or email you can point us to?
Looking forward to an answer from MySQL AB,
John
-Original Message-
From: Dean Ellis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 2:15 AM
To: [EMAIL PROTECTED]
Subject: R
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: Dean Ellis <[EMAIL PROTEC
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: Dean Ellis <[EMAIL PROTECTED]>
===
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 27 August 2002 09:51 pm, Will French
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: Joel Rees <[EMAIL PROTECTED]>
===
Subject: Re: Info on 4.0.x release date
From: Dean Ellis <[EMAIL PROTECTED]>
===
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 27 August 2002 09:51 pm, Will French wrote:
> accepting this is part of growing up. And while I applaud the honesty =
of
> saying "we
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 27 August 2002 09:51 pm, Will French wrote:
> accepting this is part of growing up. And while I applaud the honesty of
> saying "we won't declare it stable until it is stable," surely you can see
> your way clear that if you were explaini
Subject: Re: Info on 4.0.x release date
From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com))
===
Subject: Re: Info on 4.0.x release date
From: Joel Rees <[EMAIL PROTECTED]>
===
I know I'm not really involved here, but I would like to suggest a few
things.
> Obviously you do
Subject: Re: Info on 4.0.x release date
From: Joel Rees <[EMAIL PROTECTED]>
===
I know I'm not really involved here, but I would like to suggest a few
things.
> Obviously you don't agree with me and that is something I readily accept. I
> do have difficulty with the fact
I know I'm not really involved here, but I would like to suggest a few
things.
> Obviously you don't agree with me and that is something I readily accept. I
> do have difficulty with the fact that you clearly spent more time typing
> your response than considering my points, which were intended
Obviously you don't agree with me and that is something I readily accept. I
do have difficulty with the fact that you clearly spent more time typing
your response than considering my points, which were intended to be
constructive.
>> You got the truth. Would you prefer someone lie to you about
reports.
Regards,
Heikki
- Original Message -
From: "Richard Morton" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, August 28, 2002 1:58 AM
Subject: re: Info on 4.0.x release date
> Hi Will,
>
> As far as I have heard (from MySQL) is
Hi Will,
As far as I have heard (from MySQL) is that MySQL 4.0.3 is being made ready for Beta
as we speak and is likely to be released in the next month. V4.1 will most likely be
released Early Sept in Src form and in Binaries two months later.
4.0.x branch will be allowed to stabalise from th
On Tue, Aug 27, 2002 at 05:45:07PM -0400, Will French wrote:
> When will 4.0.x finally be released to beta?
>
> The facts as I understand them:
> - 4.0 went alpha in Nov or Dec of '01
> - At the time, Monty and his gang projected stabilization by Jan or Feb
> - More than 6 months have passed sinc
Peter said:
---
hi there ...
can some one point in the right direction .. other than the mysql manul for
mroe information on the INSERT SELECT statement & whether or not it can
handle date inserted from a form on a web page...
---
*Any* database can ha
[snip]
can some one point in the right direction .. other than the mysql manul for
mroe information on the INSERT SELECT statement & whether or not it can
handle date inserted from a form on a web page...
[/snip]
Any query you can write in MySQL monitor can be written in your choice of
progra
Hi
First of all this question belongs on the [EMAIL PROTECTED] mailing
list.
Secondly, you should not be sending this kind of a question to the MySQL
developers
Thirdly, the QMYSQL3 driver is part of the QtV3.0.x distribution. I presume
you have the X-11 Free Edition of Qt, so run ./configure -
Hi Anton
You can find much information here: , http://www.mysql.com/manual.php
(the manual)
and Here: http://www.mysql.com (the website). and Here:
http://swfaq.mysql.com/sw/bin/11/supportwizard.cgi/02200286
The specific on-line manual on installing mysql start here:
http://www.mysql.com/documen
e least limit your
control.
> -Original Message-
> From: mysql-digest-help [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 24, 2001 6:08 PM
> To: venu; turner; mysql
> Cc: adouglas
> Subject: RE: RE: Info Needed to Promote MySQL!!
>
>
> > As a quick note
> What I did to handle global changes was have one access file on the
> fileserver that everyone had a shortcut to. That way the updates
> were global since they were all to the same file.
How is the speed of running Queries, Forms and Reports from Access using
linked tables to MySQL? I've found
Adam Douglas wrote:
> 1. Replication between 2 sites via the internet over a VPN or just using a
> secure connection.
Chapter 11 in the manual (p. 354 of the PDF). You're set. SSH will get
you the secure connection.
> 2. Transaction processing capabilities with the ability to roll-back a
>
What I did to handle global changes was have one access file on the
fileserver that everyone had a shortcut to. That way the updates
were global since they were all to the same file.
Dave
On Mon, Sep 24, 2001 at 04:19:55PM -0600, Adam Douglas wrote:
> > Another small research in Access made me t
> Another small research in Access made me to see the changed
> table structure
> completely. Please use this procedure to view or to refresh
> links when the
> structure or location of a linked table has changed.
>
> 1. Open the database in access that contains links to tables.
> 2. On the Too
> Another small research in Access made me to see the changed
> table structure
> completely. Please use this procedure to view or to refresh
> links when the
> structure or location of a linked table has changed.
>
> 1. Open the database in access that contains links to tables.
> 2. On the Too
uglas [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, September 24, 2001 2:43 PM
> > To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'; Mysql@Lists. Mysql. Com
> > (E-mail)
> > Subject: RE: RE: Info Needed to Promote MySQL!!
> >
> >
> > > >
> As a quick note, I tried the same with MS SQL Server through
> its latest ODBC
> driver by adding the new column, and I couldn't see any changes in the
> linked tables from Access 2002.
>
> So it shows clearly that, its some thing related to MS
> Access, not with the
> driver. It might be a b
California, USA
<___/ www.mysql.com
> -Original Message-
> From: Adam Douglas [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 24, 2001 2:43 PM
> To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'; Mysql@Lists. Mysql. Com
> (E-mail)
> Subject: RE: RE: Info Nee
s. Mysql. Com (E-mail); David Turner
> Subject: Re: RE: Info Needed to Promote MySQL!!
>
>
> I was never able to see the changes in table structure with
> Access and Oracle unless I manually added the column to linked
> table in Access after I had added it in Oracle.
>
> Dave
&
I was never able to see the changes in table structure with
Access and Oracle unless I manually added the column to linked
table in Access after I had added it in Oracle.
Dave
On Mon, Sep 24, 2001 at 02:34:30PM -0700, Venu wrote:
> Hi Douglas and David !!
>
> > I have the following setup...
> >
> > Now I've found when I do changes to a table schema the
> changes are not
> > entirely at least reflected in a the same table linked in Access.
> > I had once
> > case where I changed a data type on one of the columns and
> that data type
> > was not changed on the linked table in Access. I h
Hi Douglas and David !!
> I have the following setup...
>
> - MySQL 3.22.32 on OpenBSD v2.9
> - MyODBC on Windows '98 SE
> - MS Access 2000
>
Cool !!!
> Now I've found when I do changes to a table schema the changes are not
> entirely at least reflected in a the same table linked in Access.
I've had the same issues. I have really avoided the dev side of things
for some time so I'm not sure whether there's a way around it. Mainly
just devoting myself to administration. Funny though I'm starting to
write jsp stuff to monitor the databases more effectively.
I agree with you on the MYO
> What type of schema do mean here ? Because as you know, MySQL doesn't
> explicitly supports any schema's except the catalogs( in MySQL term
> 'database'). If you can elaborate what exactly the problem
> you are facing,
> then we can provide a rapid solution.
>
> Also, as for as I know, when I
Hi!
On Sep 24, Adam Douglas wrote:
>
> my main concern is to find a Windows MySQL GUI Client that will do everything
> in a similar fashion as Access.
If I'm not mistaken you can just continue to use Access as a GUI and for
rapid prototyping, connecting it to MySQL via ODBC.
Regards,
Sergei
-
>> Now I have quite a bit of information on all these questions.. my
>> main concern is to find a Windows MySQL GUI Client that will do
everything
>> in a similar fashion as Access. I believe we would need the
>> basics but also
>> including visual query builder and reports. I've recently fou
Hi
> Now I have quite a bit of information on all these questions.. my
> main concern is to find a Windows MySQL GUI Client that will do everything
> in a similar fashion as Access. I believe we would need the
> basics but also
> including visual query builder and reports. I've recentl
Connection();
stmt = con.createStatement();
rs = stmt.executeQuery(sqlQuery);
}
- Original Message -
From: Venu Anuganti <[EMAIL PROTECTED]>
To: Asha Ramaiah <[EMAIL PROTECTED]>
Sent: Thursday, July 19, 2001 11:55 AM
Subject: Re: Info needed!
> If Connection.isClosed()
Hi Asha
Yes, you are correct. Please refer to the following link for more details:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SHO
W
Thank you
Venu Anuganti
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/
> > Hi all,
> >
> > I'm looking for some pointers towards some good information on accessing
> and using MySQL with Java/Javascript.
> >
> > Can anyone point me towards a book you like, or some good web resources?
> >
> > Thanks much,
> > /Rob
> >
You'll need a servlet and/or JSP engine such as
"Professional JSP", by Wrox Press Ltd, is a quite good book.
Matt
- Original Message -
From: "Robert Alexander" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 24, 2001 2:48 PM
Subject: Info on using MySQL with Java
> Hi all,
>
> I'm looking for some pointers towards
MySQLGui is a good option in graphical mode, there are other command line
clients too
At 19.40 14/3/01 +0100, you wrote:
>can I manage mysql server 3.23 on red hat linux 6.1 using a win32 client on
>win nt ?
>thank you in advance.
>regards.
>
>Andrea GIGLIOTTI
>
>G&B Net S.n.c.
>Via Bagni Caldi,
Yes. There are several Win32 clients such as the urSQL Utility
(www.urbanresearch.com/ursql) that can be used to access and/or maintain
MySQL databases via Windows.
On Wed, 14 Mar 2001, G&B Net wrote:
> can I manage mysql server 3.23 on red hat linux 6.1 using a win32 client on
> win nt ?
> t
hi,
just take a look at http://www.mysql.com/documentation/lists.html or send an empty
mail from your accout to mailto:[EMAIL PROTECTED]
Greetings
Andreas
> Can anyone tell me how to UNSUBSCRIBE from this list. I have sent numerous mails to
>the [EMAIL PROTECTED] but theres no action take
74 matches
Mail list logo
