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

Re: Mysql Certification exams

On Sun, Jan 3, 2010 at 11:06 PM, machiel.richards 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

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 bu

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: in

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 wrote: > Jeetendra, > > Give the MySQLD user permissions to the new directory which you a

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

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 knowledg

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

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 MySQ

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: in

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.

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 reso

Re: [PHP] Instll php on Window 2003 64Bit questions

On Sun, Jan 3, 2010 at 08:10, 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 > Whi

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, w

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 l

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

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,

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 ve

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 thi

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" wrote in message news:snt102-w5962ed9a8e5cb50a275855cb...@phx.g

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 cHospital