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
.
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, more than 3000 women, men, child, killed
PROTECTED]; [EMAIL PROTECTED]; 'Michael Widenius' [EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 7:46 AM
Subject: RE: [OT] Re: InnoDB vs. MySQL performance Issue
To MySQL AB:
Your lists are being used to disseminate extremist muslim hate-speech.
As
such, this will reflect terribly negatively
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
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,
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
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?
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
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 Przyswa wrote:
Sameh Attia ([EMAIL PROTECTED
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 in 1948 ?
How
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 in
: 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 is in my mind and mouth, I love her with all my heart and
blood
We'll
[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 is in my mind and mouth, I love her with all my heart
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 considered
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
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,
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,
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,
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
really
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,
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 true muslims
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 entered the
following
22 matches
Mail list logo
