PHP and MySQL 4.0.x
I am trying to setup PHP 4.2.x wth MySQL 4.0.x Somewhat new to this, I installed PHP via the redhat RPM. PHP is being loaded as a module to httpd. The error I keep getting is that httpd can't find libmysqlclient.so.10 and MySQL 4.0.x rpm installed libmysqlclient.so.11. I tried making a symlink from 11 to 10, but that just caused httpd to crash. Is there a newer php mysql.so libary? Does anyone have any ideas? sean. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: InnoDB row level locking?
>-Original Message- >From: Fernando Grijalba [mailto:fernando@;ggtours.on.ca] >Sent: Wednesday, November 06, 2002 11:41 AM >To: MySQL Help >Subject: InnoDB row level locking? > > >In the documentation it says that InnoDB supports row level >locking. How >can I ensure that rows are locked using ADO in a VB Applications >communicating with MySQL through MyODBC? > >I have tried setting my Recordsets to adLockPessimistic, but >that does not >seam to work. Make sure you are working inside transactions. then add this text to the end of your select statments "FOR UPDATE" This will ensure that no one else updates after you have selected the record. But it will still let others read. Commiting your transaction will release the lock. sean. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
slow returning records
running 4.x MySQL is very slow to return a large result set of about 45,000 records. The query seems to execute in a few seconds, but then it takes another 90 seconds to return all the data. The same query only takes 6 seconds to execute and return on MSSQL server, so I must have something setup wrong ( <- MySQL newbie ) I am using MyCC to issue the query. I already tried increasing the key_buffer_size and some other varaibles. here is the create: CREATE TABLE `tbl_PO_MainDetail` ( `nItemID` int(11) NOT NULL default '0', `sPOID` varchar(50) NOT NULL default '', `nNum` smallint(6) NOT NULL default '0', `sJobID` varchar(50) NOT NULL default '', `sItemID` varchar(30) NOT NULL default '', `nMatlID` int(11) NOT NULL default '0', `sDescription` varchar(250) NOT NULL default '', `sUnits` char(3) NOT NULL default '', `sMatlSize` varchar(10) NOT NULL default '', `nMatlTypeID` int(11) NOT NULL default '0', `sMatlShape` varchar(10) NOT NULL default '', `sMatlAlloy` varchar(15) NOT NULL default '', `dMatlQtyBars` double NOT NULL default '0', `dMatlQtyBarsRec` double default NULL, `dMatlQtyBarsDue` double default NULL, `dMatlLength` double default NULL, `sOperation` varchar(50) NOT NULL default '', `sRev` varchar(9) NOT NULL default '', `dQty` double NOT NULL default '0', `dQtyRec` double NOT NULL default '0', `dQtySent` double NOT NULL default '0', `dQtyDue` double default NULL, `dQtyToRec` double NOT NULL default '0', `dQtyToRecEA` double NOT NULL default '0', `dQtyToRecUnit` double NOT NULL default '0', `dQtyToRecBars` double NOT NULL default '0', `dPrice` double NOT NULL default '0', `yTaxable` tinyint(1) NOT NULL default '0', `dExt` double NOT NULL default '0', `dExtTax` double NOT NULL default '0', `nGLAccountID_Expense` int(11) NOT NULL default '0', `sGLExpenseIDX` varchar(50) NOT NULL default '', `dOpNum` double NOT NULL default '0', `dFPP` double NOT NULL default '0', `nEmpID_For` int(11) NOT NULL default '0', `bBarNoBreak` tinyint(3) unsigned default NULL, `upsize_ts` varchar(16) NOT NULL default '', PRIMARY KEY (`nItemID`), KEY `FK_tbl_PO_Main` (`sPOID`), KEY `_WA_Sys_dPrice_398D8EEE` (`dPrice`) ) TYPE=MyISAM; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: performance tunning 4.x
In the Ziff Daveis eWeek benchmark http://www.eweek.com/article/0,3658,s=708&a=23115,00.asp )I noticed the following: MySQL's great performance was due mostly to our use of an in-memory query results cache that is new in MySQL 4.0.1. When we tested without this cache, MySQL's performance fell by two-thirds. I couldn't find any information in the online document on how to configure this in-memory query results chache. Can anyone point me to some information on how to do this? sean. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of > Iikka Meriläinen > Sent: Wednesday, August 28, 2002 8:37 AM > To: Sean Hager > Cc: mySQL (E-mail) > Subject: Re: performance tunning 4.x > > > Hello, > > Yes, there are lots of good documentation: > First, the official MySQL Technical Reference, Section 5 at > http://www.mysql.com/doc/en/index.html > Then scroll down to "5 MySQL Optimisation" and read those. > > Also, check this: > http://www.devshed.com/Server_Side/MySQL/Optimize/page1.html > It's a bit older, but still useful. > > And finally, use www.google.com. :-) > > Regards, > Iikka > > On Wed, 28 Aug 2002, Sean Hager wrote: > > > Are there any documents on how to performance tune mySQL 4.x? > > > > sean. > > > > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > ** > * Iikka Meriläinen * > * E-mail: [EMAIL PROTECTED] * > * Vaala, Finland * > ** > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
performance tunning 4.x
Are there any documents on how to performance tune mySQL 4.x? sean. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
