[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] mySQL Database
****** message to minivend-users from "Mr. Christopher F. Miller" <cfm@maine.com> ******
On Tue, Jan 25, 2000 at 01:03:31PM +0100, Christian J. Müller wrote:
> ****** message to minivend-users from "Christian J. =?iso-8859-1?Q?M=FCller?=" <cmueller@polinet.ch> ******
>
> I am playing around with MV4alpha10 on Linux (SuSE 6.3) and a large
> (520,000 recs, 230 MB) mySQL Database. Sartup procedure of the MV server
> takes about 30 mins. Thats long, but I can live with it. However, TOP
> tells me that minivend is using some 420 MB of memory! It eats up all my
> 256 MB DRAM (I thought I was generous when buying 256 MB..) plus most of
> my swap space. Needless to say that the system is very slow.
> I am using a pure mySQL db, which I created in mysql and I have NoImport
> products set. The db has some 90 fields, which I all defined in
> catalog.cfg.
> Does anyone know, whether this is normal. Is my configuration faulty or
> did I miss something?
> It appears as though MV is keeping the whole db in memory!?? That does
> not make sense to me.
Are you saying you have 90 fields in your products table? If you access
just a handfull all the time and the rest rarely you might want to
think about splitting it apart.
Look also at your mySQL logs to see just how that is starting up and the
kinds of queries. Indexing makes a huge difference in SQL performance.
>
> I hope someone can explain this to me.
>
> Chris
> -
> To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list
--
Christopher F. Miller, Publisher cfm@maine.com
MaineStreet Communications, Inc 208 Portland Road, Gray, ME 04039
1.207.657.5078 http://www.maine.com/
Database publishing, e-commerce, office/internet integration, Debian linux.
-
To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list
