Hi!
The application I develop requires mysqlclient library.
What lines should I add to configure.in to make configure script to
check for mysql libs and to set proper values for libs and includes?
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubsc
Jim Tyrrell wrote:
Everyone,
I finally feel let down by mysql after 5 years of
great use. I break most things in weeks so this is a
heck of a record. I am sure I am being a dummy on
this, but
am wondering if there is some setting somewhere to
help out a query like this.
Given a table like thi
Like the subject says, I am looking for any info regarding positive
or negative effects of using CPU affinity to lock the MySQL process
to a single processor (possibly hyperthreaded).
Anyone tried this? Learn anything interesting?
Thanks,
Jeff;
--
MySQL General Mailing List
For list archives:
On Thursday 12 January 2006 12:47 pm, Jake Peavy wrote:
> On 1/12/06, Mark Phillips <[EMAIL PROTECTED]> wrote:
>
> > There is a column in my table with string values, but the strings have
> > spaces
> > in them. I want to read the unique column values into an array in my bash
> > script, so I can
On Thursday 12 January 2006 11:40 am, George Law wrote:
> Mark,
>
>
>
> Sql is an alias to mysq -u.
>
> What about something like :
>
>
>
> declare -a TEAMS=(`echo "query"|sql|sed 's/$/",/g'|sed 's/^/"/g'|sed
> 's/"$//'`)
>
>
>
> since the query returns the results 1 per line,
Everyone,
I finally feel let down by mysql after 5 years of
great use. I break most things in weeks so this is a
heck of a record. I am sure I am being a dummy on
this, but
am wondering if there is some setting somewhere to
help out a query like this.
Given a table like this:
FeatureID is an au
Jim, here's an example query:
SELECT COUNT(listing.listing_id) AS listing_count FROM
listing_city_xref INNER JOIN listing
ON listing.listing_id = listing_city_xref.listing_id
AND listing.group_id = listing_city_xref.group_id
WHERE listing_city_xref.group_id =2
AND listing_city_xref.city_id IN (8
It might be a good idea if you could post the results of an EXPLAIN SELECT ...
for a fast query and a slow query along with their actual SQL statements.
James Harvard
At 11:37 am -0800 12/1/06, Tripp Bishop wrote:
>I've got a question regarding optimizing a query.
--
MySQL General Mailing List
On 1/12/06, Mark Phillips <[EMAIL PROTECTED]> wrote:
> There is a column in my table with string values, but the strings have
> spaces
> in them. I want to read the unique column values into an array in my bash
> script, so I can use these values in a separate query on this table. How
> do I
> get
Howdy all,
I've got a question regarding optimizing a query.
I've got two tables:
listing and listing_city_xref
listing is a pretty wide table with many fields that
can be queried by users. There is a subset of fields
that are always in queries of this table but there are
many additional fields
Mark,
Sql is an alias to mysq -u.
What about something like :
declare -a TEAMS=(`echo "query"|sql|sed 's/$/",/g'|sed 's/^/"/g'|sed
's/"$//'`)
since the query returns the results 1 per line, the first sed prefixes
each line with a quote
second sed replaces the newline with quot
one answer to your question as asked would be to wrap the column in a
concat() function and put the double quotes around each row.
the better answer is to use PERL
Oops - I forgot my version of mysql - 4.0.22 running on Red Hat Linux 7.3
2.96-113 kernel 2.4.20-30.7.
Mark
On Thursday 12 January 2006 10:43 am, Mark Phillips wrote:
> There is a column in my table with string values, but the strings have
spaces
> in them. I want to read the unique column val
I've got a program written for MySQL version 3 (don't ask, long story as to why
we haven't upgraded this particular system), compiled using gcc v3.2 on SUSE
Linux version 2.4.19-64GB-SMP. I'm getting a segmentation fault when I run
using ONE set of input parameters (but not any others).
When
There is a column in my table with string values, but the strings have spaces
in them. I want to read the unique column values into an array in my bash
script, so I can use these values in a separate query on this table. How do I
get the values into an array?
For example, the column teams in my
Vincente Aggrippino <[EMAIL PROTECTED]> wrote on 01/12/2006 12:47:31
AM:
> On 1/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> >
> >
> >
> > Vincente Aggrippino <[EMAIL PROTECTED]> wrote on 01/11/2006
11:33:38
> > PM:
> >
> > > I have three tables joined on key fields: delivery is joined
Also, you may find that check table/repair table are able to fix the problem.
See http://dev.mysql.com/doc/mysql/en/Table_maintenance.html for more
information.
Greg
On Thursday 12 January 2006 08:28, Greg Fortune wrote:
> That looks a little odd. Do isam tables have a .myi file for each tabl
That looks a little odd. Do isam tables have a .myi file for each table that
stores the indexes? If so, yours appears to be missing. I would suggest you
use mysqldump to dump the table, change the ENGINE= section in the resulting
dump file, and then reload the table and data from that dump fil
Ian wrote:
Hi,
On Amazon uk there are two versions of the book "High Performance MySQL ":
1st:
High Performance MySQL
~Jeremy D. Zawodny, Derek Balling
O'Reilly
Paperback - April 23, 2004
£19.95
2nd:
High Performance MySQL
~Derek J. Balling
O'Reilly Vlg. GmbH & Co.
Paperback - October 3
Hi Ian,
if you look closer at the picture of the second you'll see
that it's the German version of the book.
/Johan
Ian wrote:
Hi,
On Amazon uk there are two versions of the book "High Performance MySQL ":
1st:
High Performance MySQL
~Jeremy D. Zawodny, Derek Balling
O'Reilly
Paperback - Ap
Hi,
On Amazon uk there are two versions of the book "High Performance MySQL ":
1st:
High Performance MySQL
~Jeremy D. Zawodny, Derek Balling
O'Reilly
Paperback - April 23, 2004
£19.95
2nd:
High Performance MySQL
~Derek J. Balling
O'Reilly Vlg. GmbH & Co.
Paperback - October 31, 2004
£29.26
Does
The table may be damaged and seemingly unavaible to languages like
php(has your box crashed recently??), run 'SHOW TABLES' from the command
prompt and it should appear.If it does try running 'CHECK table' to see
if is damaged or not
Jon Miller wrote:
I've created a database with a table and
I forgot to add that the reset slave command worked properly , deleting all
the relay-bin files.
After the reset slave, I restart the slave and the realy files didn't grow
in number ( I got only ones of it ).
-Messaggio originale-
Da: AESYS S.p.A. [Enzo Arlati] [mailto:[EMAIL PROTECTED]
I
I've created a database with a table and etc. I'm now getting a msg stating
the table has gone missing.
Is their a way to either reindex or import the database so the table can show
up.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
I got this strange situation, with 2 PC with win2000 and mysql 5.0.18 with
the replica enabled.
Apparently both the server and slave have no operation to do, but on the
slave were created more than 5000 relay-bin file in less than 45 minutes
I added some log, also they seems normal.
Is the second
Ravi,
please open a bug report at http://bugs.mysql.com and attach the COMPLETE
UNEDITED .err log to that bug report.
Looks like InnoDB accesses a page filled with zeros. This might be a
hardware fault or an OS bug, as well as an InnoDB bug.
Best regards,
Heikki
Oracle Corp./Innobase Oy
I
Hi,
2006/1/12, Vincente Aggrippino <[EMAIL PROTECTED]>:
> On 1/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> That fixed it... Thank you! But I don't understand how. Isn't my implicit
> inner join the same as the explicit one you used?
>
> I read Join Syntax in the ref. manual. Is it
27 matches
Mail list logo