Re: Render row without duplicates
Hi , Thanks* *SELECT * FROM (SELECT cHospital FROM MED_PATIENT where cHospital is not null union select cHospital1 from med_patient where cHospital1 is not null union select cHospital2 from med_patient where cHospital2 is not null ) A order by 1 cHospitalhttp://localhost/phpmyadmin/sql.php?db=medicaltable=med_patientsql_query=SELECT+%2A+FROM+%28SELECT+cHospital+FROM+MED_PATIENT+where+cHospital+is+not+null+union+select+cHospital1+from+med_patient+where+cHospital1+is+not+null+union+select+cHospital2+from+med_patient+where+cHospital2+is+not+null+%29A+ORDER+BY+%60A%60.%60cHospital%60+ASCtoken=160eb1977a91a41f90271414c107d1c5 [image: Edit]http://localhost/phpmyadmin/tbl_change.php?db=medicaltable=med_patientprimary_key=.%60cHospital%60+%3D+%27%27clause_is_unique=0sql_query=SELECT+cHospital2+from+med_patient+goto=sql.phptoken=160eb1977a91a41f90271414c107d1c5 [image: Delete]http://localhost/phpmyadmin/sql.php?db=medicaltable=med_patientsql_query=DELETE+FROM+%60medical%60.%60med_patient%60+WHERE+.%60cHospital%60+%3D+%27%27+LIMIT+1zero_rows=The+row+has+been+deletedgoto=sql.php%3Fdb%3Dmedical%26table%3Dmed_patient%26sql_query%3DSELECT%2BcHospital2%2Bfrom%2Bmed_patient%2B%26zero_rows%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_sql.php%26token%3D160eb1977a91a41f90271414c107d1c5token=160eb1977a91a41f90271414c107d1c5 [image: Edit]http://localhost/phpmyadmin/tbl_change.php?db=medicaltable=med_patientprimary_key=.%60cHospital%60+%3D+%271234%27clause_is_unique=0sql_query=SELECT+cHospital2+from+med_patient+goto=sql.phptoken=160eb1977a91a41f90271414c107d1c5 [image: Delete]http://localhost/phpmyadmin/sql.php?db=medicaltable=med_patientsql_query=DELETE+FROM+%60medical%60.%60med_patient%60+WHERE+.%60cHospital%60+%3D+%271234%27+LIMIT+1zero_rows=The+row+has+been+deletedgoto=sql.php%3Fdb%3Dmedical%26table%3Dmed_patient%26sql_query%3DSELECT%2BcHospital2%2Bfrom%2Bmed_patient%2B%26zero_rows%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_sql.php%26token%3D160eb1977a91a41f90271414c107d1c5token=160eb1977a91a41f90271414c107d1c5 1234[image: Edit]http://localhost/phpmyadmin/tbl_change.php?db=medicaltable=med_patientprimary_key=.%60cHospital%60+%3D+%278524%27clause_is_unique=0sql_query=SELECT+cHospital2+from+med_patient+goto=sql.phptoken=160eb1977a91a41f90271414c107d1c5 [image: Delete]http://localhost/phpmyadmin/sql.php?db=medicaltable=med_patientsql_query=DELETE+FROM+%60medical%60.%60med_patient%60+WHERE+.%60cHospital%60+%3D+%278524%27+LIMIT+1zero_rows=The+row+has+been+deletedgoto=sql.php%3Fdb%3Dmedical%26table%3Dmed_patient%26sql_query%3DSELECT%2BcHospital2%2Bfrom%2Bmed_patient%2B%26zero_rows%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_sql.php%26token%3D160eb1977a91a41f90271414c107d1c5token=160eb1977a91a41f90271414c107d1c5 8524 I dont want the Null row , how to remove the null display , Thanks On Sat, Jan 2, 2010 at 11:38 PM, bharani kumar bharanikumariyer...@gmail.com wrote: Hi First i want to thanks to my mysql groups, Sorry , just now i find time to see mail, Am not sure, but i guess this union solves my problem, But let me check it, give me a time..plz On Sat, Jan 2, 2010 at 7:24 PM, Jim Lyons jlyons4...@gmail.com wrote: Your table structure makes the SQL a little inelegant, but I'd say this would give you what you seem to want: select Hospital1Code from tab where Hospital1Code is not null union select Hospital2Code from tab where Hospital2Code is not null union select Hospital3Code from tab where Hospital3Code is not null The union will eliminate duplicates. Maybe this would be better select * from ( select Hospital1Code from tab where Hospital1Code is not null union select Hospital2Code from tab where Hospital2Code is not null union select Hospital3Code from tab where Hospital3Code is not null ) A order by 1 Jim On Sat, Jan 2, 2010 at 6:43 AM, bharani kumar bharanikumariyer...@gmail.com wrote: Hi My fields something like hospital1,hospital2,hospital3,patientname, Exact table look like PatientName Hospital1Code Hospital2Code Hospital3Code Bharani 1234NULL NULL Kumar 56781234 NULL Senthil9632 56758524 John 1234 4567 8524 Can u tell me the query which return output like , HospitalID 1234 5678 9632 5675 8524 4567 8524 Constraint are 1. No Duplicate records, 2.One single column as Output Result , This query purpose is , i have around 1000 patients in my DB, Each patient may have one,two,three hospital code,that's y the field are hospital1,hosptial2,hospital3, i know , i can display all hospital code with unique , but i dont in the single column , with unique record, Can you tell me how to do this ? Thanks -- Jim Lyons Web developer / Database administrator
Re: Getting the sum() for a column from a joined table
Thank you for this solution. It is working, although I was hoping that it could be possible to do it without sub-selects because I want to implement it in an ORM that doesn't fully supports sub-selects yet. -- Octavian LIU YAN liuy...@live.com wrote in message news:snt102-w5962ed9a8e5cb50a275855cb...@phx.gbl... hi , Octavian you can try this SQL. = select agents.id, agents.name, (select count(*) from clients where agent=agents.id), (select sum(value) from sales where agent=agents.id) from agents where agent.id=100 = best regards ACMAIN To: mysql@lists.mysql.com From: orasn...@gmail.com Subject: Getting the sum() for a column from a joined table Date: Sun, 3 Jan 2010 01:35:49 +0200 Hi, I have 3 tables, `agents`, `clients` and `sales` and I want to select a single agent from the `agents` table, and 2 more columns that contain the number of clients for the selected user (from the `clients` table) and the sum of the sales for the selected user (from the `sales` table). Is it possible to do this selection in a single query? I have tried using: select agents.id, agents.name, count(clients.name), sum(sales.value) from agents left join clients on agents.id=clients.agent, left join sales on agents.id=sales.agent where agent.id=100 group by clients.agent, sales.agent; But it doesn't give good results. The sum of sales is bigger than it should be... kind of multiplied with the number of clients that match, like if there were no group by columns specified. I have tried to group by more other columns like clients.id and sales.id or agents.id, but with no good results. Thank you for your help. Octavian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=liuy...@live.com _ Keep your friends updated¡ªeven when you¡¯re not signed in. http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_5:092010 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
High Overhead On Active Insert And Delete Table
Hi list, I have a table which is very active in operation INSERT INTO and DELETE, approximately there will be around 2millions INSERT and DELETE operation per day. And I see the overhead is getting very high, I must do OPTIMIZE TABLE query every time. Is there any other option to solve this? TIA. Willy sangpr...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: High Overhead On Active Insert And Delete Table
Hi Willy, What is the engine you are using for the table? Paste the table structure. Thanks, Suresh Kuna --Original Message-- From: Willy Mularto To: mysql@lists.mysql.com Subject: High Overhead On Active Insert And Delete Table Sent: Jan 3, 2010 4:22 PM Hi list, I have a table which is very active in operation INSERT INTO and DELETE, approximately there will be around 2millions INSERT and DELETE operation per day. And I see the overhead is getting very high, I must do OPTIMIZE TABLE query every time. Is there any other option to solve this? TIA. Willy sangpr...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com Sent from BlackBerry® on Airtel
Re: High Overhead On Active Insert And Delete Table
The engine is using MyISAM. And here is the structure:
CREATE TABLE IF NOT EXISTS `ie_push` (
`sql_id` bigint(20) NOT NULL auto_increment,
`momt` enum('MO','MT','DLR') default NULL,
`sender` varchar(20) default NULL,
`receiver` varchar(20) default NULL,
`udhdata` blob,
`msgdata` text,
`time` bigint(20) default NULL,
`smsc_id` varchar(255) default NULL,
`service` varchar(255) default NULL,
`account` varchar(255) default NULL,
`id` bigint(20) default NULL,
`sms_type` bigint(20) default NULL,
`mclass` bigint(20) default NULL,
`mwi` bigint(20) default NULL,
`coding` bigint(20) default NULL,
`compress` bigint(20) default NULL,
`validity` bigint(20) default NULL,
`deferred` bigint(20) default NULL,
`dlr_mask` bigint(20) default NULL,
`dlr_url` varchar(255) default NULL,
`pid` bigint(20) default NULL,
`alt_dcs` bigint(20) default NULL,
`rpi` bigint(20) default NULL,
`charset` varchar(255) default NULL,
`boxc_id` varchar(255) default NULL,
`binfo` varchar(255) default NULL,
`priority` tinyint(4) default NULL,
`custom` varchar(255) default NULL,
`additional` varchar(255) default NULL,
`service_id` varchar(50) default NULL,
`fid` varchar(50) default NULL,
`msgid` varchar(50) default NULL,
`insertdate` datetime default NULL,
PRIMARY KEY (`sql_id`),
KEY `momt` (`momt`),
KEY `sender` (`sender`),
KEY `receiver` (`receiver`),
KEY `time` (`time`),
KEY `service` (`service`),
KEY `account` (`account`),
KEY `id` (`id`),
KEY `sms_type` (`sms_type`),
KEY `mclass` (`mclass`),
KEY `mwi` (`mwi`),
KEY `coding` (`coding`),
KEY `compress` (`compress`),
KEY `validity` (`validity`),
KEY `deferred` (`deferred`),
KEY `dlr_mask` (`dlr_mask`),
KEY `dlr_url` (`dlr_url`),
KEY `pid` (`pid`),
KEY `rpi` (`rpi`),
KEY `alt_dcs` (`alt_dcs`),
KEY `charset` (`charset`),
KEY `boxc_id` (`boxc_id`),
KEY `binfo` (`binfo`),
KEY `priority` (`priority`),
KEY `custom` (`custom`),
KEY `additional` (`additional`),
KEY `service_id` (`service_id`),
KEY `insertdate` (`insertdate`),
KEY `fid` (`fid`),
KEY `msgid` (`msgid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Willy
sangpr...@gmail.com
On Jan 3, 2010, at 6:00 PM, sureshkumar...@gmail.com wrote:
Hi Willy,
What is the engine you are using for the table? Paste the table
structure.
Thanks,
Suresh Kuna
--Original Message--
From: Willy Mularto
To: mysql@lists.mysql.com
Subject: High Overhead On Active Insert And Delete Table
Sent: Jan 3, 2010 4:22 PM
Hi list,
I have a table which is very active in operation INSERT INTO and
DELETE, approximately there will be around 2millions INSERT and DELETE
operation per day. And I see the overhead is getting very high, I must
do OPTIMIZE TABLE query every time. Is there any other option to solve
this? TIA.
Willy
sangpr...@gmail.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
Sent from BlackBerry® on Airtel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: High Overhead On Active Insert And Delete Table
My first impression after looking at the table structure is
1 the number of indexes present are very huge and each insert or delete will
act as an extra insert or delete of each and every index created.
2 what type of select stmts are going to hit this table.
3 if it is a primary key select, drop all the remaining indexes.
4 as it is myisam, enable the concurrent insert value to 2, so it insert at the
last and do periodic analyze or optimize.
5 the final option is de normalization.
Thanks,
Suresh Kuna
Sent from BlackBerry® on Airtel
-Original Message-
From: Willy Mularto sangpr...@gmail.com
Date: Sun, 3 Jan 2010 18:12:08
To: sureshkumar...@gmail.com
Cc: mysql@lists.mysql.com
Subject: Re: High Overhead On Active Insert And Delete Table
The engine is using MyISAM. And here is the structure:
CREATE TABLE IF NOT EXISTS `ie_push` (
`sql_id` bigint(20) NOT NULL auto_increment,
`momt` enum('MO','MT','DLR') default NULL,
`sender` varchar(20) default NULL,
`receiver` varchar(20) default NULL,
`udhdata` blob,
`msgdata` text,
`time` bigint(20) default NULL,
`smsc_id` varchar(255) default NULL,
`service` varchar(255) default NULL,
`account` varchar(255) default NULL,
`id` bigint(20) default NULL,
`sms_type` bigint(20) default NULL,
`mclass` bigint(20) default NULL,
`mwi` bigint(20) default NULL,
`coding` bigint(20) default NULL,
`compress` bigint(20) default NULL,
`validity` bigint(20) default NULL,
`deferred` bigint(20) default NULL,
`dlr_mask` bigint(20) default NULL,
`dlr_url` varchar(255) default NULL,
`pid` bigint(20) default NULL,
`alt_dcs` bigint(20) default NULL,
`rpi` bigint(20) default NULL,
`charset` varchar(255) default NULL,
`boxc_id` varchar(255) default NULL,
`binfo` varchar(255) default NULL,
`priority` tinyint(4) default NULL,
`custom` varchar(255) default NULL,
`additional` varchar(255) default NULL,
`service_id` varchar(50) default NULL,
`fid` varchar(50) default NULL,
`msgid` varchar(50) default NULL,
`insertdate` datetime default NULL,
PRIMARY KEY (`sql_id`),
KEY `momt` (`momt`),
KEY `sender` (`sender`),
KEY `receiver` (`receiver`),
KEY `time` (`time`),
KEY `service` (`service`),
KEY `account` (`account`),
KEY `id` (`id`),
KEY `sms_type` (`sms_type`),
KEY `mclass` (`mclass`),
KEY `mwi` (`mwi`),
KEY `coding` (`coding`),
KEY `compress` (`compress`),
KEY `validity` (`validity`),
KEY `deferred` (`deferred`),
KEY `dlr_mask` (`dlr_mask`),
KEY `dlr_url` (`dlr_url`),
KEY `pid` (`pid`),
KEY `rpi` (`rpi`),
KEY `alt_dcs` (`alt_dcs`),
KEY `charset` (`charset`),
KEY `boxc_id` (`boxc_id`),
KEY `binfo` (`binfo`),
KEY `priority` (`priority`),
KEY `custom` (`custom`),
KEY `additional` (`additional`),
KEY `service_id` (`service_id`),
KEY `insertdate` (`insertdate`),
KEY `fid` (`fid`),
KEY `msgid` (`msgid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Willy
sangpr...@gmail.com
On Jan 3, 2010, at 6:00 PM, sureshkumar...@gmail.com wrote:
Hi Willy,
What is the engine you are using for the table? Paste the table
structure.
Thanks,
Suresh Kuna
--Original Message--
From: Willy Mularto
To: mysql@lists.mysql.com
Subject: High Overhead On Active Insert And Delete Table
Sent: Jan 3, 2010 4:22 PM
Hi list,
I have a table which is very active in operation INSERT INTO and
DELETE, approximately there will be around 2millions INSERT and DELETE
operation per day. And I see the overhead is getting very high, I must
do OPTIMIZE TABLE query every time. Is there any other option to solve
this? TIA.
Willy
sangpr...@gmail.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com
Sent from BlackBerry® on Airtel
Re: Render row without duplicates
The sql command does eliminate nulls, that's what the clause where ... is not null does. It appears you have an application that is rendering the results so I would check the application to see if it is somehow putting a null row on the screen. Or when you copied the SQL into your program you left out one of the conditions. Try running the command in a stand-alone program, like the mysql interactive program on SQLYOG. Also, the following SQL gives the same result but is a little simpler. The derived table is unnecessary: select Hospital1Code from tab where Hospital1Code is not null union select Hospital2Code from tab where Hospital2Code is not null union select Hospital3Code from tab where Hospital3Code is not null order by 1 Jim On Sun, Jan 3, 2010 at 2:50 AM, bharani kumar bharanikumariyer...@gmail.com wrote: Hi , Thanks* *SELECT * FROM (SELECT cHospital FROM MED_PATIENT where cHospital is not null union select cHospital1 from med_patient where cHospital1 is not null union select cHospital2 from med_patient where cHospital2 is not null ) A order by 1 cHospitalhttp://localhost/phpmyadmin/sql.php?db=medicaltable=med_patientsql_query=SELECT+%2A+FROM+%28SELECT+cHospital+FROM+MED_PATIENT+where+cHospital+is+not+null+union+select+cHospital1+from+med_patient+where+cHospital1+is+not+null+union+select+cHospital2+from+med_patient+where+cHospital2+is+not+null+%29A+ORDER+BY+%60A%60.%60cHospital%60+ASCtoken=160eb1977a91a41f90271414c107d1c5 [image: Edit]http://localhost/phpmyadmin/tbl_change.php?db=medicaltable=med_patientprimary_key=.%60cHospital%60+%3D+%27%27clause_is_unique=0sql_query=SELECT+cHospital2+from+med_patient+goto=sql.phptoken=160eb1977a91a41f90271414c107d1c5 [image: Delete]http://localhost/phpmyadmin/sql.php?db=medicaltable=med_patientsql_query=DELETE+FROM+%60medical%60.%60med_patient%60+WHERE+.%60cHospital%60+%3D+%27%27+LIMIT+1zero_rows=The+row+has+been+deletedgoto=sql.php%3Fdb%3Dmedical%26table%3Dmed_patient%26sql_query%3DSELECT%2BcHospital2%2Bfrom%2Bmed_patient%2B%26zero_rows%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_sql.php%26token%3D160eb1977a91a41f90271414c107d1c5token=160eb1977a91a41f90271414c107d1c5 [image: Edit]http://localhost/phpmyadmin/tbl_change.php?db=medicaltable=med_patientprimary_key=.%60cHospital%60+%3D+%271234%27clause_is_unique=0sql_query=SELECT+cHospital2+from+med_patient+goto=sql.phptoken=160eb1977a91a41f90271414c107d1c5 [image: Delete]http://localhost/phpmyadmin/sql.php?db=medicaltable=med_patientsql_query=DELETE+FROM+%60medical%60.%60med_patient%60+WHERE+.%60cHospital%60+%3D+%271234%27+LIMIT+1zero_rows=The+row+has+been+deletedgoto=sql.php%3Fdb%3Dmedical%26table%3Dmed_patient%26sql_query%3DSELECT%2BcHospital2%2Bfrom%2Bmed_patient%2B%26zero_rows%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_sql.php%26token%3D160eb1977a91a41f90271414c107d1c5token=160eb1977a91a41f90271414c107d1c5 1234[image: Edit]http://localhost/phpmyadmin/tbl_change.php?db=medicaltable=med_patientprimary_key=.%60cHospital%60+%3D+%278524%27clause_is_unique=0sql_query=SELECT+cHospital2+from+med_patient+goto=sql.phptoken=160eb1977a91a41f90271414c107d1c5 [image: Delete]http://localhost/phpmyadmin/sql.php?db=medicaltable=med_patientsql_query=DELETE+FROM+%60medical%60.%60med_patient%60+WHERE+.%60cHospital%60+%3D+%278524%27+LIMIT+1zero_rows=The+row+has+been+deletedgoto=sql.php%3Fdb%3Dmedical%26table%3Dmed_patient%26sql_query%3DSELECT%2BcHospital2%2Bfrom%2Bmed_patient%2B%26zero_rows%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_sql.php%26token%3D160eb1977a91a41f90271414c107d1c5token=160eb1977a91a41f90271414c107d1c5 8524 I dont want the Null row , how to remove the null display , Thanks On Sat, Jan 2, 2010 at 11:38 PM, bharani kumar bharanikumariyer...@gmail.com wrote: Hi First i want to thanks to my mysql groups, Sorry , just now i find time to see mail, Am not sure, but i guess this union solves my problem, But let me check it, give me a time..plz On Sat, Jan 2, 2010 at 7:24 PM, Jim Lyons jlyons4...@gmail.com wrote: Your table structure makes the SQL a little inelegant, but I'd say this would give you what you seem to want: select Hospital1Code from tab where Hospital1Code is not null union select Hospital2Code from tab where Hospital2Code is not null union select Hospital3Code from tab where Hospital3Code is not null The union will eliminate duplicates. Maybe this would be better select * from ( select Hospital1Code from tab where Hospital1Code is not null union select Hospital2Code from tab where Hospital2Code is not null union select Hospital3Code from tab where Hospital3Code is not null ) A order by 1 Jim On Sat, Jan 2, 2010 at 6:43 AM, bharani kumar bharanikumariyer...@gmail.com wrote: Hi My fields something like hospital1,hospital2,hospital3,patientname, Exact table look like PatientName Hospital1Code Hospital2Code Hospital3Code
Re: [PHP] Instll php on Window 2003 64Bit questions
There are instructions on the Microsoft IIS site on installing php as well. http://php.iis.net/ Bilal On Sun, 2010-01-03 at 14:15 +, Ashley Sheridan wrote: On Sun, 2010-01-03 at 15:10 +0800, Edward S.P. Leong wrote: Dear All, If the OS is Windows 2003 64Bit (IIS)... So, which php package must download and how to config it for running with IIS ? Due to I don't quite the online manual: http://www.php.net/manual/en/install.windows.iis.php Which installation mode is suitable of it ? Thanks ! Edward. Personally I'd go with a WAMP install instead. Apache is faster, less resource intensive, and more secure than IIS. You also have the benefit of all the Apache mods out there, like mod_rewrite, which I believe you'd have to pay for on an IIS server. Thanks, Ash http://www.ashleysheridan.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: [PHP] Instll php on Window 2003 64Bit questions
On Sun, Jan 3, 2010 at 08:10, Edward S.P. Leong edward...@ita.org.mo wrote: Dear All, If the OS is Windows 2003 64Bit (IIS)... So, which php package must download and how to config it for running with IIS ? Due to I don't quite the online manual: http://www.php.net/manual/en/install.windows.iis.php Which installation mode is suitable of it ? Thanks ! Edward. Do you mean which of the two IIS installation guides in the manual you should follow? IIS7 is from Windows Vista (or Windows Server 2008) and up, so you would have to go with the first link. So you can download the PHP 5.3.1 VC9 non-thread-safe build from http://windows.php.net and follow the steps in http://www.php.net/manual/en/install.windows.iis6.php. -- Daniel Egeberg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
innodb_data_file_path
Hi, I am using MySQL 5.0.85-community on Fedora 8. When i set innodb_data_home_dir = innodb_data_file_path = /dev/sda3:10Gnewraw;/dev/sda1:5Gnewraw and restart the server it gives an error Starting MySQL.Manager of pid-file quit without updating file.[FAILED] Please suggest how to resolve this issue ? Thanks Jeetendra Ranjan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: innodb_data_file_path
Hi Jeetendra, What is the error it it saying in error log ? Is this the fresh installation or already installed MySQL ? Thanks Suresh Kuna MySQL DBA On Mon, Jan 4, 2010 at 10:16 AM, Jeetendra Ranjan jeetendra.ran...@sampatti.com wrote: Hi, I am using MySQL 5.0.85-community on Fedora 8. When i set innodb_data_home_dir = innodb_data_file_path = /dev/sda3:10Gnewraw;/dev/sda1:5Gnewraw and restart the server it gives an error Starting MySQL.Manager of pid-file quit without updating file.[FAILED] Please suggest how to resolve this issue ? Thanks Jeetendra Ranjan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com -- Thanks, Suresh Kuna
Re: innodb_data_file_path
Thanks Suresh for your response. MySQL is already installed and will update you with the error log details. Thanks Jeetendra Ranjan - Original Message - From: Suresh Kuna To: Jeetendra Ranjan Cc: mysql@lists.mysql.com Sent: Monday, January 04, 2010 10:28 AM Subject: Re: innodb_data_file_path Hi Jeetendra, What is the error it it saying in error log ? Is this the fresh installation or already installed MySQL ? Thanks Suresh Kuna MySQL DBA On Mon, Jan 4, 2010 at 10:16 AM, Jeetendra Ranjan jeetendra.ran...@sampatti.com wrote: Hi, I am using MySQL 5.0.85-community on Fedora 8. When i set innodb_data_home_dir = innodb_data_file_path = /dev/sda3:10Gnewraw;/dev/sda1:5Gnewraw and restart the server it gives an error Starting MySQL.Manager of pid-file quit without updating file.[FAILED] Please suggest how to resolve this issue ? Thanks Jeetendra Ranjan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com -- Thanks, Suresh Kuna
Re: innodb_data_file_path
Hi Suresh, The error log show the related error as below InnoDB: File name /dev/sda3 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. 100102 1:18:32 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=ip-xx-xx-xx-xx-bin' to avoid this problem. 100102 1:18:32 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. Thanks Jeetendra Ranjan - Original Message - From: Suresh Kuna To: Jeetendra Ranjan Cc: mysql@lists.mysql.com Sent: Monday, January 04, 2010 10:28 AM Subject: Re: innodb_data_file_path Hi Jeetendra, What is the error it it saying in error log ? Is this the fresh installation or already installed MySQL ? Thanks Suresh Kuna MySQL DBA On Mon, Jan 4, 2010 at 10:16 AM, Jeetendra Ranjan jeetendra.ran...@sampatti.com wrote: Hi, I am using MySQL 5.0.85-community on Fedora 8. When i set innodb_data_home_dir = innodb_data_file_path = /dev/sda3:10Gnewraw;/dev/sda1:5Gnewraw and restart the server it gives an error Starting MySQL.Manager of pid-file quit without updating file.[FAILED] Please suggest how to resolve this issue ? Thanks Jeetendra Ranjan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com -- Thanks, Suresh Kuna
Re: innodb_data_file_path
Jeetendra, Give the MySQLD user permissions to the new directory which you are specifying. On Mon, Jan 4, 2010 at 10:57 AM, Jeetendra Ranjan jeetendra.ran...@sampatti.com wrote: Hi Suresh, The error log show the related error as below InnoDB: File name /dev/sda3 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. 100102 1:18:32 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=ip-xx-xx-xx-xx-bin' to avoid this problem. 100102 1:18:32 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. Thanks Jeetendra Ranjan - Original Message - *From:* Suresh Kuna sureshkumar...@gmail.com *To:* Jeetendra Ranjan jeetendra.ran...@sampatti.com *Cc:* mysql@lists.mysql.com *Sent:* Monday, January 04, 2010 10:28 AM *Subject:* Re: innodb_data_file_path Hi Jeetendra, What is the error it it saying in error log ? Is this the fresh installation or already installed MySQL ? Thanks Suresh Kuna MySQL DBA On Mon, Jan 4, 2010 at 10:16 AM, Jeetendra Ranjan jeetendra.ran...@sampatti.com wrote: Hi, I am using MySQL 5.0.85-community on Fedora 8. When i set innodb_data_home_dir = innodb_data_file_path = /dev/sda3:10Gnewraw;/dev/sda1:5Gnewraw and restart the server it gives an error Starting MySQL.Manager of pid-file quit without updating file.[FAILED] Please suggest how to resolve this issue ? Thanks Jeetendra Ranjan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com -- Thanks, Suresh Kuna -- Thanks Suresh Kuna MySQL DBA
Mysql Certification exams
Good day all I hope that someone can help me out with some resources. Due to lack of interest my MySQL training was cancelled in December. However I need to get certified (MySQL DBA) ASAP and need to do this on book knowledge and a bit of experience alone. Due to the cost for the exams I cannot afford to fail any one of the two exams. I am trying to get hold of sample exams, etc... that I can use for preparation to the exams in order to test myself and make sure that I have all the knowledge I need. Does anybody know where I can look for these? Regards Machiel
Re: Mysql Certification exams
Hi , Look dummies , look mysql basic's, not sure, but google with keyword mysql dump On Mon, Jan 4, 2010 at 11:36 AM, machiel.richards machiel.richa...@gmail.com wrote: Good day all I hope that someone can help me out with some resources. Due to lack of interest my MySQL training was cancelled in December. However I need to get certified (MySQL DBA) ASAP and need to do this on book knowledge and a bit of experience alone. Due to the cost for the exams I cannot afford to fail any one of the two exams. I am trying to get hold of sample exams, etc... that I can use for preparation to the exams in order to test myself and make sure that I have all the knowledge I need. Does anybody know where I can look for these? Regards Machiel -- Regards B.S.Bharanikumar http://php-mysql-jquery.blogspot.com/
Re: innodb_data_file_path
Hi Jeetendra, Check the below url for details with the raw partition. http://dev.mysql.com/doc/refman/5.4/en/innodb-raw-devices.html Thanks Suresh Kuna MySQL DBA On Mon, Jan 4, 2010 at 11:06 AM, Suresh Kuna sureshkumar...@gmail.comwrote: Jeetendra, Give the MySQLD user permissions to the new directory which you are specifying. On Mon, Jan 4, 2010 at 10:57 AM, Jeetendra Ranjan jeetendra.ran...@sampatti.com wrote: Hi Suresh, The error log show the related error as below InnoDB: File name /dev/sda3 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. 100102 1:18:32 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=ip-xx-xx-xx-xx-bin' to avoid this problem. 100102 1:18:32 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. Thanks Jeetendra Ranjan - Original Message - *From:* Suresh Kuna sureshkumar...@gmail.com *To:* Jeetendra Ranjan jeetendra.ran...@sampatti.com *Cc:* mysql@lists.mysql.com *Sent:* Monday, January 04, 2010 10:28 AM *Subject:* Re: innodb_data_file_path Hi Jeetendra, What is the error it it saying in error log ? Is this the fresh installation or already installed MySQL ? Thanks Suresh Kuna MySQL DBA On Mon, Jan 4, 2010 at 10:16 AM, Jeetendra Ranjan jeetendra.ran...@sampatti.com wrote: Hi, I am using MySQL 5.0.85-community on Fedora 8. When i set innodb_data_home_dir = innodb_data_file_path = /dev/sda3:10Gnewraw;/dev/sda1:5Gnewraw and restart the server it gives an error Starting MySQL.Manager of pid-file quit without updating file.[FAILED] Please suggest how to resolve this issue ? Thanks Jeetendra Ranjan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com -- Thanks, Suresh Kuna -- Thanks Suresh Kuna MySQL DBA -- Thanks Suresh Kuna MySQL DBA
Re: innodb_data_file_path
Hi Suresh, Thanks, this link we already have but it has no information right from creating the raw disk partition. Jeetendra Ranjan - Original Message - From: Suresh Kuna To: Jeetendra Ranjan Cc: mysql@lists.mysql.com Sent: Monday, January 04, 2010 12:12 PM Subject: Re: innodb_data_file_path Hi Jeetendra, Check the below url for details with the raw partition. http://dev.mysql.com/doc/refman/5.4/en/innodb-raw-devices.html Thanks Suresh Kuna MySQL DBA On Mon, Jan 4, 2010 at 11:06 AM, Suresh Kuna sureshkumar...@gmail.com wrote: Jeetendra, Give the MySQLD user permissions to the new directory which you are specifying. On Mon, Jan 4, 2010 at 10:57 AM, Jeetendra Ranjan jeetendra.ran...@sampatti.com wrote: Hi Suresh, The error log show the related error as below InnoDB: File name /dev/sda3 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. 100102 1:18:32 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=ip-xx-xx-xx-xx-bin' to avoid this problem. 100102 1:18:32 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. Thanks Jeetendra Ranjan - Original Message - From: Suresh Kuna To: Jeetendra Ranjan Cc: mysql@lists.mysql.com Sent: Monday, January 04, 2010 10:28 AM Subject: Re: innodb_data_file_path Hi Jeetendra, What is the error it it saying in error log ? Is this the fresh installation or already installed MySQL ? Thanks Suresh Kuna MySQL DBA On Mon, Jan 4, 2010 at 10:16 AM, Jeetendra Ranjan jeetendra.ran...@sampatti.com wrote: Hi, I am using MySQL 5.0.85-community on Fedora 8. When i set innodb_data_home_dir = innodb_data_file_path = /dev/sda3:10Gnewraw;/dev/sda1:5Gnewraw and restart the server it gives an error Starting MySQL.Manager of pid-file quit without updating file.[FAILED] Please suggest how to resolve this issue ? Thanks Jeetendra Ranjan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com -- Thanks, Suresh Kuna -- Thanks Suresh Kuna MySQL DBA -- Thanks Suresh Kuna MySQL DBA
Re: innodb_data_file_path
Try this : /dev/sda3:10Graw;/dev/sda1:5Graw Change the newraw to raw and start the MySQL. and paste the error log ouput. Thanks Suresh Kuna MySQL DBA On Mon, Jan 4, 2010 at 12:37 PM, Jeetendra Ranjan jeetendra.ran...@sampatti.com wrote: Hi Suresh, Thanks, this link we already have but it has no information right from creating the raw disk partition. Jeetendra Ranjan - Original Message - *From:* Suresh Kuna sureshkumar...@gmail.com *To:* Jeetendra Ranjan jeetendra.ran...@sampatti.com *Cc:* mysql@lists.mysql.com *Sent:* Monday, January 04, 2010 12:12 PM *Subject:* Re: innodb_data_file_path Hi Jeetendra, Check the below url for details with the raw partition. http://dev.mysql.com/doc/refman/5.4/en/innodb-raw-devices.html Thanks Suresh Kuna MySQL DBA On Mon, Jan 4, 2010 at 11:06 AM, Suresh Kuna sureshkumar...@gmail.comwrote: Jeetendra, Give the MySQLD user permissions to the new directory which you are specifying. On Mon, Jan 4, 2010 at 10:57 AM, Jeetendra Ranjan jeetendra.ran...@sampatti.com wrote: Hi Suresh, The error log show the related error as below InnoDB: File name /dev/sda3 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. 100102 1:18:32 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=ip-xx-xx-xx-xx-bin' to avoid this problem. 100102 1:18:32 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. Thanks Jeetendra Ranjan - Original Message - *From:* Suresh Kuna sureshkumar...@gmail.com *To:* Jeetendra Ranjan jeetendra.ran...@sampatti.com *Cc:* mysql@lists.mysql.com *Sent:* Monday, January 04, 2010 10:28 AM *Subject:* Re: innodb_data_file_path Hi Jeetendra, What is the error it it saying in error log ? Is this the fresh installation or already installed MySQL ? Thanks Suresh Kuna MySQL DBA On Mon, Jan 4, 2010 at 10:16 AM, Jeetendra Ranjan jeetendra.ran...@sampatti.com wrote: Hi, I am using MySQL 5.0.85-community on Fedora 8. When i set innodb_data_home_dir = innodb_data_file_path = /dev/sda3:10Gnewraw;/dev/sda1:5Gnewraw and restart the server it gives an error Starting MySQL.Manager of pid-file quit without updating file.[FAILED] Please suggest how to resolve this issue ? Thanks Jeetendra Ranjan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com -- Thanks, Suresh Kuna -- Thanks Suresh Kuna MySQL DBA -- Thanks Suresh Kuna MySQL DBA -- Thanks Suresh Kuna MySQL DBA
Re: Mysql Certification exams
On Sun, Jan 3, 2010 at 11:06 PM, machiel.richards machiel.richa...@gmail.com wrote: I am trying to get hold of sample exams, etc... that I can use for preparation to the exams in order to test myself and make sure that I have all the knowledge I need. I have passed all the 5.0 dev and dba exams as well as 5.1 cluster. Buy the official guides and read them well: http://www.amazon.com/MySQL-5-0-Certification-Study-Guide/dp/0672328127 That has all the information you need and practice exam questions. The certification exams are not that hard if you work with MySQL consistently and read through the guide. -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: innodb_data_file_path
This is the second step and before that we have to stop the server and set the parameter in my.cnf innodb_data_home_dir = innodb_data_file_path = /dev/sda3:10Gnewraw;/dev/sda1:5Gnewraw and when i restart the server it is giving error Starting MySQL.Manager of pid-file quit without updating file.[FAILED] - Original Message - From: Suresh Kuna To: Jeetendra Ranjan Cc: mysql@lists.mysql.com Sent: Monday, January 04, 2010 12:45 PM Subject: Re: innodb_data_file_path Try this : /dev/sda3:10Graw;/dev/sda1:5Graw Change the newraw to raw and start the MySQL. and paste the error log ouput. Thanks Suresh Kuna MySQL DBA On Mon, Jan 4, 2010 at 12:37 PM, Jeetendra Ranjan jeetendra.ran...@sampatti.com wrote: Hi Suresh, Thanks, this link we already have but it has no information right from creating the raw disk partition. Jeetendra Ranjan - Original Message - From: Suresh Kuna To: Jeetendra Ranjan Cc: mysql@lists.mysql.com Sent: Monday, January 04, 2010 12:12 PM Subject: Re: innodb_data_file_path Hi Jeetendra, Check the below url for details with the raw partition. http://dev.mysql.com/doc/refman/5.4/en/innodb-raw-devices.html Thanks Suresh Kuna MySQL DBA On Mon, Jan 4, 2010 at 11:06 AM, Suresh Kuna sureshkumar...@gmail.com wrote: Jeetendra, Give the MySQLD user permissions to the new directory which you are specifying. On Mon, Jan 4, 2010 at 10:57 AM, Jeetendra Ranjan jeetendra.ran...@sampatti.com wrote: Hi Suresh, The error log show the related error as below InnoDB: File name /dev/sda3 InnoDB: File operation call: 'open'. InnoDB: Cannot continue operation. 100102 1:18:32 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=ip-xx-xx-xx-xx-bin' to avoid this problem. 100102 1:18:32 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. Thanks Jeetendra Ranjan - Original Message - From: Suresh Kuna To: Jeetendra Ranjan Cc: mysql@lists.mysql.com Sent: Monday, January 04, 2010 10:28 AM Subject: Re: innodb_data_file_path Hi Jeetendra, What is the error it it saying in error log ? Is this the fresh installation or already installed MySQL ? Thanks Suresh Kuna MySQL DBA On Mon, Jan 4, 2010 at 10:16 AM, Jeetendra Ranjan jeetendra.ran...@sampatti.com wrote: Hi, I am using MySQL 5.0.85-community on Fedora 8. When i set innodb_data_home_dir = innodb_data_file_path = /dev/sda3:10Gnewraw;/dev/sda1:5Gnewraw and restart the server it gives an error Starting MySQL.Manager of pid-file quit without updating file.[FAILED] Please suggest how to resolve this issue ? Thanks Jeetendra Ranjan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com -- Thanks, Suresh Kuna -- Thanks Suresh Kuna MySQL DBA -- Thanks Suresh Kuna MySQL DBA -- Thanks Suresh Kuna MySQL DBA
