UNION in JDBC - WAS Re: use of indexes

2005-07-23 Thread Chris Faulkner
Hello again Following on from this index question, the UNION worked. From a normal mysql client, it was returning my results sub-second. I am actually executing this over JDBC, using mysql-connector j. WHen I put the SQL into my Java program - it takes a minute or so. I am logging the SQL and if

Re: more queries vs a bigger one

2005-07-23 Thread Octavian Rasnita
Hi, I have finally modified that long query and splitted into smaller ones. Now the main query is: select sql_calc_found_rows a.pre_title, a.title, a.post_title, substring(a.body, 1, 250) as preview, a.hash, a.date, a.time, length(a.body) as size, a.id_categories, n.name as newspaper, sc.category

Re: Innodb Questions (was: Mac OS X Table Corruption)

2005-07-23 Thread Dan Tappin
So I've been poking around my system and I found /usr/lib/mysql/ /usr/share/mysql/ The mod dates on these are really old. Can I delete these safely? I'm guessing the are from the Apple install. These files seem to be in the /usr/local/mysql/ path also. Hmmm... I looked at my old Mac OS

Re: Totals Across Multiple Records

2005-07-23 Thread Albert Padley
Sol and Peter, Thanks for your feedback. Both of your suggestions got me going in the right direction and I was able to solve the problem using temporary tables and left joins. Thanks again. Albert Padley On Jul 23, 2005, at 11:00 AM, sol beach wrote: create table count_temp1 select i

Re: Innodb Questions (was: Mac OS X Table Corruption)

2005-07-23 Thread Dan Tappin
On Jul 23, 2005, at 12:49 PM, Ware Adams wrote: Then I don't know what to say about the MyISAM error, though I'd watch InnoDB pretty carefully as I think MyISAM is pretty robust on OS X too. We did also see these when a disk is failing, but I assume you've run disk utility. I guess it co

Re: libmySQL.so location

2005-07-23 Thread Tim Johnson
* Tim Johnson <[EMAIL PROTECTED]> [050723 10:42]: > * sol beach <[EMAIL PROTECTED]> [050723 09:15]: > > I suspect a case problem > Hello sol: > I'm using a case insensitive seach. > i.e.: > > [EMAIL PROTECTED] tim]$ locate -i libmysql.so > [EMAIL PROTECTED] tim]$ Needed libdbi-0.6.5

Re: Innodb Questions (was: Mac OS X Table Corruption)

2005-07-23 Thread Ware Adams
On Jul 23, 2005, at 1:58 PM, Dan Tappin wrote: On Jul 23, 2005, at 10:14 AM, Ware Adams wrote: Has your mysql crashed or have your restarted the machine without first shutting down mysql manually? We only saw this error when mysql was not shut down normally. You can look in your .err fi

Re: libmySQL.so location

2005-07-23 Thread Tim Johnson
* sol beach <[EMAIL PROTECTED]> [050723 09:15]: > I suspect a case problem Hello sol: I'm using a case insensitive seach. i.e.: [EMAIL PROTECTED] tim]$ locate -i libmysql.so [EMAIL PROTECTED] tim]$ same results as root thanks tim -- Tim Johnson <[EMAIL PROTECTED]> h

Re: Innodb Questions (was: Mac OS X Table Corruption)

2005-07-23 Thread Dan Tappin
On Jul 23, 2005, at 10:14 AM, Ware Adams wrote: Has your mysql crashed or have your restarted the machine without first shutting down mysql manually? We only saw this error when mysql was not shut down normally. You can look in your .err file which should be in your data directory. Ever

Re: storing php pages with sql queries in a mysql database

2005-07-23 Thread Ludwig Pummer
Gregory Machin wrote: Hi all. I'm writing a php script to store the contents of html and php pages in a data base, it works well until there are mysql queries in the pages source then give errors such as this one. Query failed: You have an error in your SQL syntax near 'temp' how do stop mysq

Re: libmySQL.so location

2005-07-23 Thread sol beach
I suspect a case problem ln -s /usr/lib/dbd/libmysql.so libmySQL.so # perhaps? /opt/lampp/lib/mysql/libmysqlclient.14.0.0 /opt/lampp/lib/mysql/libmysqlclient.14 /opt/lampp/lib/mysql/libmysqlclient.so.14 /opt/lampp/lib/mysql/libmysqlclient.so.14.0.0 /opt/lampp/lib/mysql/libmysqlclient.so /opt/lamp

Re: Innodb Questions (was: Mac OS X Table Corruption)

2005-07-23 Thread Ware Adams
On Jul 23, 2005, at 11:56 AM, Dan Tappin wrote: I am all most ready to give up on MySQL at this point. I'm still getting regular table corruption on multiple installs of OS X. I went as far as reporting it as a bug: http://bugs.mysql.com/bug.php?id=12066 They seem to want more info but my

libmySQL.so location

2005-07-23 Thread Tim Johnson
Using mysql 3.23 on Red Hat 9.0 partition, mysql 4.0.20 on Slack 10.0 partition. I have reviewed some code for a lisp mysql library using the Foreign Function Interface (exposing the "C" API). the shared object referenced in the code is libmySQL.so. I am not able to locate a file with that n

Innodb Questions (was: Mac OS X Table Corruption)

2005-07-23 Thread Dan Tappin
I am all most ready to give up on MySQL at this point. I'm still getting regular table corruption on multiple installs of OS X. I went as far as reporting it as a bug: http://bugs.mysql.com/bug.php?id=12066 They seem to want more info but my requests for clarification have gone unanswered.

storing php pages with sql queries in a mysql database

2005-07-23 Thread Gregory Machin
Hi all. I'm writing a php script to store the contents of html and php pages in a data base, it works well until there are mysql queries in the pages source then give errors such as this one. Query failed: You have an error in your SQL syntax near 'temp' how do stop mysql from trying to interper

Re: 4.1.13 OS X MAJOR I/O Degredation

2005-07-23 Thread Ware Adams
On Jul 22, 2005, at 6:22 PM, Bruce Dembecki wrote: So it appears I am having an issue with 4.1.13 which I'm guessing is a bug... wanted some input before I file it... Setting up a new machine to take over for an old one, so it's clean, Operating System and some empty disks... the server doe