Re: Mysql Performance

2004-11-23 Thread Hagen Hoepfner
I do not believe that your problem is based on your hardware but ... Inserting data requires to reorganize your indexes. Please try to drop them (only for testing ;-) ) Hagen Carlos Augusto wrote: Well that´s me again with a new problem. I am runnig another database with 7gb of data and this db

Re: order by question

2004-11-23 Thread Hagen Hoepfner
You can try to use two subqueries and an union ala SELECT * FROM tab where c0 ORDER by C UNION ALL SELECT * FROM tab where c=0; Hagen dan orlic wrote: i have an question about ordering a set of records... ab c d - 1

Re: Basic Problem Facing towards..

2004-11-19 Thread Hagen Hoepfner
It seems that you PHP was compiled without mysql-support ... please take a look at the php-documentation. Shiva wrote: Hallo Everyone, I'm facing this basic problem for connecting the Mysql4.01 Database using Php5; The browser shows the following error; mysql_connect(localhost, root) or

Structure of .frm-Files ...

2004-11-19 Thread Hagen Hoepfner
Dear list, perhaps there is some one who can help me ;-) I currently try to understand the structure of .frm-Files. As I understood the documentation correctly this file contains the data dictionary which is independend from the storage engine (MyISAM, InnoDB, etc.). Is there any online

Re: Basic Problem Facing towards..

2004-11-19 Thread Hagen Hoepfner
4.1, php5; Thank you, Regards Shiva - Original Message - From: Hagen Hoepfner [EMAIL PROTECTED] To: Shiva [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, November 19, 2004 3:26 PM Subject: Re: Basic Problem Facing towards.. It seems that you PHP was compiled without mysql

MySQL 3.23.32 / SuSE Linux 7.1 / php and normal user

2001-02-21 Thread Hagen Hoepfner
Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) in /usr/local/httpd/htdocs/gutefrage/secure/statistic.php on line 19 What can I do? Hagen -- Hagen Hoepfner Uni MD / FIN / ITI / AG DB - eMail