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 <=
'
cuments', 'eq_ref', 'id', 'id', 3,
'trafix_sites_00026.logs_2006_11.int_url_strem', 1, 'Using where'
-Original Message-
From: Rolando Edwards [mailto:[EMAIL PROTECTED]
Sent: Monday, November 06, 2006 9:54 AM
To: Francis
int_search tinyint(3) unsigned NOT NULL default '0',
int_platforms smallint(5) unsigned NOT NULL default '0',
int_bots tinyint(3) unsigned NOT NULL default '0',
int_host tinyint(3) unsigned NOT NULL default '0',
UNIQUE KEY `id` (`id`),
KEY ip (`in
, the way I found to optimize " 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
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 u
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 the
tried to change all variables 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 PR
, 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
b_test1.id
FROM tb_test1, tb_test2
WHERE TRIM(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 '; &
1.id
FROM tb_test1, tb_test2
WHERE tb_test1.id='abcde'
AND TRIM(tb_test1.id) = tb_test2.id
Redhat 9, with MYSQL 4.1.1, using UTF8 as default charset.
Any idea?? Thank you.
Francis Mak
r exceeded 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
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 + MY
he DB 100 times. how
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 rando
-TW&lr=&ie=UTF-8&oe=UTF-8&threadm=bkeab
v%241bq6%241%40FreeBSD.csie.NCTU.edu.tw
-Original Message-
From: Wouter van Vliet [mailto:[EMAIL PROTECTED]
Sent: Monday, December 01, 2003 8:16 PM
To: 'Francis Mak'; [EMAIL PROTECTED]
Subject: RE: error 1045 happened
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
'[EMAIL PROTECTED]'"
it happens RANDOMLY.
Could anybody please let me know how to fix this???
Many thanks.
Francis
nrenderable characters for the Thai.
So what do I do about 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]
s
(B 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
long long unsigned int, const iovec*,
(Bint)
(B'
(B
(B>Fix:
(B
(B
(B>Submitter-Id:
(B>Originator:Dennis Francis Tutanes
(B>Organization:
(B
(B
(B>MySQL support: [none | licence | email support | extended email support ]
(Bnone
(B>Synopsi
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
:
//(si
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 Mailin
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
(isb
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)
valu
used
ps to check, 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
;1-03-
> 0D004, then continued to rest of order.
>
> how do I fix this
>
>
you could use
> 01-03-0A00109-03-0D004
>
>
Francis Cooke
**
Please visit the official Grana
ng now: 1
mysqld process hanging, pid 29200 - killed
021107 10:59:44 mysqld restarted
/usr/libexec/mysqld: ready for connections
How-To-Repeat:
make sure mysqld is really dead with killall
safe_mysqld &
mysqldadmin -u root -h Jungles.au --password xx
Fix:
Submitter-Id
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
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> rep
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 a
bz (the GNU
zip 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,
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':
my_compress.o(.text+
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
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
ht
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
Hello,
I'm trying to build MySQL from source.
I've noticed in whether MySQL 3.23.43 or 4.0,
for sql/lex.cc and lex.h --
The source for flex to generate these two files is missing!!
Although the yacc file (sql_yacc.yy) still exists,
I need the lex source because I want to change some
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 Eudor
39 matches
Mail list logo
