From: Brent Baisley
You don't have to replicate the data, and you shouldn't. Since you will
be searching on parts of the data, you may want to store it in parts.
Then you can create indexes to merge the data for searching.
I'll be searching both on parts of the date as well as on the entire
Chuck,
demand for spatial features for InnoDB has been extremely low. They will
probably never be implemented unless someone sponsors them. FULLTEXT is much
more asked for.
Why not use the spatial extension of MyISAM, or some dedicated GIS database?
Best regards,
Heikki Tuuri
Innobase Oy
hi gents,
is there a way to do replication where all database fields
on the slave have the same type, but other names?
i didnt investigate a binary log yet to check how queries are
stored there, but maybe one of you has experiences with this kind of
configuration.
kind regards,
heri
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
--
Fatal error: Call to undefined function mysql_connect() in D:\Program
Files\Apache
It is possible to copy the database of mysql-3.22.32 (/usr/local/mysql/var) on
version 4.0.20 (/usr/local/mysql_new/var)?
There is possibility that they work?
My O.S. is Solaris 8
Thank's
Alessio
P.S.
In that case I must use the function mysqlhotcopy? I don't have the
possibility to use
NB! ...WHERE doycol=312
Valid only for dates = 28.Feb
OR Dates 29.Feb but not in leap year(s) ;-)
doycol=DAYOFYEAR(2004-11-07)
or
doycol=312
Eric McGrane wrote:
How about adding another column that stores the day of year for the
birthday. You could then index on this column and your query
This message was cancelled from within Mozilla.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Put the 60K ints into a temporary table. Next join against this temporary
table. This join forces the optimizer to translate the range into an
eq_ref-one of the fastest type joins.
He could also simply use a join to the ID table, provided that the
6 IDs are SELECTable in the current
Louie Miranda a écrit :
Im trying not to list the rows that has zero values.
this is my current select statement:
select id,country_city from rates_ocean order by country_city
The fields that i have to detect are:
fieldvalue1
fieldvalue2
fieldvalue3
how can i do this on mysql, ex:
select country
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
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
I found the below from Php Documentation * Php Manual.Chm *
Windows users may enable the extension php_mysql.dll inside php.ini. Also,
copy libmySQL.dll into the appropriate %SYSTEMROOT% directory, just like you do
with every other bundled DLL from the dll directory
My question is :
Hello
You may use query like this:
select country from rates where (fieldvalue1 !=0) and (fieldvalue2 !=0)
and (fieldvalue3 !=0) order by country;
See:
http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html
Louie Miranda [EMAIL PROTECTED] wrote:
Im trying not to list
Hello.
You may specify location of temp files with 'tmpdir' server system variable.
See:
http://dev.mysql.com/doc/mysql/en/Temporary_files.html
http://dev.mysql.com/doc/mysql/en/Server_system_variables.html
Gail Lange [EMAIL PROTECTED] wrote:
Hello
I have just installed mysql
Hello.
MySQL only supports one master and many slaves.
As I saw in comments at:
http://dev.mysql.com/doc/mysql/en/Replication_Options.html
You may use replicate-rewrite-db for tables:
replicate-rewrite-db = RemoteTableName -LocalTableName
i have 2 questions about Replication.
1)
Hello.
See:
http://dev.mysql.com/doc/mysql/en/LIMIT_optimization.html
Jeremiah Gowdy [EMAIL PROTECTED] wrote:
Can anyone tell me why this makes sense? I have a SELECT which uses an
indexed datetime
field called Start with a BETWEEN range. If I select on this with no LIMIT,
it does
Hello.
InnoDB does not keep an internal count of rows in a table. (This would
actually be somewhat complicated because of multi-versioning). To process a
SELECT COUNT(*) FROM T statement, InnoDB must scan an index of the table,
which will take some time if the table is not entirely in the
Hello, Karam.
As said in documentation libmysql.lib is only a wrapper for libmysql.dll,
so it doesn't have any useful code. It loads libmysql.dll and therefore
libmysql.lib is very light. About mysqlclient.lib I can say that static
libraries are usually larger then dynamic.
Karam
Perhapts this can help:
http://www.phpdiscuss.com/article.php?id=24847group=php.windows
Shiva wrote:
I found the below from Php Documentation * Php Manual.Chm *
Windows users may enable the extension php_mysql.dll inside php.ini. Also, copy
libmySQL.dll into the appropriate %SYSTEMROOT%
You could daisy chain the servers together,
this would be ineffiecient and not robust, but it would work.
shop1 master to shop2
|
customers1
|
V
shop2 master to shop3
|
customers1
customers2
|
V
shop3 master to office
|
customers1
customers2
Jeremiah Gowdy wrote:
Can anyone tell me why this makes sense? I have a SELECT which uses an indexed
datetime field called Start with a BETWEEN range. If I select on this with no
LIMIT, it does a full scan of the 9391282 records in the DB (key=NULL).
However, if I do a limit of any value
after unplugging the connection to our server the application hangs in a
mysql_query() without ever returning.
i remember that we tested this months ago and it worked normal, the query
exited with an error.
tested this with 4.0.18 and today with 4.1.7 ,anyone ever experienced
something like this
http://www.yohng.com/phpm/phpm.htm#_Toc42628370
Enabling MySQL API support for Microsoft Windows
When running Microsoft Windows, you may run into several issues with PHP
itself and MySQL. While C compiler is an essential part of most POSIX-
compatible operating systems,
hi All,
I have:
character set latin1 latin1
character sets latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620
ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251
estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 latin1
Hi,
I uninstalled MySQL 4.0.20 and installed 4.1 but on client computers I
cannot connect to the server. I checked this link:
http://dev.mysql.com/doc/mysql/en/Old_client.html
but I don't know what exactly I should do. can somebody tell me how I should
use the old method of password? I need an
Hi List,
I have a MySQL Data running on one Linux Server in my Intranet ,
I would like to have all the Databases and tables synced to MySQL Server
running on Windows Server .
How to Sync the data , or just copy the table from one machine to another
machine.
Does MySQL have any * Export
Sasha Pachev wrote:
So all I have to do, using the binary, is to take the mysqld file and
replace my old one (from 4.1.3 to 4.1.7, for example).
And for the source, I compile in another directory, then take the
mysqld file and replace my old one?
Is that documented somewhere?
Do not forget
Depending on your needs, you have several options, all documented in the manual:
SELECT ... INTO OUTFILE http://dev.mysql.com/doc/mysql/en/SELECT.html
mysqldump http://dev.mysql.com/doc/mysql/en/mysqldump.html
http://dev.mysql.com/doc/mysql/en/Upgrading-to-arch.html
Replication
denys wrote:
SELECT country
FROM Rates
WHERE fieldvalue1 0 AND fieldvalue2 0 AND fieldvalue3 0
ORDER BY country
is it what you want ?
Gleb Paharenko wrote:
Hello
You may use query like this:
select country from rates where (fieldvalue1 !=0) and (fieldvalue2 !=0)
and (fieldvalue3 !=0)
Your original query (implicit INNER JOINs):
SELECT teu.name, eca.owner_id, ece.value
FROM typed_enterprise_unit teu,
e_contact_association eca,
e_contact_entry ece
WHERE teu.unit_id=eca.owner_id
and eca.entry_id=ece.entry_id
and eca.type_id=68
and
Michael,
As was just discussed in this list, non-numeric strings values will also
evaluate to FALSE but if that string starts with a number, it could be
TRUE or FALSE (depending on the actual value of the numeric portion of the
string).
He never explicitly said if those were numerical
--- Michael Stassen [EMAIL PROTECTED] a
écrit :
denys wrote:
SELECT country
FROM Rates
WHERE fieldvalue1 0 AND fieldvalue2 0 AND
fieldvalue3 0
ORDER BY country
is it what you want ?
Gleb Paharenko wrote:
Hello
You may use query like this:
select country
Good point.
Michael
[EMAIL PROTECTED] wrote:
Michael,
As was just discussed in this list, non-numeric strings values will also
evaluate to FALSE but if that string starts with a number, it could be
TRUE or FALSE (depending on the actual value of the numeric portion of the
string).
He never
Hi!
I've got a Mac OS X server with a preinstalled mysql from Apple. My problem
is that I can't find the ini (cnf) file witch the documentation so very
non-windows-friendly shall be located in C:\Windows.
Could anyone please tell me where mysql excpects to find the ini (cnf) file?
Thank you
Bulant Denys wrote:
--- Michael Stassen [EMAIL PROTECTED] a
écrit :
denys wrote:
SELECT country
FROM Rates
WHERE fieldvalue1 0 AND fieldvalue2 0 AND
fieldvalue3 0
ORDER BY country
is it what you want ?
Gleb Paharenko wrote:
Hello
You may use query like this:
select country from
Roland Carlsson wrote:
Hi!
I've got a Mac OS X server with a preinstalled mysql from Apple. My problem
is that I can't find the ini (cnf) file witch the documentation so very
non-windows-friendly shall be located in C:\Windows.
Could anyone please tell me where mysql excpects to find the ini (cnf)
And since 0 is false and every other number is true,
this could be
simplified to
SELECT country
FROM Rates
WHERE fieldvalue1 AND fieldvalue2 AND fieldvalue3
ORDER BY country;
Michael
I will go to bed less fool this evening... Is it just
a clearest way to
Mac OS X is Unix, so you should look at the Unix directions in the manual,
not the Windows directions.
The locations of the option files are documented in the manual
http://dev.mysql.com/doc/mysql/en/Option_files.html. Global options
usually go in /etc/my.cnf, server-specific options go in
The binary logs used for replication set the value used for
autoincrementing before each insert query. The number on the master
will always be replicated properly. If a row already exists with the
autoincrement value, my guess is that replication will die with an
error.
I'm not too sure which
Hello.
The SELECT ... INTO OUTFILE 'file_name' form of SELECT writes the selected
rows to a file. And LOAD DATA INFILE. See:
http://dev.mysql.com/doc/mysql/en/SELECT.html
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
Also you may use mysqldump utility. See:
Hello.
There are no such tips in documentation.
gents,
is there a way to do replication where all database fields
on the slave have the same type, but other names?
i didnt investigate a binary log yet to check how queries are
stored there, but maybe one of you has
Hello.
You may use mysqlhotcopy.
May be it is better to use select ... into outfile and load data infile.
See:
http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
http://dev.mysql.com/doc/mysql/en/SELECT.html
But The Right Way(tm) is using a mysqldump utility.
It is possible to
I have the MySQL first edition book by Paul. Still a great reference.
However, it being a bit outdated I was hoping to get a more current book
and one with more examples, since I learn best by example. The first
book has good examples, but more would still help.
Therefore, I was comparing
I was using myisam tables and converted them to innodb
with Alter table table TYPE=INNODB; A query that used
to take 23 minutes, does not complete in hours. There
about 33M rows in the table and I was doing a count of
the rows. Some queries with more conditions seem fine.
Here is the table:
What you sent is important information to diagnosing your problem but it
would have really helped if you had posted your query along with an
EXPLAIN of it.
Also, it is a WELL KNOWN fact that InnoDB does NOT know exactly how many
rows are in a table at any particular moment (because of the
Hi again,
i have one DB called MY_DATABASE and one table called CUSTOMERS.
What I want is to backup the table customers in another machine in a new
database called MY_DATABASE but the issue is that I want the table to renamed
to CUSTOMERS1
Which means
LOCAL MACHINE - MY_DATABASE - CUSTOMERS
Hello
I have just installed mysql 4.1.7 on Mandrake 10.0 (final).
All went smoothly.
However, when I issue the following command:
/usr/local/mysql/bin/mysqld_safe --user=mysql
I get the error:
Can't create/write to file /root/tmp/ibLmfg7w (Errcode: 13)
When I
Definitely don't give others permission to the /root directory. Try
starting the server like this:
mysqld --tmpdir=/tmp
If that works, then maybe you're putting you tmpdir line under the wrong
group in the my.cnf file or it's being replaced elsewhere.
On Fri, 2004-11-19 at 16:21, Gail Lange
Do you have more than one configuration file? Do you have a my.cnf in
/etc directory and others in /root or in the home directory of the user
mysql which is starting MySQL? Still, the command-line should override
the my.cnf settings.
On Fri, 2004-11-19 at 17:31, Gail Lange wrote:
Hello Spenser
I dug around the archives for this list and I found the message below
from September (http://lists.mysql.com/mysql/172458)
...here is what Marko Makela told me about your situation:
It's probably from innobase_mysql_tmpfile(), which is called two or
three times at startup. That function relies
Jonathan Duncan wrote:
I have the MySQL first edition book by Paul. Still a great reference.
However, it being a bit outdated I was hoping to get a more current book
and one with more examples, since I learn best by example. The first
book has good examples, but more would still help.
Hi Gleb,
is that a no? Not having it in the docs doesnt mean that it is not
possible :)
regards,
heri
- Original Message -
From: Gleb Paharenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, November 19, 2004 4:35 PM
Subject: Re: replication and other col names
Hello.
There
Hello,
I was wondering whether someone could tell me something about
my query-cache statistics (MySQL 4.0.22):
Qcache queries in cache 4479
Qcache inserts 37392
Qcache hits 56994
Qcache lowmem prunes 0
Qcache not cached 24
Qcache free memory 9448968
Qcache free blocks 502
Qcache total
Shiva wrote:
http://www.yohng.com/phpm/phpm.htm#_Toc42628370
Enabling MySQL API support for Microsoft Windows
When running Microsoft Windows, you may run into several issues with PHP
itself and MySQL. While C compiler is an essential part of most POSIX-
compatible operating
Greetings, fellow MySQLers!
I know I ain't doing something right, but I don't know what. Say I have
a website. It has pages on it that get viewed. The hosting company
bills me each day for pages. So..
mysql select * from bill;
++--+
| amount | day |
++--+
| 1.10 | mon
- Original Message -
From: Kevin Cagle [EMAIL PROTECTED]
To: MySql List [EMAIL PROTECTED]
Sent: Saturday, November 20, 2004 10:46 AM
Subject: summing from multiple tables
mysql select sum(amount), sum(totaltimesviewed) from bill, pageviewed;
+-+---+
|
- Original Message -
From: Kevin Cagle [EMAIL PROTECTED]
To: MySql List [EMAIL PROTECTED]
Sent: Friday, November 19, 2004 10:46 PM
Subject: summing from multiple tables
Greetings, fellow MySQLers!
I know I ain't doing something right, but I don't know what. Say I have
a website. It
The solution to your problem is simple: don't attempt to do the final
query.
Each of your existing queries are perfectly fine the way they are and
give
sensible and meaningful answers. Simply run the 3rd and 4th queries as
two
separate queries rather than trying to combine them into one query.
I have the following query:
SELECT A.`AttID` , S.`SessionDate` , P.LastName, P.FirstName, A.`Present`
FROM `Attendance` A, Sessions S, Participants P
WHERE S.SessionID = A.`Session` AND P.Part_ID = A.`Participant`
GROUP BY P.LastName, P.FirstName, A.Present, A.AttID
I would like to have the
59 matches
Mail list logo
