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
, 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
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
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
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 <=
'
'[EMAIL PROTECTED]'"
it happens 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
-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
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
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
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
, 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
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
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
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
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 '; &
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
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
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
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,
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
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
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
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+
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,
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
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
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
;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
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
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
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
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]
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
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
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
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
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
39 matches
Mail list logo
