> If this is going to hurt someone please when u
> see mails from [EMAIL PROTECTED] do not
> scroll down to the bottom
I won't. I've had enough of this, so I just set my mail program to erase any
mails from you. I do the same for anyone who repeatedly promotes religious
or political views on the m
;[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; "'Michael Widenius'" <[EMAIL PROTECTED]>
Sent: Thursday, January 09, 2003 7:46 AM
Subject: RE: [OT] Re: InnoDB vs. MySQL performance Issue
ot go to you if you do
nothing.
Sincerely,
Paul Magid, DBA
-Original Message-
From: Sameh Attia [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 08, 2003 1:54 AM
To: [EMAIL PROTECTED]
Subject: [OT] Re: InnoDB vs. MySQL performance Issue
Sam Przyswa wrote:
>Septenber 11 2001,
I know this is a emotive subject but PLEASE drop it from the MySQL list.
Thanks
Simon
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Sam Przyswa wrote:
Septenber 11 2001, more than 3000 women, men, child, killed, Tel Aviv January 5
2003, 23 death and 100 injured by islamic terrorists, that's the islamic history
(small part).
Sam Apache-PHP-MySQL user.
--
"Albert Einstein, Karl Marx, Jesus Christ,
and you Mohamed what have
Sam,
I think now it is time to stop what you have started. If you can't answer the
question then don't waste the time of thousand of users on this list with your
personal opinions and comments on people signatures. You can communicate with
the user directly, not through the list. Other wise it
Maximo Migliari ([EMAIL PROTECTED]) écrivait:
>
>Sameh,
>
>>We r here to help one another solving their problems. Ive never posted any
>>solutions, to this list or another based on religion or something else but
>>the problem itself only. I invite all people here to read the Islamic
>>history of tr
Well, its possible that it took 10 hours to complete the conversion, if the
table was big enough, this could be justified.
20 million records is a lot of records!
Also, don't forget to change the memory settings for InnoDB in my.cnf.
InnoDB is a different table manager to MyISAM, and as such, has
Sameh,
your innodb_buffer_pool_size seems a bit small. In the manual it says:
"Set buffer pool size to 50 - 80 % of your computer's memory, but make
sure on Linux x86 total memory usage is < 2 GB". Your setting means that
you have no more than 256MB RAM and that's not much for operations on
reall
Maximo Migliari wrote:
Sameh,
The right table manager to use (MyISAM or InnoDB) really depends on
the type of work you are requiring of MySQL.
If you are mainly doing selects, and hardly any
updates/deletes/inserts, then MyISAM is faster. Its indexes, as far
as I know, are smaller and more
Sameh,
The right table manager to use (MyISAM or InnoDB) really depends on the
type of work you are requiring of MySQL.
If you are mainly doing selects, and hardly any updates/deletes/inserts,
then MyISAM is faster. Its indexes, as far as I know, are smaller and more
efficient. However, when
Gelu Gogancea wrote:
Hi,
I'm sure that all the people from this list RESPECT in what you believe or
in values which are considered by you to be inviolable/holy.
I'M NOT JEWISH but i'm sure if you will see, like logo/slogan , something
like ...
"I WILL LOVE YOU FOREVER WITH MY HEART AND MY BLOOD,
Hi,
I'm sure that all the people from this list RESPECT in what you believe or
in values which are considered by you to be inviolable/holy.
I'M NOT JEWISH but i'm sure if you will see, like logo/slogan , something
like ...
"I WILL LOVE YOU FOREVER WITH MY HEART AND MY BLOOD, BEN GURION."
... i'm al
Gelu Gogancea ([EMAIL PROTECTED]) écrivait:
>
>Peace to all,
>This is not the right place for this kind of discussions.
>Please STOP.
>Also i have a suggestion for the administrator of this list:
>-to forbidden all e-mail which have in subject or body, logo
>/slogan/catchword which can be considere
lt;[EMAIL PROTECTED]>; "MySQL List"
<[EMAIL PROTECTED]>
Sent: Monday, January 06, 2003 3:28 PM
Subject: Re: InnoDB vs. MySQL performance Issue
Sameh Attia ([EMAIL PROTECTED]) écrivait:
Sam Przyswa wrote:
Sameh Attia ([EMAIL PROTECTED]) écrivait:
"She who
ECTED]>; "MySQL List"
<[EMAIL PROTECTED]>
Sent: Monday, January 06, 2003 3:28 PM
Subject: Re: InnoDB vs. MySQL performance Issue
> Sameh Attia ([EMAIL PROTECTED]) écrivait:
> >
> >
> >
> >
> >
> >
> >
> >
> >Sam Przyswa wrote:
&
Sam Przyswa wrote:
Sameh Attia ([EMAIL PROTECTED]) écrivait:
Sam Przyswa wrote:
Sameh Attia ([EMAIL PROTECTED]) écrivait:
"She who is in my mind and mouth, I love her with all my heart and blood"
We'll restore OUR Palestine
Did you know a democratic country named ISRAEL created i
Sameh Attia ([EMAIL PROTECTED]) écrivait:
>
>
>
>
>
>
>
>
>Sam Przyswa wrote:
>
> Sameh Attia ([EMAIL PROTECTED]) écrivait:
>
>
>"She who is in my mind and mouth, I love her with all my heart and blood"
>We'll restore OUR Palestine
>
>
>
>Did you know a democratic country named ISRAEL created
select crap from blahblah where nobody_is_interested = 'Y'
sql,query
- Original Message -
From: "Sameh Attia" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 06, 2003 7:32 PM
Subject: Re: InnoDB vs. MySQL performance Issue
> Sam Przy
Sameh Attia wrote:
Hi,
I have a system running MySQL 3.23.41. I read many times about
InnoDB performance and that it is superior to the MyISAM one. I have a
table 'sessions' in a MyISAM format with about 20 milion records. Its
size is 2.5 GB; the index file is 1.1 GB. In mysql client I ente
Sam Przyswa wrote:
Sameh Attia ([EMAIL PROTECTED]) écrivait:
"She who is in my mind and mouth, I love her with all my heart and blood"
We'll restore OUR Palestine
Did you know a democratic country named ISRAEL created in 1948 ?
How do u define democratic? country? Israel? created?
B
21 matches
Mail list logo
