If you could present sample data of both table1,
table2, and an example of the result set it would be
easier to give you the sql. I believe you could
eliminate the temporary table with a subselect in the
original query. The subselect is where you would
specify 'Smith'.
Dave
--- mos [EMAIL
i have the following tables all threads adds jobs to the que and when
one thread processes the url it is added to the fetched table i want
to select the first record from the que which contains the given host
and is not in the fetched table i use the following query to get the
result but
this simple test and it worked,
CREATE PROCEDURE p_select (IN tablen VARCHAR(128))
BEGIN
SELECT CONCAT(SELECT * FROM , tablen) INTO @a;
PREPARE stmt1 FROM @a;
EXECUTE stmt1;
DEALLOCATE PREPARE stmt1;
END;
I don't understand why using a regular procedure variable instead of a
session
Hello,
I am moving my first steps with stored procedures in Mysql and I was
trying to write a stored procedure
using a tablename given as a variable. In this example the local
variable m_sequence has the value of the
table I want to use.
CREATE PROCEDURE p_new_id (IN tablename VARCHAR(128
Hi, I'm trying to migrate from MySQL 4.1.11 to MySQL 5.0 and I get a problem
with the new release.
I have this table...
provasql
CREATE TABLE `provasql`
`idrow` bigint(20) unsigned NOT NULL default '0',
`descr` varchar(50) default NULL,
PRIMARY KEY (`idrow`)
) ENGINE=InnoDB DEFAULT
On Friday 04 November 2005 07:30 am, AESYS S.p.A. [Enzo Arlati] wrote:
Hi, I'm trying to migrate from MySQL 4.1.11 to MySQL 5.0 and I get a
problem with the new release.
I have this table...
provasql
CREATE TABLE `provasql`
`idrow` bigint(20) unsigned NOT NULL default '0',
`descr`
For a while my application should support both mysql 4 and 5 ( teh same copy
on different sites of course ) so I should keep using a soluting wich should
works well on both revision.
I also have a couple of server with their database configured as master
slave, so I don't trust to use
mysql 4 and 5 ( teh same copy
on different sites of course ) so I should keep using a soluting wich should
works well on both revision.
I also have a couple of server with their database configured as master
slave, so I don't trust to use autoincrement.
When I can leave ther revision 4 at all I
When creating an index in phpMySQL I get a warning message about having
2 indexes using the same field.
The table is simply a product comment table.
The first index is simply an INDEX on the product_id to speed up
displaying them when someone wants to lookup the comments for that product
Michael J. Pawlowsky [EMAIL PROTECTED] wrote on 10/28/2005 11:28:42
AM:
When creating an index in phpMySQL I get a warning message about having
2 indexes using the same field.
The table is simply a product comment table.
The first index is simply an INDEX on the product_id to speed up
[EMAIL PROTECTED] wrote:
Michael J. Pawlowsky [EMAIL PROTECTED] wrote on 10/28/2005 11:28:42
AM:
When creating an index in phpMySQL I get a warning message about having
2 indexes using the same field.
The table is simply a product comment table.
The first index is simply an INDEX
was thinking of using a DAY column so that I can just find values
in the last day.
Then I could rewrite it as:
SELECT * FROM PRODUCT WHERE DAY = ? ORDER BY PRICE;
and place an index on DAY, PRICE at which point I'd be able to order
by the index.
Which would work really well.
The problem
, PRICE but it will have to resort to a
filesort since DATE isn't a constant value.
I was thinking of using a DAY column so that I can just find values
in the last day.
Then I could rewrite it as:
SELECT * FROM PRODUCT WHERE DAY = ? ORDER BY PRICE;
and place an index on DAY, PRICE at which
Hello.
I'm not familiar with xCode, but usually you should include
libmysqlclient (if you're using C). See:
http://dev.mysql.com/doc/refman/5.0/en/mysql-apis.html
I suggest you to make a request to [EMAIL PROTECTED] in case you want
to include parts of MySQL in your products
Hello all,
I have been working on a MySQL client which I wrote in Apple's xCode.
The client works as long as it is on my machine which has MySQL
installed, however if I send the client to another computer which does
not have MySQL installed it does not work. I am under the impression I
need
Hi, I am trying to restore from an .sql file created by mysqldump.
To restore I am using mysqldump as well.
I deleted all of the rows in a table.
When I restore it is still empty.
I noticed on my screen that the dump does inserts but the restore does not.
I am using the -c option.
Can
John Doneker wrote:
Hi, I am trying to restore from an .sql file created by mysqldump.
To restore I am using mysqldump as well.
I deleted all of the rows in a table.
When I restore it is still empty.
I noticed on my screen that the dump does inserts but the restore does not.
I am using the -c
John Doneker [EMAIL PROTECTED] wrote on 10/11/2005 04:43:40
PM:
Hi, I am trying to restore from an .sql file created by mysqldump.
To restore I am using mysqldump as well.
I deleted all of the rows in a table.
When I restore it is still empty.
I noticed on my screen that the dump does
Hello.
I am using a desktop program that imports data from a mysql
What program?
for one little glitch: it adds one extra row at the beginning of
the dataset with the names of the columns in it. I need for that
Does you program show column names in the numeric fields
Gleb Paharenko wrote:
Hello.
I am using a desktop program that imports data from a mysql
What program?
Printbench Pro
for one little glitch: it adds one extra row at the beginning of
the dataset with the names of the columns in it. I need for that
Does you program show column
am using a desktop program that imports data from a mysql
What program?
Printbench Pro
for one little glitch: it adds one extra row at the beginning of
the dataset with the names of the columns in it. I need for that
Does you program show column names in the numeric
Hello,
I am using a desktop program that imports data from a mysql
database using the ODBC mysql driver and everything works fine except
for one little glitch: it adds one extra row at the beginning of
the dataset with the names of the columns in it. I need for that
column name row
key_len ref rows Extra
1 SIMPLE template range PRIMARY PRIMARY 4 NULL 40 Using where
It's using a primary key and only examining the 40 rows which you
asked for, so that's about as optimised as you'll get for that query.
You could always make the actual server faster...
If your template table
The Mysql download page says I need to install these libraries if I
am using libc 2.3.x.
I have a couple of questions:
-- do I install them by just copying them to /usr/local/lib?
-- will they play that silly game of running unoptimized code on
AMD processors?
--
Christopher L. Everett
Using where
Thanks for the help
Kishore Jalleda
PRIMARY 4 *NULL* 40 Using where
It's using a primary key and only examining the 40 rows which you asked
for, so that's about as optimised as you'll get for that query. You
could always make the actual server faster...
--
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name
Hello all,
This works if t2 is populated:
select t1.item_no, t1.value1 *
(select weight from t2 where
item_no = t1.item_no and
descrip = 'dime bag')
from t1
where t1.descrip = 'marigold seeds'
If t1.item_no and/or 'dime bag' don't exist in t2 I'd
like to multiply by a different value (5):
- Original Message -
From: Jonathan Mangin [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday, September 24, 2005 2:18 PM
Subject: Using ifnull in a subquery
Hello all,
This works if t2 is populated:
select t1.item_no, t1.value1 *
(select weight from t2 where
item_no = t1
At 11:31 AM 9/13/2005, you wrote:
Hi all,
I found that load infile should not take this much time(6 hrs) to load 5.5
million queries. Some people are saying it should not even take more than
10mins. So I think I am doing something wrong in my my.cnf file. I am Using
MySQL 4.1.13 version
hi ,
I am using the Load Infile utility to load data from file to MySQL DB.
When trying to load different amounts of data, I observed a notable
difference in the time taken by that.
Test 1
Amount of data - 5.5 million rows. Time Taken - 6+hrs Approximately.
Test2
Amount of data - 0.45
Are there indexes on the table? Could be that.
--Original Message--
From: Sujay Koduri
To: mysql
Sent: Sep 13, 2005 5:24 AM
Subject: Major Difference in response times when using Load Infile utility
hi ,
I am using the Load Infile utility to load data from file to MySQL DB.
When trying
Yes, there are indexes on the table. Do you mean to say index is the
culprit.
sujay
-Original Message-
From: Peter J Milanese [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 13, 2005 4:58 PM
To: Sujay Koduri; mysql
Subject: Re: Major Difference in response times when using Load
or add them when you're done.
On Sep 13, 2005, at 7:24 AM, Sujay Koduri wrote:
hi ,
I am using the Load Infile utility to load data from file to MySQL DB.
When trying to load different amounts of data, I observed a notable
difference in the time taken by that.
Test 1
Amount of data - 5.5 million
Test 1
Amount of data - 5.5 million rows. Time Taken - 6+hrs Approximately.
Test2
Amount of data - 0.45 million rows. Time Taken - 2 mins approximately.
Is this an InnoDB database by any chance? If it is, and it is a clean
import, then disable the FOREIGN_KEY_CHECKS.
SET AUTOCOMMIT =
, September 13, 2005 8:48 PM
To: mysql@lists.mysql.com
Subject: RE: Major Difference in response times when using Load Infile
utility
Test 1
Amount of data - 5.5 million rows. Time Taken - 6+hrs Approximately.
Test2
Amount of data - 0.45 million rows. Time Taken - 2 mins approximately
Hi all,
I found that load infile should not take this much time(6 hrs) to load 5.5
million queries. Some people are saying it should not even take more than
10mins. So I think I am doing something wrong in my my.cnf file. I am Using
MySQL 4.1.13 version and 2.4.20 kernel on RH9. I am including
Qus 2. Is there any other way to compute the db size (other
than disk
quota).
du -s mysql_data_directory
If you want to know the size of a /single/ database (i.e. schema) then
this method works if there's just one database in the
mysql_data_directory. If there are multiple databases
Jaspreet Singh wrote:
Hi,
I am trying to compute the MySQL db size using show table status
command. It gives me the size of .MYD and .MIY files, but not .frm which
is typically 12k (using 4.1.9 version of MySQL)
Qus 1. is there any way to deterministically compute the value of .frm
file
Hi,
I am trying to compute the MySQL db size using show table status
command. It gives me the size of .MYD and .MIY files, but not .frm which
is typically 12k (using 4.1.9 version of MySQL)
Qus 1. is there any way to deterministically compute the value of .frm
file
Qus 2. Is there any other way
| ref | rows | Extra |
+++---+--+---+---+-+-+--+-+
| 1 | PRIMARY| A | ref | pathref_2,pathref | pathref_2 |
4 | const |1 | Using
Hello.
so why does 'explain select * from files where
(pathref,version)=(129286,0);' scan the whole table?
It is documented that this syntax can't be optimized yet. See:
http://dev.mysql.com/doc/mysql/en/row-subqueries.html
Jason Pyeron [EMAIL PROTECTED] wrote:
On Tue, 6 Sep
|
+++---+--+---+---+-+-+--+-+
| 1 | PRIMARY| A | ref | pathref_2,pathref | pathref_2 |
4 | const |1 | Using where |
| 2 | DEPENDENT SUBQUERY | B | ref | pathref_2,pathref | pathref_2 |
4 | crisfield.A.pathref |1 | Using index
|
++-+---+--+---+---+-+---++--+
| 1 | PRIMARY | files | ALL | NULL | NULL |NULL |
NULL | 117299 | Using where |
| 2 | SUBQUERY| files | ref | pathref_2,pathref | pathref_2 | 4 |
const | 1 | Using where; Using index
In the last episode (Sep 06), Jason Pyeron said:
there is an unique key index 'pathref_2 (pathref,version)' on this
table.
so why does 'explain select * from files where
(pathref,version)=(129286,0);' scan the whole table?
I have to admit I have never seen this syntax used in a where
On Tue, 6 Sep 2005, Dan Nelson wrote:
In the last episode (Sep 06), Jason Pyeron said:
there is an unique key index 'pathref_2 (pathref,version)' on this
table.
so why does 'explain select * from files where
(pathref,version)=(129286,0);' scan the whole table?
I have to admit I have never
libmyodbc_mysql.so (MyODBC 2.5) and also libmyodbc3.so
(MyODBC 3.5) and could not get either of these to work. But I'm not
sure if I'm using them correctly.
Basically all I've done is copy these files to my machine and change
this line in ColdFusion's odbc.ini file:
Old: Driver=3D/opt
. But I'm not
sure if I'm using them correctly.
Basically all I've done is copy these files to my machine and change
this line in ColdFusion's odbc.ini file:
Old: Driver=/opt/coldfusion/lib/CFmysql15.so
New: Driver=/opt/coldfusion/lib/libmyodbc_mysql.so
Does this sound like I'm using them correctly
Ed Kasky wrote:
Running MySql 4.1.14 on RedHat 7.2
I just upgraded from 4.1.13 to 4.1.14 and was am experiencing problems
using the mysql client.
# /usr/local/mysql/bin/mysql -h localhost -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 34
At 10:15 AM Saturday, 8/27/2005, Kemin Zhou wrote -=
Ed Kasky wrote:
Running MySql 4.1.14 on RedHat 7.2
I just upgraded from 4.1.13 to 4.1.14 and was am experiencing problems
using the mysql client.
# /usr/local/mysql/bin/mysql -h localhost -u root
Welcome to the MySQL monitor. Commands
Running MySql 4.1.14 on RedHat 7.2
I just upgraded from 4.1.13 to 4.1.14 and was am experiencing problems
using the mysql client.
# /usr/local/mysql/bin/mysql -h localhost -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 34 to server version
context MySQL
in the application.
can i set a cursor out put parameter and return it?(just like Oracle) or it has
another solution?
and another question: is MyODBC 3.51 tested with MySQL 5.x? can we call an SP
from Delphi via MyODBC? (i tried to do so (using ADO an a data provider for
OLEDB
parameter and return it?(just like Oracle) or it
has another solution?
and another question: is MyODBC 3.51 tested with MySQL 5.x? can we call an SP
from Delphi via MyODBC? (i tried to do so (using ADO an a data provider for
OLEDB) but i think somewhere in passing the call statement it had put
checking for mysql_init in -lmysqlclient... yes
checking whether mysql clients can run... no
configure: error: Your MySQL client libraries aren't properly installed
Message-
From: Steven Altsman [mailto:[EMAIL PROTECTED]
Sent: Friday, August 19, 2005 11:37 AM
To: 'mysql@lists.mysql.com'
Subject: Using MySQL libraries for a client app
checking for mysql_init in -lmysqlclient... yes
Steven Altsman wrote:
checking whether mysql clients can run... no
configure: error: Your MySQL client libraries aren't properly installed
Read through config.log to see what test was tried, and how it failed.
I've looked at the PureFTP archives and they aren't particularly helpful
I take
Steven Altsman wrote:
cp /usr/local/mysql/lib/mysql/* /usr/lib
No no no! There are several better options:
1. Add /usr/local/mysql/lib/mysql to your system's dynamic loader
configuration. On Linux, for instance, this is /etc/ld.so.conf; you
need to run ldconfig after changing that file.
I just got an email from MySQL concerning web seminar. Since I'm deaf I
would like to attend, is there any accomodations that I can use to get in
touch? There is a Video Relay Interpreting service online and am wondering
if MySQL could use that service?
--
Please avoid sending me Word or
this is not exactly what you are looking for, but it is where we started
on the task.
http://public.pdinc.us/cordova
a xml style sheet could easily be added, to create SQL DDL statements.
as far as the data rows that is easy as pie too.
I have to generate SQL. On the other site of
a SELECT query and pass it to
*something*. This *something* would execute the query, analyze found rows
and return SQL script creating these rows.
In current project I'm using Hibernate but this part can be done using any
tool or pure JDBC.
How would you handle such a task?
--
Best regards
with them.
The ideal solution would be to make a SELECT query and pass it to
*something*. This *something* would execute the query, analyze found rows
and return SQL script creating these rows.
In current project I'm using Hibernate but this part can be done using any
tool or pure JDBC.
How would
Hello.
See:
http://dev.mysql.com/doc/mysql/en/mysqldump.html
http://dev.mysql.com/doc/mysql/en/moving.html
http://dev.mysql.com/doc/mysql/en/backup.html
Eric Dahlenburg [EMAIL PROTECTED] wrote:
Hi,
I am currently a student learning SQL. I have MySQL 5.0 installed at =
Hi,
I am currently a student learning SQL. I have MySQL 5.0 installed at home
and on my Laptop. How can I take a database that I have updated on my laptop
and transfer it to my home PC so that they are both synchronized ?
I tried looking on the forums for this info, but forums locks-up my
Subject: Exporting a database from one PC to another using MySQL 5.0
Hi,
I am currently a student learning SQL. I have MySQL 5.0 installed at home
and on my Laptop. How can I take a database that I have updated on my laptop
and transfer it to my home PC so that they are both synchronized ?
I tried
|
++-+--+--+---+---+-+--+--+-+
| 1 | SIMPLE | RESOURCE | fulltext | res_title_idx | res_title_idx
| 0 | |1 | Using where
All,
I used migration tool kit from myslq and did migration from Oracle to Mysql.
No error occurred, but there are no data transfer? Do I need to set up
something on the server before I do migration?
Thank younguyen
--
MySQL General Mailing List
For list archives:
-n hi)
regards,
esv
--- Rakesh Gupta [EMAIL PROTECTED] wrote:
Hi There,
I am trying to insert blob in table and then
retrieve it from table using
Linux shell. Here is script that i used.
Load Blob into DB and Retrieve it using linux shell.
# add firmware into DB
ACTION=insert
Hello.
Maybe mysql puts the name of the column (firmwareimage),
at the beginning of the output (--skip-column-names should prevent it).
Rakesh Gupta [EMAIL PROTECTED] wrote:
Hi There,
I am trying to insert blob in table and then retrieve it from table using
Linux shell
Hi There,
I am trying to insert blob in table and then retrieve it from table using
Linux shell. Here is script that i used.
Load Blob into DB and Retrieve it using linux shell.
# add firmware into DB
ACTION=insert into FIRMWARE
(firmwarename, releasedate, bootcodename, usermanualname
I have notices some slow queries showing up in my slow query log lately.
Two of these queries are relatively simple queries using the index of
their respective tables. Both of these tables are very large and I
suspect this to be the problem. This problem appears to have started
within the last
little RAM means more disk I/O, which then kind of
compounds itself.
On Jul 18, 2005, at 3:30 PM, Ed Pauley II wrote:
I have notices some slow queries showing up in my slow query log
lately. Two of these queries are relatively simple queries using
the index of their respective tables. Both
access to a currently running database that hasn't
been destroyed by the nefarious query.
Some of my questions:
1) What are the benefits to using relay_log_file and relay_log_pos
instead of master_log_file and master_log_pos? that the slave
binlogs would already exist locally? Perhaps
On Jul 12, 2005, at 6:15 AM, gerald_clark wrote:
Nightly backup and binlogs can take you to any point in the day.
I failed to make my entire point clear then. That's true.
But when someone does the oh fsck, I think I just ran a catastrophic
query on our production database we would now
David Ulevitch wrote:
On Jul 12, 2005, at 6:15 AM, gerald_clark wrote:
Nightly backup and binlogs can take you to any point in the day.
I failed to make my entire point clear then. That's true.
But when someone does the oh fsck, I think I just ran a catastrophic
query on our
in the binary log.
Some of my questions:
1) What are the benefits to using relay_log_file and relay_log_pos
instead of master_log_file and master_log_pos? that the slave
binlogs would already exist locally? Perhaps that's good or bad?
thoughts?
Relay logs are better to use for this for one major
running database that hasn't
been destroyed by the nefarious query.
Some of my questions:
1) What are the benefits to using relay_log_file and relay_log_pos
instead of master_log_file and master_log_pos? that the slave
binlogs would already exist locally? Perhaps that's good or bad
Hi,
I am trying to search for a word that contains special chars like ş
or ţ, but I find only the words and like when the special
chars are not a part of the word.
I found that if I search for ş (in boolean mode), I am able to
find the records that contain the
Hello.
Follow recomendations from:
http://dev.mysql.com/doc/mysql/en/repair.html
After repairing with -r -q command line options, try just with -r.
[EMAIL PROTECTED] wrote:
Hi,
I will give the output below. I just ran an insert of a small amount of data
into Windoz/MySQL
Hi,
We have inquired about this warning before, but now that we have
upgraded to 4.1, we know which query/table is causing these frequent
warnings:
050701 17:19:34 InnoDB: Warning: using a partial-field key prefix in
search.
InnoDB: index `rp_id` of table `as_imp/roundrobin_pub`. Last data
Hi,
I will give the output below. I just ran an insert of a small amount of data
into Windoz/MySQL 5.0.6. Then, I ran a myisampack agains it. Finally, I ran
a myisamchk against it and keep coming up against this error:
Found wrong record at 687081
Now, I'm the only one who has access to this
.
DVP
Dathan Vance Pattishall http://www.friendster.com
-Original Message-
From: Kevin Burton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 21, 2005 6:01 PM
To: mysql@lists.mysql.com; [EMAIL PROTECTED]
Subject: Possible to DoS a slave by using multiple
connections
Not sure if this is a known issue or not.. but I haven't seen it
documented anywhere.
Anyway. My past thinking was that you should always use as many
connections as you have tables (at least with myisam). This way in the
worst case scenario you could have locks open on all tables instead of
MySQL run on a Mac using 10.4.1?
Thank you for your time.
Elton
=
NOVA505 W. Olive Ave. Suite 550
Elton Hughes (IT) Sunnyvale CA 94086
Phone: 408-730-7235
)
-
Should the installer have installed mysql.sock in /tmp on Macs
running OS 10.4.1? Is there a step I missed or is missing in the
documentation? Can MySQL run on a Mac using 10.4.1?
Thank you for your time.
Elton
=
NOVA
missed or is missing in the
documentation? Can MySQL run on a Mac using 10.4.1?
Thank you for your time.
Elton
=
NOVA505 W. Olive Ave. Suite 550
Elton Hughes (IT) Sunnyvale CA 94086
Phone: 408
Hello Kristen,
It looks like I am running mysqld.
- ps xa | grep mysqld
21281 p1- S 0:00.08 /bin/sh ./bin/mysqld_safe --datadir=/usr/
local/mysql/
21323 p1- R 0:00.98 /usr/local/mysql/bin/mysqld --defaults-
extra-file=/us
21324 p1- R 7:11.11 /bin/sh ./bin/mysqld_safe
for sorting if all columns in
the
ORDER BY clause are from the first table in the explain output that
doesn't
have a 'const' join type. This is why setting the ORDER BY to
mirealsource_homes_supplemental.mls_num will remove the 'Using filesort'
and
result in faster sorting.
I'm a little
figure out on its own that it can
get the same effect by using mls_num from either table, since the
tables are joined on it, so the values will always be identical.
You have two LEFT JOINs, so the values of mls_num might be something (the
identical value you refer to) or NULL. So, you expect
Scott Gifford [EMAIL PROTECTED] writes:
[...]
I think I'm going to take a look at the MySQL source and see if
there's anything I can tweak to get the effect I want. I'll report
back my results.
The MySQL source looked a bit too complex for casual hacking, but
here's what I ended up doing.
I'm having a hard time figuring out why a query in my application is
slow. It seems that MySQL is using a filesort where it's not
necessary, and as a result a query that should be taking a fraction of
a second is taking up to 10 seconds.
Essentially, the query is doing a join of 4 tables, two
|
++-+-++-
--+-+-+---+-
-+-+
| 1 | SIMPLE | mirealsource_homes_supplemental | ALL|
PRIMARY | NULL|NULL | NULL
| 100 | Using temporary; Using filesort |
| 1 | SIMPLE | mirealsource_homes | eq_ref |
PRIMARY | PRIMARY
can only use an index for sorting if all columns in the
ORDER BY clause are from the first table in the explain output that doesn't
have a 'const' join type. This is why setting the ORDER BY to
mirealsource_homes_supplemental.mls_num will remove the 'Using filesort' and
result in faster sorting
it to work now.
Thanx.
- --
Love is mutual self-giving that ends in self-recovery. Fulton Sheen
James Black[EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
should I be looking at changing in my CREATE PROCEDURE call to
enable it to work now.
Thanx.
- --
Love is mutual self-giving that ends in self-recovery. Fulton Sheen
James Black[EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG
-recovery. Fulton Sheen
James Black[EMAIL PROTECTED]
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFCpJYGikQgpVn8xrARAlslAKCMf8ChA6s+pngbJ82D5WWOjZYLvACeJDPD
F4dI37k5oEv1H8SeaLfLB24=
=7MBu
-END PGP
hi...
trying to build php4 with mysql4.1-12, for use in apache2. i have the
following ./compile that works for php5. however, when i try to use it for
php4, i get a msg, stating that it can't find the MySQL Headers...
can anybody provide any pointers as far as what the Headers are for mysql,
and
hi,
have you installed php4-mysql ?
look at http://www.coagul.org/article.php3?id_article=169 for example.
Mathias
Selon bruce [EMAIL PROTECTED]:
hi...
trying to build php4 with mysql4.1-12, for use in apache2. i have the
following ./compile that works for php5. however, when i try to use
--with-mysql is supposed to be the directory in which configure can find
the mysql header (.h) files and the mysql library (mysql.so) underneath
that directory.
/usr/bin/mysql_config is a program -- a binary if you will
It's incredibly unlikely that your MySQL header files and the mysql.so
are currently running MyIsam tables, but plan on switching to Innodb
in the next month or two btw, so our performance problems are w/ MyIsam.
Do you still have the problem ?
I've seen you're using FC1 which is rather old. I have not heard about
much of success of this version with Opteron.
also
I've added a fair bit of information on the Opteron HOWTO Wiki at:
http://hashmysql.org/index.php?title=Opteron_HOWTO
for using Fedora Core 3 with X86-64.
In my performance testing, I was finding that with so much RAM, everything
was coming from RAM anyway. RAID10 seemed to be most stable
index.html etc. I feel the question of whether I should be
using VCS is another
issue, probably should be! I 'm searching for another level of retrieval
sophistication. Sad that a
database does not appear ideal. Welcome any lateral ideas
--
zzapper
vim -c :%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s
801 - 900 of 3107 matches
Mail list logo