Re: Error while running Mysql

2010-12-24 Thread Sharl.Jimh.Tsin
check the error log,and you know the 5.5.8 enable the innodb by default,make sure that you have enough RAM. Best regards, Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) 2010/12/23 Krishna Chandra Prajapati : > HI Adarsh, > > Try memtester command > > #memtester 5 1 > > It' a linux t

5.5 versus 5.1

2010-12-24 Thread Carl
I have been using 5.1.42 for a while. I purchased a new server (Dell T110 with 8GB memory) to use for the databases that I don't want on the production server. I am using Innodb exclusively. Queries on 5.5 took 4 to 10 times as long as 5.1. Thinking I had a problem with the hardware, I then

join query for sale report

2010-12-24 Thread bharani kumar
I want to take the sale report, Group by catID , Daily report , table name : tblbasket BID Auto Incre, Prim Key BID int(20), BasketSessionID varchar(100),ProductCode varchar(50), CatID int(10), Quantity int(20), AfterDiscount double,purchasedate datetime, Status int(3) table name

Re: How to Install Mysql

2010-12-24 Thread Johan De Meersman
On Fri, Dec 24, 2010 at 6:37 AM, Adarsh Sharma wrote: > Or I am going to install through rpm which is the easiest way. But which is > best for our Production Servers. > Unless you have very specific needs, it's always best to use official packages for production. That also makes it easier to get

ANN: Database Workbench 4.1.0, the multi-DBMS IDE now available!

2010-12-24 Thread Martijn Tonies
0 adds new features, latest DBMS support and improved functionality. For more information, see http://www.upscene.com/go/?go=news&id=20101224 For a full list of fixes in version 4.1.0 and previous versions, see: http://www.upscene.com/go/?go=tracker&v=4.1.0&id=1 http://www.upscene.com/