Re: InnoDB vs. MySQL performance Issue
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 mailing list, whether passively or actively. I subscribe to this list to obtain info on MySQL, not middle-eastern or any other politics. I can read the newspaper for that. Steve. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 on your company if you let this go unchallenged much longer. This individual, if you can call him that, has repeatedly said inflammatory stuff about Israel in his signature. Clearly, no one in an official capacity at your company saw fit to address that. However, now he has equated the Jews and Christians living in [his] lands to pigs and monkeys. This kind of racism is reprehensible in the extreme. This scum is posting his screed from Egypt; I, on the other hand, live in a country which has a much richer tradition of freedom of speech, the United States. And, contrary to this morons assertions, you DO NOT have the right to say anything, at any time, anywhere. And, particularly not in a private forum such as this. There are no first amendment protections from non-governmental actors ie: in this case MySQLAB. Thus, if MySQLAB chooses to do nothing about it your company will be tacitly condoning his behavior. I recommend that at a bare minimum this guy should be removed from the list, for the sheer disruption that he has caused to the normally extremely helpful discourse which is usual in this list. Furthermore, I am a DBA in a Fortune 500 company, and I do have significant influence over the buying decisions of my company with respect to databases. You can be sure that any business I have will not 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, 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 you done for the world ? First of all do not cc me directly. I do get a copy of ur shit by the list. If you think that Mohamed did not do something for the world which is not true. At least he did not leave us with some pigs and monkeys. Read your history if u forgot. If u were a muslim, I thank God that u were not, u would learn how to respect other prophets. We as muslims do repect Jesus, Moses, Ibrahim, and other prohpets and we are asked to believe in them because it is a fundamental believe in our religion. If u want to know more about out prophet Mohamed go and read http://www.islamonline.com/PAGE12.html Also you will find below detailed information about what the modern, democractec, and civilized gang of Zions does to muslims. Israeli Massacres http://www.ummah.net/unity/palestine/index.htm Sabra Shatila http://www.ummah.net/unity/sabra/main.html Deir Yassin http://www.deiryassin.org http://www.ariga.com/peacewatch/dy http://www.us-israel.org/jsource/History/deir_yassin.html Qana http://web.cyberia.net.lb/qana/ .and much more but the memory does not help. Sam go and get a life and may God forgive u. But u should believe that sooner or later there will be no more pigs and monkeys in our lands. -- Sameh Attia Senior System Engineer T.E. Data -- __ __ _ _ _/ /_/ /_(_)___ _ / ___/ __ `/ __/ __/ / __ `/ (__ ) /_/ / /_/ /_/ / /_/ / //\__,_/\__/\__/_/\__,_/ She who is in my mind and mouth, I love her with all my heart and blood We'll restore OUR Palestine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [OT] Re: InnoDB vs. MySQL performance Issue
Hi Paul, MYSQL AB maybe have already done something to diffuse this situation but without to get involved this very-mega-ultra public MYSQL LIST. And i think also is a duty of every member of this list to make all to keep clean this list but without any implication of it. I feel frustration also, because on January 5 2003 two of my townsman(romanians) was killed without any fault by the palestinian terrorist. But we must be rational and must to make difference between our feelings and MYSQL company with all what it is. Maybe it's time to show that the pigs and monkey are able to forgive in comparison with him,witch is man and witch is not able to respect all the members of this list(by making propaganda). If we think that this LISTS belong to MYSQL AB then MYSQL AB is a victim of this disputation.And if MYSQL AB will be have a PUBLIC attitude this means MYSQL AB will be agree with this kind of disputation .Personally, i think THIS NOT A PURPOSE OF MYSQL AB. Anyhow,i think this list belong to all MYSQL users/software developers and in this situation MYSQL AB didn't have ANY FAULT. With all my consideration, Gelu Gogancea Software Developer - System Integrator __ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Paul Magid [EMAIL PROTECTED] To: [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 To MySQL AB: Your lists are being used to disseminate extremist muslim hate-speech. As such, this will reflect terribly negatively on your company if you let this go unchallenged much longer. This individual, if you can call him that, has repeatedly said inflammatory stuff about Israel in his signature. Clearly, no one in an official capacity at your company saw fit to address that. However, now he has equated the Jews and Christians living in [his] lands to pigs and monkeys. This kind of racism is reprehensible in the extreme. This scum is posting his screed from Egypt; I, on the other hand, live in a country which has a much richer tradition of freedom of speech, the United States. And, contrary to this morons assertions, you DO NOT have the right to say anything, at any time, anywhere. And, particularly not in a private forum such as this. There are no first amendment protections from non-governmental actors ie: in this case MySQLAB. Thus, if MySQLAB chooses to do nothing about it your company will be tacitly condoning his behavior. I recommend that at a bare minimum this guy should be removed from the list, for the sheer disruption that he has caused to the normally extremely helpful discourse which is usual in this list. Furthermore, I am a DBA in a Fortune 500 company, and I do have significant influence over the buying decisions of my company with respect to databases. You can be sure that any business I have will not 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, 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 you done for the world ? First of all do not cc me directly. I do get a copy of ur shit by the list. If you think that Mohamed did not do something for the world which is not true. At least he did not leave us with some pigs and monkeys. Read your history if u forgot. If u were a muslim, I thank God that u were not, u would learn how to respect other prophets. We as muslims do repect Jesus, Moses, Ibrahim, and other prohpets and we are asked to believe in them because it is a fundamental believe in our religion. If u want to know more about out prophet Mohamed go and read http://www.islamonline.com/PAGE12.html Also you will find below detailed information about what the modern, democractec, and civilized gang of Zions does to muslims. Israeli Massacres http://www.ummah.net/unity/palestine/index.htm Sabra Shatila http://www.ummah.net/unity/sabra/main.html Deir Yassin http://www.deiryassin.org http://www.ariga.com/peacewatch/dy http://www.us-israel.org/jsource/History/deir_yassin.html Qana http://web.cyberia.net.lb/qana/ .and much more but the memory does not help. Sam go and get a life and may God forgive u. But u should believe that sooner or later there will be no more pigs and monkeys in our lands. -- Sameh Attia Senior
[OT] Re: InnoDB vs. MySQL performance Issue
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 you done for the world ? First of all do not cc me directly. I do get a copy of ur shit by the list. If you think that Mohamed did not do something for the world which is not true. At least he did not leave us with some pigs and monkeys. Read your history if u forgot. If u were a muslim, I thank God that u were not, u would learn how to respect other prophets. We as muslims do repect Jesus, Moses, Ibrahim, and other prohpets and we are asked to believe in them because it is a fundamental believe in our religion. If u want to know more about out prophet Mohamed go and read http://www.islamonline.com/PAGE12.html Also you will find below detailed information about what the modern, democractec, and civilized gang of Zions does to muslims. Israeli Massacres http://www.ummah.net/unity/palestine/index.htm Sabra Shatila http://www.ummah.net/unity/sabra/main.html Deir Yassin http://www.deiryassin.org http://www.ariga.com/peacewatch/dy http://www.us-israel.org/jsource/History/deir_yassin.html Qana http://web.cyberia.net.lb/qana/ .and much more but the memory does not help. Sam go and get a life and may God forgive u. But u should believe that sooner or later there will be no more pigs and monkeys in our lands. -- Sameh Attia Senior System Engineer T.E. Data -- __ __ _ _ _/ /_/ /_(_)___ _ / ___/ __ `/ __/ __/ / __ `/ (__ ) /_/ / /_/ /_/ / /_/ / //\__,_/\__/\__/_/\__,_/ She who is in my mind and mouth, I love her with all my heart and blood We'll restore OUR Palestine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [OT] Re: InnoDB vs. MySQL performance Issue
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 request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB vs. MySQL performance Issue
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 becomes too provoking. P.S I don't expect any reply, but if you insist then no CC to the list. Thanks Salam Baker Sam Przyswa wrote: 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 and youll find that we never treated people based on their religion. All the times nonmuslims get all thier rights under isalmic control. We never kill children, women, unarmed persons...etc 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 you done for the world ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB vs. MySQL performance Issue
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? BTW did u no about a gang founded on 1948? Now this is the end of the subject. This list is not for shit. If still have the motive to continue, join israel.gang.list. Regards sql,query,queries,smallint -- Sameh Attia Senior System Engineer T.E. Data -- __ __ _ _ _/ /_/ /_(_)___ _ / ___/ __ `/ __/ __/ / __ `/ (__ ) /_/ / /_/ /_/ / /_/ / //\__,_/\__/\__/_/\__,_/ She who is in my mind and mouth, I love her with all my heart and blood We'll restore OUR Palestine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB vs. MySQL performance Issue
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 entered the following command 'alter table sessions type=innodb' while these settings were in my.cnf innodb_data_home_dir=/path/to/the/database/dir innodb_data_file_path=backup/ibdata:3072M:autoextend set-variable = innodb_buffer_pool_size=128M set-variable = innodb_additional_mem_pool_size=64M set-variable = innodb_log_file_size=32M set-variable = innodb_log_buffer_size=16M The command took about 10 hours to complete. Is this normal? Also when it finished I issued the follwoing statement on another copy of the table in MyISAM format; it took about 5 mins SELECT ip,no,count(*) AS term,SUM(CEILING(session_time/60)*60) AS total,AVG(CEILING(session_time/60)*60) AS average FROM sessions GROUP BY ip; while when it was issued on the InnoDB one it took me 30 mins to give up and shutdown the server with no luck. Whats wrong? could anyone help? Im sure that InnoDB is good so it seems I missed something could anyone point me? Regards Sorry I forgot to tell that the ibdata file size after conversion is 9.1 GB -- Sameh Attia Senior System Engineer T.E. Data -- __ __ _ _ _/ /_/ /_(_)___ _ / ___/ __ `/ __/ __/ / __ `/ (__ ) /_/ / /_/ /_/ / /_/ / //\__,_/\__/\__/_/\__,_/ She who is in my mind and mouth, I love her with all my heart and blood We'll restore OUR Palestine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB vs. MySQL performance Issue
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]) é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? BTW did u no about a gang founded on 1948? Now this is the end of the subject. This list is not for shit. If still have the motive to continue, join israel.gang.list. Regards sql,query,queries,smallint -- Sameh Attia Senior System Engineer T.E. Data -- __ __ _ _ _/ /_/ /_(_)___ _ / ___/ __ `/ __/ __/ / __ `/ (__ ) /_/ / /_/ /_/ / /_/ / //\__,_/\__/\__/_/\__,_/ She who is in my mind and mouth, I love her with all my heart and blood We'll restore OUR Palestine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 restore OUR Palestine Did you know a democratic country named ISRAEL created in 1948 ? How do u define democratic? country? Israel? created? BTW did u no about a gang founded on 1948? Yes I know, his name is PLO, and in this case Palestine is not a country but a terrorist organisation. 1) Democratic mean that all people, men, women, muslem, jewish, catholics, have the same right instead of arabs countries. 2) Country is like house and have to be build, not destroyed as you have done in Liban, and that you want with ISRAEL. 3) Israel is the only one democratic country in middle east where catholics, muslems, jewish, can leave together instead of yours where jewish, catholics, are killed as in Islamic Republic of Soudan, Irak, Syria, etc. 4) Created means... something that you can't understand because you never have created anything, just destroy as your child transformed in humain bombs. Peace, Country, Democracy, Sharing, lot of things that you will understand when you will become MEN as all of humains peoples, see you in 1000 years ! PS. MySQL is not a toy for you, try MS-SQL instead, I'm sure that Bill Gate himself will be happy to reply your messages with this very nice signature. Sam. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB vs. MySQL performance Issue
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 1948 ? How do u define democratic? country? Israel? created? BTW did u no about a gang founded on 1948? Yes I know, his name is PLO, and in this case Palestine is not a country but a terrorist organisation. 1) Democratic mean that all people, men, women, muslem, jewish, catholics, have the same right instead of arabs countries. 2) Country is like house and have to be build, not destroyed as you have done in Liban, and that you want with ISRAEL. 3) Israel is the only one democratic country in middle east where catholics, muslems, jewish, can leave together instead of yours where jewish, catholics, are killed as in Islamic Republic of Soudan, Irak, Syria, etc. 4) Created means... something that you can't understand because you never have created anything, just destroy as your child transformed in humain bombs. Peace, Country, Democracy, Sharing, lot of things that you will understand when you will become MEN as all of humains peoples, see you in 1000 years ! PS. MySQL is not a toy for you, try MS-SQL instead, I'm sure that Bill Gate himself will be happy to reply your messages with this very nice signature. Sam. well, Ive a problem enjoying my toy. Do u no how to solve or still playing like me? -- Sameh Attia Senior System Engineer T.E. Data -- __ __ _ _ _/ /_/ /_(_)___ _ / ___/ __ `/ __/ __/ / __ `/ (__ ) /_/ / /_/ /_/ / /_/ / //\__,_/\__/\__/_/\__,_/ She who is in my mind and mouth, I love her with all my heart and blood We'll restore OUR Palestine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB vs. MySQL performance Issue
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 RINGLEADER. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Sam Przyswa [EMAIL PROTECTED] To: Sameh Attia [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 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? BTW did u no about a gang founded on 1948? Yes I know, his name is PLO, and in this case Palestine is not a country but a terrorist organisation. 1) Democratic mean that all people, men, women, muslem, jewish, catholics, have the same right instead of arabs countries. 2) Country is like house and have to be build, not destroyed as you have done in Liban, and that you want with ISRAEL. 3) Israel is the only one democratic country in middle east where catholics, muslems, jewish, can leave together instead of yours where jewish, catholics, are killed as in Islamic Republic of Soudan, Irak, Syria, etc. 4) Created means... something that you can't understand because you never have created anything, just destroy as your child transformed in humain bombs. Peace, Country, Democracy, Sharing, lot of things that you will understand when you will become MEN as all of humains peoples, see you in 1000 years ! PS. MySQL is not a toy for you, try MS-SQL instead, I'm sure that Bill Gate himself will be happy to reply your messages with this very nice signature. Sam. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB vs. MySQL performance Issue
Gelu Gogancea wrote: 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 RINGLEADER. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Sam Przyswa [EMAIL PROTECTED] To: Sameh Attia [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 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? BTW did u no about a gang founded on 1948? Yes I know, his name is PLO, and in this case Palestine is not a country but a terrorist organisation. 1) Democratic mean that all people, men, women, muslem, jewish, catholics, have the same right instead of arabs countries. 2) Country is like house and have to be build, not destroyed as you have done in Liban, and that you want with ISRAEL. 3) Israel is the only one democratic country in middle east where catholics, muslems, jewish, can leave together instead of yours where jewish, catholics, are killed as in Islamic Republic of Soudan, Irak, Syria, etc. 4) Created means... something that you can't understand because you never have created anything, just destroy as your child transformed in humain bombs. Peace, Country, Democracy, Sharing, lot of things that you will understand when you will become MEN as all of humains peoples, see you in 1000 years ! PS. MySQL is not a toy for you, try MS-SQL instead, I'm sure that Bill Gate himself will be happy to reply your messages with this very nice signature. Sam. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Ive already done that. I asked about a solution to my problem. -- Sameh Attia Senior System Engineer T.E. Data -- __ __ _ _ _/ /_/ /_(_)___ _ / ___/ __ `/ __/ __/ / __ `/ (__ ) /_/ / /_/ /_/ / /_/ / //\__,_/\__/\__/_/\__,_/ She who is in my mind and mouth, I love her with all my heart and blood We'll restore OUR Palestine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB vs. MySQL performance Issue
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 RINGLEADER. It will be nice, thanks in advance. Sam. sql,query,queries,smallint - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB vs. MySQL performance Issue
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 almost sure that you will feel frustration...and THIS IS NOT RIGHT. For this reason please remove your logo from the bottom of your e-mail body and after this i'm sure all people which are subscribed to this list will try to find a solution for your problem(maybe and SAM). Personally, i beg you to repost your problem to the list because i didn't catch the e-mail where is described your problem. Best Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] Ive already done that. I asked about a solution to my problem. -- Sameh Attia Senior System Engineer T.E. Data -- __ __ _ _ _/ /_/ /_(_)___ _ / ___/ __ `/ __/ __/ / __ `/ (__ ) /_/ / /_/ /_/ / /_/ / //\__,_/\__/\__/_/\__,_/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB vs. MySQL performance Issue
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, BEN GURION. ... i'm almost sure that you will feel frustration...and THIS IS NOT RIGHT. For this reason please remove your logo from the bottom of your e-mail body and after this i'm sure all people which are subscribed to this list will try to find a solution for your problem(maybe and SAM). Personally, i beg you to repost your problem to the list because i didn't catch the e-mail where is described your problem. Best Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] Ive already done that. I asked about a solution to my problem. -- Sameh Attia Senior System Engineer T.E. Data -- __ __ _ _ _/ /_/ /_(_)___ _ / ___/ __ `/ __/ __/ / __ `/ (__ ) /_/ / /_/ /_/ / /_/ / //\__,_/\__/\__/_/\__,_/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php 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 and youll find that we never treated people based on their religion. All the times nonmuslims get all thier rights under isalmic control. We never kill children, women, unarmed persons...etc So I think it is my right to sign my mails with any signature I see apropriate for myself. If this is going to hurt someone please when u see mails from [EMAIL PROTECTED] do not scroll down to the bottom of the mail because u will see my signature sitting over there. And now back to my problem 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 command 'alter table sessions type=innodb' while these settings were in my.cnf innodb_data_home_dir=/path/to/the/database/dir innodb_data_file_path=backup/ibdata:3072M:autoextend set-variable = innodb_buffer_pool_size=128M set-variable = innodb_additional_mem_pool_size=64M set-variable = innodb_log_file_size=32M set-variable = innodb_log_buffer_size=16M The command took about 10 hours to complete. Is this normal? Also when it finished I issued the follwoing statement on another copy of the table in MyISAM format; it took about 5 mins SELECT ip,no,count(*) AS term,SUM(CEILING(session_time/60)*60) AS total,AVG(CEILING(session_time/60)*60) AS average FROM sessions GROUP BY ip; while when it was issued on the InnoDB one it took me 30 mins to give up and shutdown the server with no luck. Also the ibdata file is now 9.1 GB Whats wrong? could anyone help? Im sure that InnoDB is good so it seems I missed something could anyone point me? Regards -- Sameh Attia Senior System Engineer T.E. Data -- __ __ _ _ _/ /_/ /_(_)___ _ / ___/ __ `/ __/ __/ / __ `/ (__ ) /_/ / /_/ /_/ / /_/ / //\__,_/\__/\__/_/\__,_/ She who is in my mind and mouth, I love her with all my heart and blood We'll restore OUR Palestine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB vs. MySQL performance Issue
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 you start doing a little bit more inserts and updates, MyISAM starts to bog down your system. This is because MyISAM locks the entire table in order to perform a modification on it, only after the modification is commited does MySQL unlock the tables for read/write. InnoDB on the other hand, does row-level locking. This means when a record is being updated/inserted/deleted, only the relevant row is locked, and the table can still be concurrently read and insert/update/delete operations can still take place for other rows. This can majourly increase the speed of a database if there is big mix of queries. If you are working on something simple, and don't make too many inserts/updates/deletes, then MyISAM is best, as it takes almost twice as less space to store the data - and as you should know, the more data there is, the longer it takes for the physical hard drive to seek up the data and spit it out to MySQL. Hope this helps! Maximo Migliari. At 19:28 6/1/2003 +0200, you wrote: 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, BEN GURION. ... i'm almost sure that you will feel frustration...and THIS IS NOT RIGHT. For this reason please remove your logo from the bottom of your e-mail body and after this i'm sure all people which are subscribed to this list will try to find a solution for your problem(maybe and SAM). Personally, i beg you to repost your problem to the list because i didn't catch the e-mail where is described your problem. Best Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] Ive already done that. I asked about a solution to my problem. -- Sameh Attia Senior System Engineer T.E. Data -- __ __ _ _ _/ /_/ /_(_)___ _ / ___/ __ `/ __/ __/ / __ `/ (__ ) /_/ / /_/ /_/ / /_/ / //\__,_/\__/\__/_/\__,_/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php 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 and youll find that we never treated people based on their religion. All the times nonmuslims get all thier rights under isalmic control. We never kill children, women, unarmed persons...etc So I think it is my right to sign my mails with any signature I see apropriate for myself. If this is going to hurt someone please when u see mails from [EMAIL PROTECTED] do not scroll down to the bottom of the mail because u will see my signature sitting over there. And now back to my problem 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 command 'alter table sessions type=innodb' while these settings were in my.cnf innodb_data_home_dir=/path/to/the/database/dir innodb_data_file_path=backup/ibdata:3072M:autoextend set-variable = innodb_buffer_pool_size=128M set-variable = innodb_additional_mem_pool_size=64M set-variable = innodb_log_file_size=32M set-variable = innodb_log_buffer_size=16M The command took about 10 hours to complete. Is this normal? Also when it finished I issued the follwoing statement on another copy of the table in MyISAM format; it took about 5 mins SELECT ip,no,count(*) AS term,SUM(CEILING(session_time/60)*60) AS total,AVG(CEILING(session_time/60)*60) AS average FROM sessions GROUP BY ip; while when it was issued on the InnoDB one it took me 30 mins to give up and shutdown the server with no luck. Also the ibdata file is now 9.1 GB Whats wrong? could anyone help? Im sure that InnoDB is good so it seems I missed something could anyone point me? Regards -- Sameh Attia Senior System Engineer T.E. Data -- __ __ _ _ _/ /_/ /_(_)___ _ / ___/ __ `/ __/ __/ / __ `/
Re: InnoDB vs. MySQL performance Issue
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 efficient. However, when you start doing a little bit more inserts and updates, MyISAM starts to bog down your system. This is because MyISAM locks the entire table in order to perform a modification on it, only after the modification is commited does MySQL unlock the tables for read/write. InnoDB on the other hand, does row-level locking. This means when a record is being updated/inserted/deleted, only the relevant row is locked, and the table can still be concurrently read and insert/update/delete operations can still take place for other rows. This can majourly increase the speed of a database if there is big mix of queries. If you are working on something simple, and don't make too many inserts/updates/deletes, then MyISAM is best, as it takes almost twice as less space to store the data - and as you should know, the more data there is, the longer it takes for the physical hard drive to seek up the data and spit it out to MySQL. Hope this helps! Maximo Migliari. At 19:28 6/1/2003 +0200, you wrote: 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, BEN GURION. ... i'm almost sure that you will feel frustration...and THIS IS NOT RIGHT. For this reason please remove your logo from the bottom of your e-mail body and after this i'm sure all people which are subscribed to this list will try to find a solution for your problem(maybe and SAM). Personally, i beg you to repost your problem to the list because i didn't catch the e-mail where is described your problem. Best Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] Ive already done that. I asked about a solution to my problem. -- Sameh Attia Senior System Engineer T.E. Data -- __ __ _ _ _/ /_/ /_(_)___ _ / ___/ __ `/ __/ __/ / __ `/ (__ ) /_/ / /_/ /_/ / /_/ / //\__,_/\__/\__/_/\__,_/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php 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 and youll find that we never treated people based on their religion. All the times nonmuslims get all thier rights under isalmic control. We never kill children, women, unarmed persons...etc So I think it is my right to sign my mails with any signature I see apropriate for myself. If this is going to hurt someone please when u see mails from [EMAIL PROTECTED] do not scroll down to the bottom of the mail because u will see my signature sitting over there. And now back to my problem 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 command 'alter table sessions type=innodb' while these settings were in my.cnf innodb_data_home_dir=/path/to/the/database/dir innodb_data_file_path=backup/ibdata:3072M:autoextend set-variable = innodb_buffer_pool_size=128M set-variable = innodb_additional_mem_pool_size=64M set-variable = innodb_log_file_size=32M set-variable = innodb_log_buffer_size=16M The command took about 10 hours to complete. Is this normal? Also when it finished I issued the follwoing statement on another copy of the table in MyISAM format; it took about 5 mins SELECT ip,no,count(*) AS term,SUM(CEILING(session_time/60)*60) AS total,AVG(CEILING(session_time/60)*60) AS average FROM sessions GROUP BY ip; while when it was issued on the InnoDB one it took me 30 mins to give up and shutdown the server with no luck. Also the ibdata file is now 9.1 GB Whats wrong? could anyone help? Im sure that InnoDB is good so it seems I missed something could anyone point me? Regards -- Sameh Attia Senior System Engineer T.E. Data -- __ __ _ _ _/ /_/
Re: InnoDB vs. MySQL performance Issue
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 big files. Best regards, Thomas Spahni On Mon, 6 Jan 2003, Sameh Attia wrote: 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 command 'alter table sessions type=innodb' while these settings were in my.cnf innodb_data_home_dir=/path/to/the/database/dir innodb_data_file_path=backup/ibdata:3072M:autoextend set-variable = innodb_buffer_pool_size=128M set-variable = innodb_additional_mem_pool_size=64M set-variable = innodb_log_file_size=32M set-variable = innodb_log_buffer_size=16M The command took about 10 hours to complete. Is this normal? Also when it finished I issued the follwoing statement on another copy of the table in MyISAM format; it took about 5 mins SELECT ip,no,count(*) AS term,SUM(CEILING(session_time/60)*60) AS total,AVG(CEILING(session_time/60)*60) AS average FROM sessions GROUP BY ip; while when it was issued on the InnoDB one it took me 30 mins to give up and shutdown the server with no luck. Also the ibdata file is now 9.1 GB Whats wrong? could anyone help? Im sure that InnoDB is good so it seems I missed something could anyone point me? Regards - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB vs. MySQL performance Issue
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 its own memory settings... so if you convert everything to InnoDB, allocate more memory to it, and less memory to MyISAM. Maximo. At 20:05 6/1/2003 +0200, you wrote: 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 efficient. However, when you start doing a little bit more inserts and updates, MyISAM starts to bog down your system. This is because MyISAM locks the entire table in order to perform a modification on it, only after the modification is commited does MySQL unlock the tables for read/write. InnoDB on the other hand, does row-level locking. This means when a record is being updated/inserted/deleted, only the relevant row is locked, and the table can still be concurrently read and insert/update/delete operations can still take place for other rows. This can majourly increase the speed of a database if there is big mix of queries. If you are working on something simple, and don't make too many inserts/updates/deletes, then MyISAM is best, as it takes almost twice as less space to store the data - and as you should know, the more data there is, the longer it takes for the physical hard drive to seek up the data and spit it out to MySQL. Hope this helps! Maximo Migliari. Thanx for ur help. But does the size enlarge by this amount? Also what about the time 10 hours I got to convert the table? -- Sameh Attia Senior System Engineer T.E. Data - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB vs. MySQL performance Issue
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 and youll find that we never treated people based on their religion. All the times nonmuslims get all thier rights under isalmic control. We never kill children, women, unarmed persons...etc 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 you done for the world ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
