If this is a dedicated MySQL box, i would increase the InnoDB buffer pool
setting in my.cnf to at least 8GB, 12 would be even better (you did say you
have 16GB of ram in the machine I believe).
Also, what is the output of:
show status like '%tmp%';
JW
On Wed, Sep 22, 2010 at 8:01 PM, Vokern wr
2010/9/23 Johnny Withers
>
> Can you show us the output of: show status like '%innodb%'
> JW
>
Sure.
mysql> show status like '%innodb%';
+---++
| Variable_name | Value |
+---+---
Can you show us the output of: show status like '%innodb%'
JW
On Tue, Sep 21, 2010 at 10:11 PM, vokern wrote:
> And this is the innodb file size, does this matter for performance?
>
> $ du -h ibdata*
> 11G ibdata1
> 11G ibdata2
> 11G ibdata3
> 59G ibdata4
>
>
>
> 2010/9/22 voke
Hi,
> If its an IO problem the first and easiest thing to do is (probably) look at
> your disk subsystem. You can easily achieve higher disk IO by increasing the
> number of disks and implementing something like RAID1+0.
Or you can be logical about it and try to determine whether the IO
performan
And this is the innodb file size, does this matter for performance?
$ du -h ibdata*
11G ibdata1
11G ibdata2
11G ibdata3
59G ibdata4
2010/9/22 vokern :
> This is piece of the setting in my.cnf:
>
> set-variable = innodb_buffer_pool_size=4G
> set-variable = innodb_additional_mem_p
This is piece of the setting in my.cnf:
set-variable = innodb_buffer_pool_size=4G
set-variable = innodb_additional_mem_pool_size=20M
set-variable = innodb_flush_log_at_trx_commit=2
set-variable =
innodb_data_file_path=ibdata1:10G;ibdata2:10G;ibdata3:10G;ibdata4:10G:autoextend
key_buffer
Hi,
Check your slow queries first. Large full scans can cause unwanted disk
io. Do you use MyISAM or InnoDB? From your status, you seem to have
intensive MyISAM locking.
Peter
On 09/21/2010 04:10 PM, Johan De Meersman wrote:
Also, mailing list doesn't want to distribute attachments :-) Here
Also, mailing list doesn't want to distribute attachments :-) Here's a link
to the metrics view I was on about earlier:
http://www.tuxera.be/mysqlstats.zip
On Tue, Sep 21, 2010 at 4:08 PM, Johan De Meersman wrote:
>
>
> On Tue, Sep 21, 2010 at 4:03 PM, wrote:
>
>> Quoting Johan De Meersman :
>>
On Tue, Sep 21, 2010 at 4:03 PM, wrote:
> Quoting Johan De Meersman :
>
>> Your raid controller is "lying" to you - you can't have RAID10 with just
>> two
>> disks :-p Don't worry about that, though - it's a good enough config.
>>
>
> Good enough? If he is genuinely saturating the disk with IO (a
Quoting Johan De Meersman :
Your raid controller is "lying" to you - you can't have RAID10 with just two
disks :-p Don't worry about that, though - it's a good enough config.
Good enough? If he is genuinely saturating the disk with IO (as he
states the problem is IO) then it isnt good enoug
t;
>
> Jangita | +254 76 918383 | MSN & Y!: jang...@yahoo.com
> Skype: jangita | GTalk: jangita.nyag...@gmail.com
>
>
>
>
> -Original Message-
> From: vokern [mailto:vok...@gmail.com]
> Sent: 21 September 2010 2:38 PM
> To: mysql@lists.mysql.com
>
>>>
>>> The disk is exactly Raid10.
>>> The CPU is two 2.5G*4, totally 16G memory.
>>>
>
> Two disks with SAS driver, 15K rpm.
>
RAID-10 with 2 disks? or do you mean RAID0 or RAID1???
Can't see how you would get RAID10, minimum of 6 disks for that, no?
--
MySQL General Mailing List
For list ar
Quoting vokern :
Two disks with SAS driver, 15K rpm.
Ok so you have fast disks, but with only 2 disks it is normal you will
be quite restricted by DISK IO. By adding more in multiples of 2 and
stripping across all you achieve RAID1+0 and higher max IO...
Andy.
--
MySQL General Mail
2010/9/21 :
> Quoting vokern :
>
>>
>> The disk is exactly Raid10.
>> The CPU is two 2.5G*4, totally 16G memory.
>>
>
> And how many disks do you have, and what type (SATA/SAS/FC etc) what RPM? To
> improve IO you can add more disks, or upgrade to faster disks.
>
>
Two disks with SAS driver, 15K
Thank you all for the kind helps.
I will check them and if still have problems I will come back.
2010/9/21 Machiel Richards :
>
> http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/
>
>
> http://www.mysql.com/why-mysql/performance/
>
> http://www.debian
Quoting vokern :
The disk is exactly Raid10.
The CPU is two 2.5G*4, totally 16G memory.
And how many disks do you have, and what type (SATA/SAS/FC etc) what
RPM? To improve IO you can add more disks, or upgrade to faster disks.
--
MySQL General Mailing List
For list archives: http://l
kern [mailto:vok...@gmail.com]
Sent: 21 September 2010 2:38 PM
To: mysql@lists.mysql.com
Subject: document for mysql performance improvement
Hello,
We are using mysql-5.1 with innodb engine for a web 2.0 application.
But we found that the performance is not that good, i.e, the IO load
sometime is
2010/9/21 :
> If its an IO problem the first and easiest thing to do is (probably) look at
> your disk subsystem. You can easily achieve higher disk IO by increasing the
> number of disks and implementing something like RAID1+0. What is your
> current disk configuration?
>
The disk is exactly Rai
If its an IO problem the first and easiest thing to do is (probably)
look at your disk subsystem. You can easily achieve higher disk IO by
increasing the number of disks and implementing something like
RAID1+0. What is your current disk configuration?
Andy.
--
MySQL General Mailing Li
ubuntu server Linux, with apt-get for installing mysql.
> So is there any good document for improving mysql performance? Thanks.
>
> Regards.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mys
. Have you changed any of
> the default buffer and cache sizes as yet?
>
> Regards
> Machiel
>
>
> -Original Message-
> From: vokern
> To: mysql@lists.mysql.com
> Subject: document for mysql performance improvement
> Date: Tue, 21 Sep 2010 20:37:49 +0800
>
Hello,
We are using mysql-5.1 with innodb engine for a web 2.0 application.
But we found that the performance is not that good, i.e, the IO load
sometime is high, the query is timeout.
We run ubuntu server Linux, with apt-get for installing mysql.
So is there any good document for improving mysql
Thanks for your patient reply.
Now I believe that the memory leak problem was generated by the program.
On Sat, Nov 1, 2008 at 5:31 PM, Ian Christian <[EMAIL PROTECTED]> wrote:
> 2008/10/31 Moon's Father <[EMAIL PROTECTED]>
>
>> *A prepared statement is also global to the connection. If you cr
2008/10/31 Moon's Father <[EMAIL PROTECTED]>
> *A prepared statement is also global to the connection. If you create a
> prepared statement within a stored routine, it is not deallocated when the
> stored routine ends. *
>
> Then I don't know how to deallocate the memory used by prepare statement
Hi all,
I'm looking for information about References attribute in Mysql, help me!
thanks in advance.
Bo
Eddy D. Sanchez wrote:
> Thanks for your answer.
>
> I'm searching an opensource project (based on mysql obviously) that I
> can hack for my needs, but if I can't find anything, I must make one,
> my intention for technology is:
> -Java for application server and framework
Might I ask why you need
Eddy D. Sanchez wrote:
> Hello Everyone.
>
> I want to scan a large quantity of books and documents and store these
> like images inside or outside a database, I want use mysql, anyone
> have any experience with this kind of systems, can you suggest me an
> opensource solution ??
First question I
David T. Ashley wrote:
>
> Also, I have to say this to be complete ...
>
> You were aware, of course, that nearly every modern copyright for books
> prohibits digitizing the book and using it in any kind of document
> retrieval
> system? In fact, I believe a violation has
:
> -Java for application server and framework
> -store all image on a file server or into database like binary files
> (any sugestion)
> -user management policies
> -client interface for scan documents and storage on a database
> -any server for document consulting
>
> This a
o database like binary files
(any sugestion)
-user management policies
-client interface for scan documents and storage on a database
-any server for document consulting
This application should be opensource.
If you want participate just tell me, for hack one or develop from
scratch.
On 2
On Wed, 2007-06-27 at 20:07 -0400, Eddy D. Sanchez wrote:
> Hello Everyone.
>
> I want to scan a large quantity of books and documents and store
> these like images inside or outside a database, I want use mysql,
> anyone have any experience with this kind of systems, can you suggest
> me a
MMM, yes, but I think that CMS isn't the solution, I want to store a
large amount of documents and organize it with best performance for
indexing, searching and viewing.
On 27 Jun 2007, at 22:57, Gary wrote:
David T. Ashley wrote:
On 6/27/07, Eddy D. Sanchez <[EMAIL PROTECTED]> wrote:
books
prohibits digitizing the book and using it in any kind of document
retrieval
system? In fact, I believe a violation has occured even if it is
scanned
and the data is never used.
I just had to say this. I don't know how U.K. prisons are, but
here in the
U.S. they are full of large
David T. Ashley wrote:
On 6/27/07, Eddy D. Sanchez <[EMAIL PROTECTED]> wrote:
Hello Everyone.
I want to scan a large quantity of books and documents and store
these like images inside or outside a database, I want use mysql,
anyone have any experience with this kind of systems, can you suggest
source solution ??
Also, I have to say this to be complete ...
You were aware, of course, that nearly every modern copyright for books
prohibits digitizing the book and using it in any kind of document retrieval
system? In fact, I believe a violation has occured even if it is scanned
and the data is
On 6/27/07, Eddy D. Sanchez <[EMAIL PROTECTED]> wrote:
Hello Everyone.
I want to scan a large quantity of books and documents and store
these like images inside or outside a database, I want use mysql,
anyone have any experience with this kind of systems, can you suggest
me an opensource soluti
Hello Everyone.
I want to scan a large quantity of books and documents and store
these like images inside or outside a database, I want use mysql,
anyone have any experience with this kind of systems, can you suggest
me an opensource solution ??
Thanks.
--
MySQL General Mailing List
Fo
I think equating a tagline indicating something's been spam-checked
with a full out message for a web product is a little absurd.
On 8/3/06, Ian <[EMAIL PROTECTED]> wrote:
You say you hate spam then spam the list with an advert for McAfee!
Ian
--
"I'm American, fatboy. What's your excuse?"
On 3 Aug 2006 at 10:16, John Trammell wrote:
> If you hated spam as much as I did, you would have terminated this user,
> based on the egregious and well-documented abuse of this list.
> This message has been scanned for viruses by McAfee's Groupshield.
You say you hate spam then spam the li
Will L. wrote:
> Nabble hates spam as much as you do. We are currently monitoring this
> user and we will take necessary action just like a mailing list owner
> will do.
If you hated spam as much as I did, you would have terminated this user,
based on the egregious and well-documented abuse of th
Will L wrote:
Rob Munsch,
I am a member of the Nabble project. This is regarding a bad post by user
"itguy321".
Just want to explain a few things. Nabble is a free mailing list
archive/gateway that works like Gmane. Users can browse, search, and post
via Nabble's web interface and the post w
>
> Have a *great* day.
>
> Tracking link:
>
> http://www.nabble.com/check-out-this-free-software-i-found-to-document-your-it-infrastructure-tf2041675.html#a5620241
> No recent reports, no history available
> Resolves to 72.21.53.35
> Routing det
they shall shortly be blacklisted as well.
Have a *great* day.
Tracking link:
http://www.nabble.com/check-out-this-free-software-i-found-to-document-your-it-infrastructure-tf2041675.html#a5620241
No recent reports, no history available
Resolves to 72.21.53.35
Routing details for 7
ot;check out brand x product" I vote this is spam.
-Original Message-
From: itguy321 [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 02, 2006 1:06 PM
To: mysql@lists.mysql.com
Subject: Check out this Free software I found to document your IT
infrastructure
Hey guys, I just found th
Wednesday, August 02, 2006 1:06 PM
To: mysql@lists.mysql.com
Subject: Check out this Free software I found to document your IT infrastructure
Hey guys, I just found this great free software that lets you document your
entire IT infrastructure. In my opinion it's the best software out ther
-
From: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 18, 2006 11:35 PM
To: Tim Lucia
Cc: mysql@lists.mysql.com
Subject: Re: Document / Image (Blob) archival -- Best Practices
Tim Lucia wrote:
> Hi all,
>
>
> I am considering moving some archival records which largely c
t
the blobs (.PDFs) into some document management system. If you've done
anything like this, I'd like to hear about it as well.
I've done a couple of file-based systems. Briefly:
- separate filename into the actual name and the extension
- insert details into MySQL table
- fetch
i.com/archives/39
No experience with document mangement system. We talked a few times
about working with a digital library for storage but were never
compelled to go beyond what we had in MySQL.
Mike
On Apr 18, 2006, at 9:48 PM, Tim Lucia wrote:
Hi all,
I am considering moving some archival re
into some document management system. If you've done
anything like this, I'd like to hear about it as well.
All input appreciated (to the list, please ;-) )
Tim
On Mon, Apr 17, 2006 at 11:26:38AM +0800, 古雷 wrote:
> Hello:
>
> For example:
> What does "Web Access" and "Remote Troubleshooting" mean in this page
> https://shop.mysql.com/network.html?rz=s2
'Web Access' means you have access to the web-based support system.
'Remote Troubleshooting' means tha
Hello:
For example:
What does "Web Access" and "Remote Troubleshooting" mean in this page
https://shop.mysql.com/network.html?rz=s2
regards,
gu lei
Please read the document.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Rhino wrote:
First and foremost, thank you very much Michael for correcting my
mistakes; I _was_ a bit sloppy in my reading of the syntax for the
statements and that caused some unnecessary errors in my reply to Scott.
However, your corrections are not _quite_ right even now. See below
where
where I
> explain this.
>
> --
> Rhino
>
> - Original Message -
> From: "Michael Stassen" <[EMAIL PROTECTED]>
> To: "Rhino" <[EMAIL PROTECTED]>
> Cc: "Scott Purcell" <[EMAIL PROTECTED]>;
> Sent: Tuesday, January 31, 2006 1:
this.
--
Rhino
- Original Message -
From: "Michael Stassen" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: "Scott Purcell" <[EMAIL PROTECTED]>;
Sent: Tuesday, January 31, 2006 1:18 AM
Subject: Re: Help Understanding Document Syntax
Rhino wrote:
The 'symbol' you are referring to, in the foreign key clause of the
CREATE TABLE statement, is simply an opportunity for you to choose a
name for the foreign key of the table; if you don't choose a name, MySQL
will generate a default name for you.
Therefore, if you do this:
DATE statement appears to be the same idea;
UPDATE IGNORE
set fname = 'Fred', lname = 'Flintstone'
where empno = 4;
---
Rhino
- Original Message -
From: "Scott Purcell" <[EMAIL PROTECTED]>
To:
Sent: Monday, January 30, 2006 9:08
Hello,
I have created some tables a while back, and of course, and I am
learning, I have found problems with duplicate entries and other
problems.
So upon a fresh read of the 5.1 docs, I am trying to understand the word
"symbol" after the constraint.
I would like to be able to somehow comb
I am currently projecting a project where we can use MySQL to control
documents similiar to ISBN for IntraNet. We plan to export into XML as well.
It will require a good labelling, strategy and planning. Do anyone know
where I can find good resource to get started?
Thanks,
Scott
--
Power to
Michael Mason wrote:
I'm new to MySQL and already very impressed with it's flexibility,
speed and functionality. This in mind, I am looking for a way to allow
users to upload documents to the server for later retrieval by an
administrator.
Can this be done or will I have to find a nasty thir
Hello again.
I'm new to MySQL and already very impressed with it's flexibility,
speed and functionality. This in mind, I am looking for a way to allow users to
upload documents to the server for later retrieval by an administrator.
Can this be done or will I have to find a nasty thi
Please have a look at the attached file.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Thursday 08 Jan 2004 16:50, you wrote:
(B> On Thu, Jan 08, 2004 at 02:47:51PM +, Richard Davies wrote:
(B> > On Thursday 08 Jan 2004 12:33, Harald Fuchs wrote:
(B> > > In article <[EMAIL PROTECTED]>,
(B> > >
(B> > > Richard Davies <[EMAIL PROTECTED]> writes:
(B> > > > I find at present
On Thu, Jan 08, 2004 at 02:47:51PM +, Richard Davies wrote:
> On Thursday 08 Jan 2004 12:33, Harald Fuchs wrote:
> > In article <[EMAIL PROTECTED]>,
>
> > Richard Davies <[EMAIL PROTECTED]> writes:
> > > I find at present from reasons I can't work out if the image to be stored
> > > is a jpg t
pardon me for asking a stupid question, but when your storing data into
MySQL or any database for that matter, isn't "data" data? Does this have
something to do with the BLOB type? ( Which I've never understood anyway ).
I'm very new at this and am wanting to store documents that have database
fi
On Thursday 08 Jan 2004 12:33, Harald Fuchs wrote:
(B> In article <[EMAIL PROTECTED]>,
(B
(B> Richard Davies <[EMAIL PROTECTED]> writes:
(B> > I find at present from reasons I can't work out if the image to be stored
(B> > is a jpg then there is no problem but if it is a tiff them MySQL won't
Steve,
I know you've been pointed at an interesting resource, and others are saying
they've done this successfully, but I think you should get some balance.
I've worked in document management for years, and I think it's a very bad
idea. Have you ever had to restore a
Exactly.. it's like disk inodes.. So instead of a larger query and the
database having to transmit the big resultset over the network to the
webserver (assuming a multi-tier architecture), using up memory, you break
it down into smaller queries so the webserver keeps asking for chunks as
they are
anged, but being blobs in a table, the one
(large) file in the database would have to be backed up for each
change?
As for indexing, a lot of the document retrieval solutions out there
just go by metadata when you do a file search. Business class scanning
systems offer you the option of embedding
On 7 Jan 2004, at 21:51, [EMAIL PROTECTED] wrote:
This article discusses it briefly:
http://php.dreamwerx.net/forums/viewtopic.php?t=6
That's an interesting article. Thanks. A similar table design to what
I had in mind (hmmm... how different can these things be! :)
I like the idea of splitting
On Wednesday 07 Jan 2004 21:06, Ian O'Rourke wrote:
(B> Original Message -
(B> From: "Steve Folly" <[EMAIL PROTECTED]>
(B>
(B> > At work we are currently investigating ways of filing all our
(B> > electronic documents.
(B>
(B> I don't know the answer, but it's an interesting questio
me to restore a backup of the database than it would if I were dealing
with the extra gigabytes of embedded files (which I can restore on an
individual basis).
As for indexing, a lot of the document retrieval solutions out there
just go by metadata when you do a file search. Business class scanning
sy
ic documents.
>
> There is commercial software that will do this I know, but I was
> wondering whether MySQL would be suitable for this type of thing.
>
> The 'documents' could be literally any binary file. My idea would be to
> create a table with a blob column for the d
MySQL would be suitable for this type of thing.
The 'documents' could be literally any binary file. My idea would be to
create a table with a blob column for the document itself, and document
title, reference number, keywords, other meta-data. And a web-based
front-end to search and serve
your best choice here.
Leo. AFIP-AR.
- Original Message -
From: "Ian O'Rourke" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 07, 2004 6:06 PM
Subject: Re: MySQL as document storage?
> Original Message -
> From: "Steve
Original Message -
From: "Steve Folly" <[EMAIL PROTECTED]>
>
> At work we are currently investigating ways of filing all our
> electronic documents.
I don't know the answer, but it's an interesting question. We are currently
looking at using more and more SQL (we use MySQL now in places),
MySQL would be suitable for this type of thing.
The 'documents' could be literally any binary file. My idea would be to
create a table with a blob column for the document itself, and document
title, reference number, keywords, other meta-data. And a web-based
front-end to search and
There might be an error in the code.
Some Tech books will have a website dedicated to any corrections of it's contents.
The site location might be mentioned in the intro or you can search the publisher's
web site for it.
> >
> > Ok so the mysql_send.php loads great. ( Apache 2 is the web
> > s
o:[EMAIL PROTECTED]
> > Sent: 21 July 2003 6:56 am
> > To: [EMAIL PROTECTED]
> > Subject: Newbie question -- PHP document
> >
> >
> > Thanks for the help with my first question. using the USE
> mysql
> > command did
> > the trick.
> >
> >
in Oxford
> -Original Message-
> From: Nate Dawg [mailto:[EMAIL PROTECTED]
> Sent: 21 July 2003 6:56 am
> To: [EMAIL PROTECTED]
> Subject: Newbie question -- PHP document
>
>
> Thanks for the help with my first question. using the USE mysql
&g
Thanks for the help with my first question. using the USE mysql command did
the trick.
The book I am reading (
http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=2T67AHHR6W&isbn=0764516507&itm=1
)
PHP & MySQL for Dummies has a CD Rom with several PHP files. One is called
mysql_se
>
> hii,
>
> I am trying to learn how to use mysql with php on windows..
> Can you help me to find some tutorial , e-book or any helpfull url ...?
By
> the way, I am new at this .. so I need something covering the basic
> informations...
> thanks a lot
>
> Meltem
>
-
> > MS SQL Server has this function built in...please let me know what the
best
> > method to do this using mySQL
>
> Wouldn't you agree that this is not really a task for an RDBMS server?
> Aren't these typically things that a client application should sort out
> for itself, in whichever way
Hi,
On Mon, 2002-02-18 at 08:40, The Majestic Moined Mogul wrote:
> I am still looking for a method of reading XML documents into mySQL database
> and also to retrieve data from the mySQL database into an XML document
>
> I found something on how to do it with PERL but would l
I am still looking for a method of reading XML documents into mySQL database
and also to retrieve data from the mySQL database into an XML document
I found something on how to do it with PERL but would like to stick with
just JAVA...
MS SQL Server has this function built in...please let me
ords and do not contain these words. It's _boolean_ query.
Every document can either match (value = TRUE) or not (value = FALSE).
Some "relevance" that MySQL returns does not mean that much - it's a
simple estimation based on a number of words matched.
Boolean query - by its natur
,
Bob
> Hi!
>
> On Dec 15, Bob Sidebotham wrote:
> > MySQL full text indexing looks attractive, but I'm puzzled as to how to
> > use it
> > for my application.
> >
> > I'm storing documents that I'd like to be full-text indexed, but each
> >
Hi!
On Dec 15, Bob Sidebotham wrote:
> MySQL full text indexing looks attractive, but I'm puzzled as to how to
> use it
> for my application.
>
> I'm storing documents that I'd like to be full-text indexed, but each
> document can have multiple revisions. I&#x
MySQL full text indexing looks attractive, but I'm puzzled as to how to
use it
for my application.
I'm storing documents that I'd like to be full-text indexed, but each
document can have multiple revisions. I'm currently storing each
revision in full. The fulltext relevance
89 matches
Mail list logo
