Hi list,
I have a table with about 17 millons of records. This table
contain log of web for one month and I have an other table but with only
1 day of log.
If I do a select to get the log for this date 2006-01-01 :
Select * from mytable where mydate = '2006-01-01' and mydate =
copy to tmp table is by
spliting the data in my table in multiple tables to lower the size...But
if I do this way, the table counts on my database can go up to 600
tables :S I don't think is a good way to do this.
Ty for your help and sorry for my english...
Francis !
--
MySQL
: Rolando Edwards [mailto:[EMAIL PROTECTED]
Sent: Monday, November 06, 2006 9:02 AM
To: Francis
Cc: MySQL General
Subject: Re: Copy to tmp table optimize
You need to look at the GROUP BY clause
If all the columns from a GROUP BY clause
are not indexed or if the columns in the
GROUP BY clause
, 'Using where'
-Original Message-
From: Rolando Edwards [mailto:[EMAIL PROTECTED]
Sent: Monday, November 06, 2006 9:54 AM
To: Francis
Cc: MySQL General
Subject: Re: Copy to tmp table optimize
As for this part of your query
(
cs_documents.str_url LIKE '%.asp
Hi list,
Question about MyISAM vs InnoDB ? What is the best to use, I have a
large table contain around 10 millons of records. What is the best for me ?
Use MyISAM or InnoDB ?
Ty for reply ☺
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hi,
I have Apache 2, PHP 5 and MySQL 4.1 installed on an XP pro box.
I have created a new database 'ijdb' with a single table 'joke' and have
entered data into two of the three fields in the table.
I can access the database / tables / data from a command prompt, and I can
access and extract
to use utf8, but the problem still
exist.
Is there anybody could help?
Or did I asked the question in a wrong group?
Thank you.
Francis Mak
-Original Message-
From: Francis Mak [mailto:[EMAIL PROTECTED]
Sent: Friday, December 03, 2004 7:42 PM
To: [EMAIL PROTECTED]
Subject: characterset
it, all things become ???
I supspect it is due to the client connection? What config I need to do in
order to make php display correctly?
Please Please!
Thank you very much.
Francis Mak
I'd like to have the data store on a netapp NFS server.
One writer mysql machine, with external-locking, and one (or more)
machines that do read only queries.
Will the read-only machines get consistent data from their queries?
The docs say only Make it easy for yourself: Forget about sharing a
Redhat 9, with MYSQL 4.1.1, using UTF8 as default charset.
Any idea?? Thank you.
Francis Mak
(tb_test1.id)='abcde'
AND tb_test1.id = tb_test2.id
Anybody could explain this?
Thank you.
Francis
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 13, 2004 8:19 PM
To: 'Francis Mak '; '[EMAIL PROTECTED] '
Subject: RE: Cannot do join on varchar
Have
500?
I have a set-variable= default-character-set=utf8 in my.cnf, maybe
this is the cause of error?
And is there way to increase this 500 value? Or I must use InnoDB then?
Mysql 4.1.1, RedHat 9
Thanks.
Francis Mak
RANDOMLY.
Could anybody please let me know how to fix this???
Many thanks.
Francis
Duncan, thanks for your tips. I will give it a try.
so this is a known bug in mysql? and for sure using blank password is not a
long term solutions, what if it is a share hosting env.?
any answer from mysql team?
many thanks.
francis
On Monday 01 December 2003 11:46, Francis Mak wrote
PROTECTED]
Sent: Monday, December 01, 2003 8:16 PM
To: 'Francis Mak'; [EMAIL PROTECTED]
Subject: RE: error 1045 happened randomly
First of all, there was no reason for the flush privileges; call. This is
automatically handled by MySQL when you use the GRANT and REVOKE statements.
Doesn't do any harm
could you monitor the number of hits?? by using what tools?
thank you guys!
-Original Message-
From: Wouter van Vliet [mailto:[EMAIL PROTECTED]
Sent: Monday, December 01, 2003 8:52 PM
To: 'Francis Mak'; [EMAIL PROTECTED]
Subject: RE: error 1045 happened randomly
Yes, I replied quick
am self compiled:
openssl-0.9.7c
-Original Message-
From: Duncan Hill [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 12:02 AM
To: [EMAIL PROTECTED]
Subject: Re: error 1045 happened randomly
On Monday 01 December 2003 11:46, Francis Mak wrote:
I am using PHP4.3.4 + MYSQL
this?
Any help greatly appreciated.
--
John Francis Lee
1/9-10 Thanon Trairat
Muang Chiang Rai 57000
Thailand
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
checking for sys/socket.h... yes
(B
(B/* The messages above also appeared for other *.h files */
(B
(B
(BThank you very much.
(B
$B0J>e!"$h$m$7$/$*4j$$$7$^$9!#(B
(B
(B
(BDennis Francis B. Tutanes
(BProject Leader
(BTsukiden Software Tech
unsigned int, const iovec*,
(Bint)
(B'
(B
(BFix:
(Bhow to correct or work around the problem, if known (multiple lines)
(B
(BSubmitter-Id: submitter ID
(BOriginator:Dennis Francis Tutanes
(BOrganization:
(B organization of PR author (multiple lines)
(B
(BMySQL support
Hi,
This is a PHP issue not MySQL.
If anything got inserted at all it will be blanks for no where in your
code were your variables ('$productid', '$itemname', '$description',
'$price', '$information') defined.
Try this in the productsave.php code right at the TOP after your include
:
I have MySQL version 3.23 on Linux 8.0 . I am trying to do a full text
search IN BOOLEAN MODE and I get an error. If I remove the IN BOOLEAN
MODE option my query runs fine . Does it mean I have to upgrade to 4.0
to use this Search mode? Can somebody please confirm ?
--
MySQL General
I have run this command without Stating IN BOOLEAN MODE and my search goes
fine. However this query returns a Syntax error WHEN IN BOOLEAN MODE
OPTION IS ADDED , can anyone help ?
Table is MyISAM type running on Linux 8.0
SELECT isbn, title, suggestedretail FROM bookscatalogue WHERE MATCH
Hi,
I'm trying to set up a small database server for our students to play
with and ran into problems while creating accounts and granting rights.
I used
insert into user (User, Host, Password,
Insert_priv, Update_priv, Delete_priv,
Create_priv, Drop_priv, Index_priv, Alter_priv)
, and there doesn't appear to be another mysqld running. Any
ideas?
Thanks,
+ + +
Francis Hwang
Director of Technology
Rhizome
212-989-2363
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
.
how do I fix this
you could use
01-03-0A00109-03-0D004
Francis Cooke
**
Please visit the official Granada website at www.granadamedia.com
for the latest company news.
This email and any
--password xx
Fix:
Submitter-Id: Jim Francis submitter ID
Originator: as above
Organization: Corus Consulting
organization of PR author (multiple lines)
MySQL support: none
Synopsis: mysqladmin generates a segmentation error
Severity: critical
Priority: high
Category: mysql
Class: sw-bug
On Thu, 2002-10-10 at 13:23, Sinisa Milivojevic wrote:
Hi!
Our replication developers have recently fixed a bug that looks
conspiciously like the one you reported.
It will come up in 3.23.53 which should come up in 7 - 10 days.
Would you please be so kind to check it out if it still
On Mon, 2002-10-07 at 17:40, Victoria Reznichenko wrote:
MJF One of the machines is simultaneously slave to one server and master to
MJF two others; on that machine, if a RESET MASTER or PURGE MASTER LOGS
MJF is executed while its slave thread is performing a query, mysqld
MJF reproducibly
Hi,
My company runs a moderately large and loaded MySQL replication network
across four Solaris machines. While upgrading from a fairly old 3.23.4x
installation to 3.23.52 we've encountered a problem with replication and
binlog rotation.
One of the machines is simultaneously slave to one server
hi,
i am writting a c program to connect to a mysql db and execute a bunch
of select and update statements. When I try to compile the source it works
properly but during linking i get this error:
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function
`my_uncompress':
compression library). Presumably MySQL now allows
communication between client and server to be compressed
on the fly.
so using -lz as a flag on linking process is the answer
- John
On Mon, 12 Aug 2002, John Francis wrote:
hi,
i am writting a c program
I have a mailing list in Mysql database working very
well; How do I add an ATTACHMENT(files of any type) to
emails going to the addresses in the mailing list
stored in the database?
Thanks
__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
I have a mailing list in Mysql database working very
well; How do I add an ATTACHMENT(files of any type) to
emails going to the addresses in the mailing list
stored in the database?
Thanks
__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
I have a mailing list in Mysql database working very
well; How do I add an ATTACHMENT(files of any type) to
emails going to the addresses in the mailing list
stored in the database?
Regards,
Francis
__
Do You Yahoo!?
LAUNCH
Hello,
This is my first day in this list and i don't know if this was asked before.
Anyway i have this problem when i'm trying to delete a row a mySQL 3.23.38-nt table
using a vb interface and connecting through myODBC 3.51.02 i keep getting this
message :
Row cannot be located for updating.
Hi my names is Francis Pena im trying to compile Mysql-3.23.48, when i
run ./configure is is the result
[jigax@RHL mysql-3.23.48]$ ./conf
loading cache ./config.cache
checking host system type... i686-pc-linux-gnu
checking target system type... i686-pc-linux-gnu
checking build system type
message.
Fatal error: Call to unsupported or undefined function mysql_connect() in
/home/francis/public_html/allresults.php3
on line 11
I need your assistance urgently because I have a deadline.
Yours Sincerely
Francis
Join 18 million Eudora users by signing up for a free Eudora Web-Mail
38 matches
Mail list logo