RE: Query about MySQL

Hi Raman, >> Is mysql is able to manage this huge amount of data. MySQL does manage this amount of data very easily. >> Can we put this much of data in single table database OR keeping the data in multiple tables is the good practice. You can keep this much amount of data in one single MySQ

RE: Mysql database capacity

I am giving the system configuration which we are using to run MySQL. 2-CPU 4G RAM, SAN filesystem. MySQL version : 4.14 (INNODB) OS : RHEL - 3 Amount of Data : 200G No of Rows : 278 million approximately (Every day 2.5-3 million rows gets added) Transaction rate : 300-400 reads/sec, 110-120 upda

MySQL server Crashed while running a stored proc

hi all, I am executing a stored proc that has a top level cursor to loop over a user set, and then execute certain transactions for each user. After processing about 5 users, it always generates: ERROR 2013 (HY000): Lost connection to MySQL server during query. However, if I restart from the same u

RE: Newbie Query: Error starting MySQL..changed Data Directory

>>Running /etc/rc.d/init.d/mysqld start says that mysql start failed BUT This doesn't nesessarily mean that mysql hasn't started. This script waits only for certain time to check if mysql has started or not. If it is not started in that time, it simply says 'mysql start failed'. But mysql may ta

RE: How do I?

Yes, you can change it at runtime by doing the following SET GLOBAL max_allowed_packet = 1024 (or whatever size); Not only this varaible, whatever variables are listed here http://dev.mysql.com/doc/refman/5.0/en/dynamic-system-variables.html ,you can change them at runtime without restarting the

Pk vs index

hi all.. i have created a table (INNODB) with a primary key column. And all the queries i am running are of the following type only. select col1,col2... from table where primary_key_col = value My question here is will mysql automatically create an index on this column which is having the pr

RE: where is the mistake in this SQL statement?

You havent specified the datatype for the column 'id'. sujay -Original Message- From: Peter Matulis [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 15, 2005 10:57 AM To: mysql@lists.mysql.com Subject: where is the mistake in this SQL statement? { this is a resend, forgot subject in

RE: Multiple MySQL services running on the same machine

I guess you should be able to run multiple instances if you start each instance on a different port. sujay -Original Message- From: Frank Fischer [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 09, 2005 2:17 PM To: mysql@lists.mysql.com Subject: Multiple MySQL services running on t

RE: Datatype conversion

yes..exactly thats what i am planning to do now. Thank you sujay _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, October 17, 2005 7:35 PM To: Sujay Koduri Cc: mysql@lists.mysql.com Subject: Re: Datatype conversion Sujay Koduri <[EMAIL PROTECTED]> wrote on

Datatype conversion

hi all, i have a strange problem here. I have around 600 tables in Oracle DB(On 8i, so i am not able to use mysql migration tool kit!!). Now i want move all of these to mysql. I am initially trying to convert the schema from oracle to mysql. My problem is, in the existing oracle DB, for storing b

RE: Killing a thread -- Urgent

be in Killed state if it is locked by another thread. What version of MySQL do you use? What storage engine does your table have? Sujay Koduri <[EMAIL PROTECTED]> wrot >hi all.. > >I started a select count(1) command on a table in mysql, assuming it >will end soon within the off p

Killing a thread -- Urgent

hi all.. I started a select count(1) command on a table in mysql, assuming it will end soon within the off peak time.. But now the peak load time is about to start, so i tried to kill that query.. logged into mysql as root. show processlist for getting the thread id. kill 85300 (thrad_id) Aft

Lost .frm files

I have changed the OS on my database server. At that time, I forgot to take the backup of the .frm files in /var/lib/mysql. I have taken all the backup of all the data files. I can recreate all the tables. How can I map these tables to existing data files. Is this possible. Please help me out as th

RE: creating socket

Koduri; mysql@lists.mysql.com Subject: Re: creating socket From: "Sujay Koduri" <[EMAIL PROTECTED]> > This error means that the mysql server has not started in the first place. > So try to have a look in the logs (generally this should be in > /var/lib/mysql/) and find out

RE: creating socket

This error means that the mysql server has not started in the first place. So try to have a look in the logs (generally this should be in /var/lib/mysql/) and find out the reason why the server hasn't started. sujay -Original Message- From: Octavian Rasnita [mailto:[EMAIL PROTECTED] Se

RE: A question about stored procedures

Yes you can do this using prepared statements inside stored proc. Guess this helps. http://forums.mysql.com/read.php?98,22770,31459 sujay -Original Message- From: Leonardo Javier Belén [mailto:[EMAIL PROTECTED] Sent: Thursday, October 06, 2005 9:47 PM To: Ryan Stille; mysql@lists.mysq

RE: innodb locking

sujay -Original Message- From: Tony Leake [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 05, 2005 7:55 PM To: Sujay Koduri Cc: mysql@lists.mysql.com Subject: RE: innodb locking On Wed, 2005-10-05 at 07:12 -0700, Sujay Koduri wrote: > Is this happening every time you try this, or it

RE: innodb locking

Is this happening every time you try this, or it happened first time? Yes you right that INNODB uses row level locks, and the only reason for that error should be that someone else is trying to update the same row. As we can see from the o/p of the show procee list, someone else is also trying to

RE: Find username password on tables

Username you can get it from the user table in Mysql. But I don't think atleast after MySQL 4.1 there is a way to retrieve paswords in MySQL as it uses its own encryption algo to encrypt passwords. You have to reset(make that passwd field to null in the mysql.user table) and add a new password(use

RE: timing queries?

If you use source absolute-pathname from mysql command prompt, then it will execute each statement(or line) in the file individually and print the results exactly in the format you are looking for. sujay -Original Message- From: Jacek Becla [mailto:[EMAIL PROTECTED] Sent: Saturday, Octo

RE: How can I access results in a singel dimentional array?

Mysql_store_result stores all the results in a single buffer. But at one time you can only access one row. It is like a array of structures, where each structure has one row info. And the call to mysql_fetch advances this rowcount by one. And coming to storing all the results in one char*, it is a

RE: MySQL Query Browser

I am not saying MysQL Query Browser is anyway bad or inferior, but as for my experience sqlyog is very good. There is a free version which you can use for executing SQL queries, ofcourse you will be stripped of some advanced features. You can run multiple queries at once using shift+F5. I sugges

RE: Global Replace

Yes, I don't think you have to do lot of changes to your application to achieve this. As scott mentioned, always try to keep minimum(whatever is really useful) data in the DB, either for more performance or for using less disk space. sujay -Original Message- From: Scott Noyes [mailto:[EM

RE: Access, ODBC, Oracle, MySQL

September 29, 2005 1:32 AM To: MySQL Subject: Re: Access, ODBC, Oracle, MySQL On Sep 28, 2005, at 2:37 PM, Sujay Koduri wrote: > I don't know how far this is going to help you. But this is what we > are following to migrate from Oracle to MySQL. If we were migrating, that's pro

RE: Access, ODBC, Oracle, MySQL

I don't know how far this is going to help you. But this is what we are following to migrate from Oracle to MySQL. Have a flag keeporacle as long as you want oracle to be in place. Open connection to mysql If (keeporacle) { open connection to oracle also. } if (keepOracle)

RE: MyISAM to InnoDB

[mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 9:04 PM To: 'Sujay Koduri'; mysql@lists.mysql.com Subject: RE: MyISAM to InnoDB > -Original Message- > From: Sujay Koduri [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 28, 2005 11:04 > To: Jeff; mysq

RE: MyISAM to InnoDB

If you think your storage requiremnets will increase in future, try to estimate how much you will be needing in the future in the worst case and try allocating that much of disk space now itself (Any way you have good amount of disk space left). Try creating a different partition for storing the

Foreign key support in MyISAM

does anyone have an idea when mysql guys are going to include foreign key support in myisam tables. i have read that it is slated for a future release, but it is not mentioned when it is actually scheduled for. reference -- http://dev.mysql.com/doc/mysql/en/ansi-diff-foreign-keys.html

RE: Can we run linux commands from inside the msql client

Thanks a ton :) sujay -Original Message- From: David Ziggy Lubowa [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 28, 2005 4:37 PM To: mysql@lists.mysql.com Cc: Sujay Koduri Subject: Re: Can we run linux commands from inside the msql client Yes you can ... e.g mysql>\!

Can we run linux commands from inside the msql client

hi.. I searched the documentation and googled for sometime, but didnt find anything related to this can we execute shell commands inside mysql client (like using ! in oracle), and if possible please tell me how. sujay

RE: Advice Required

What are specifications of your DB. How much of data you have. How mant transactions you will be getting daily. Without these details it will be difficult to answer ur question. But for a centralised database server, I guess 1G RAM and 2CPU will be a good configuration to start with. sujay ---

RE: Avg row length is varying a lot from oracle to MySQL

PROTECTED] Sent: Tuesday, September 27, 2005 3:59 AM To: Sujay Koduri Cc: mysql@lists.mysql.com Subject: Re: Avg row length is varying a lot from oracle to MySQL Sujay Koduri wrote: > we are converting our oracle DB to MySQL DB. One problem i see is that > the abg row length in MySQL is much

RE: MySQL 5.0.13-rc has been released

"release candidate" is just an alias for 'gamma version' of the s/w released from MySQL AB. What he said is that MySQL first gamma version has been released in the 5.0 series. Till now it is in beta phase. sujay -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Tuesday

RE: Multithread handling of Connect/Close

create(&helper[user], NULL, hit_DB, (void *)user); } for (user = 0; user < concurrent_users; user++) { pthread_join(helper[user], NULL); } Hope this helps... sujay -Original Message- From: Lefteris Tsintjelis [mailto:[EMAIL PROTECTED] Sent: Saturday, September 24, 2005 5:3

Multithread handling of Connect/Close

I think mysql does not allow multiple threads to act on the same connection. You have to create a connection pool and pick one for each thread sujay -Original Message- From: Lefteris Tsintjelis [mailto:[EMAIL PROTECTED] Sent: Saturday, September 24, 2005 4:39 PM To: mysql@lists.mysql.

RE: regarding supersmack

I don't think we can change/add datatypes unless you have to play with the code. sujay -Original Message- From: Sreedhar Kharidehal [mailto:[EMAIL PROTECTED] Sent: Friday, September 23, 2005 3:06 PM To: mysql@lists.mysql.com Subject: regarding supersmack Can i generate date type value

RE: Avg row length is varying a lot from oracle to MySQL

mysql@lists.mysql.com Subject: RE: Avg row length is varying a lot from oracle to MySQL > -Original Message- > From: Sujay Koduri [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 22, 2005 15:23 > To: mysql@lists.mysql.com > Subject: Avg row length is varying a lot from oracle

Avg row length is varying a lot from oracle to MySQL

hi ,, we are converting our oracle DB to MySQL DB. One problem i see is that the abg row length in MySQL is much higher compared to that of Oracle. In oracle it is around 180 bytes and in MySQL it is around 686 bytes. So as a result, MySQL is taking more space to store the same number of record

RE: good database design

This is what I am also saying. The effects of a bad logical DB design will effect you the most only in the long term. In the earlier stages you always trust your own design and always look for additional h/w resources to improve the performance. But in the long term you will realize that there is

RE: good database design

My 2 cents.. Before you actually start worrying about the performance tuning of database parameters or hardware required for the DB, you should make sure that you have designed the database properly by taking care of all aspects like normalisation, denormalisation (??). If you don't take care of

RE: Major Difference in response times when using Load Infile uti lity

Hi all, I found that load infile should not take this much time(6 hrs) to load 5.5 million queries. Some people are saying it should not even take more than 10mins. So I think I am doing something wrong in my my.cnf file. I am Using MySQL 4.1.13 version and 2.4.20 kernel on RH9. I am including th

RE: Major Difference in response times when using Load Infile uti lity

Hi I am INNODB tables only. (I have only one big table) Autocommit I have already disabled. And it doesn't have any foreign keys in it. Do I still need to set the FOREIGN_KEY_CHECKS to '0'?? sujay -Original Message- From: Alan Williamson [mailto:[EMAIL PROTECTED] Sent: Tuesday, Septemb

RE: Major Difference in response times when using Load Infile uti lity

Yes, there are indexes on the table. Do you mean to say index is the culprit. sujay -Original Message- From: Peter J Milanese [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 13, 2005 4:58 PM To: Sujay Koduri; mysql Subject: Re: Major Difference in response times when using Load

Major Difference in response times when using Load Infile utility

hi , I am using the Load Infile utility to load data from file to MySQL DB. When trying to load different amounts of data, I observed a notable difference in the time taken by that. Test 1 Amount of data - 5.5 million rows. Time Taken - 6+hrs Approximately. Test2 Amount of data - 0.45 mil

RE: not null values

Use the keyword 'default' to make the attributes default to the values you want. Use some thing like this user_name varchar(50) default 'default_value' not null sujay -Original Message- From: joshua pereira [mailto:[EMAIL PROTECTED] Sent: Monday, August 29, 2005 5:24 PM To: mysql@list

RE: Commit needed even after a select statement ??

Thanks a lot Philippe. Its working. :) sujay -Original Message- From: Philippe Poelvoorde [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 12:43 PM To: 'mysql@lists.mysql.com ' Subject: Re: Commit needed even after a select statement ?? HI, n(say session 2) and updated the entr

RE: Commit needed even after a select statement ??

statement ?? Sujay Koduri wrote: > hi, > > i am using MysQL4.1.13. I tried doing the following. > > * Open a new session to DB. (Say session 1) > * Using prepared statements provided by C API, issued a select > statement to get some rows from a table. > * Thi

Commit needed even after a select statement ??

hi, i am using MysQL4.1.13. I tried doing the following. * Open a new session to DB. (Say session 1) * Using prepared statements provided by C API, issued a select statement to get some rows from a table. * This worked absolutely fine. * I didnt close the session, but sti

RE: prepared statement problems

mysql_list Cc: Sujay Koduri Subject: Re: prepared statement problems Sujay Koduri said the following on 08/18/2005 08:48 AM: Send the code if it is still not working. sujay Not sure what you mean by send the code since it is included at the end of this email. However, I have al

RE: prepared statement problems

Send the code if it is still not working. sujay -Original Message- From: Darrell Cormier [mailto:[EMAIL PROTECTED] Sent: Thursday, August 18, 2005 7:16 PM To: mysql_list Subject: Re: prepared statement problems Sujay Koduri said the following on 08/18/2005 12:31 AM: >Hi, >

RE: prepared statement problems

Hi, The problem here is that you have two input bind variables, but you declaring MysQL BIND array as parm_bind[1], which can hold only one input bind variable. Make it parm_bind[2]. That should work. sujay -Original Message- From: Darrell Cormier [mailto:[EMAIL PROTECTED] Sent: Thurs

RE: Uninstalling the MySQL cleanly.

5 2:58 PM To: mysql@lists.mysql.com Subject: Re: Uninstalling the MySQL cleanly. Hello. I guess you have rpm installation, rpm -e should help you in this case. Find installed mysql packets with `rpm -qa |grep -i mysql` command. If you have troubles with making a choice, send the list of packet

RE: Uninstalling the MySQL cleanly.

Sorry , I didn't send this in person to you intentionally. sujay -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: Thursday, August 11, 2005 2:42 PM To: Sujay Koduri Subject: Re: Uninstalling the MySQL cleanly. . > > OS is RH9 and kernel is 2.4.20 I

Uninstalling the MySQL cleanly.

hi, Can any one list the steps or give me any pointers how to cleanly uninstall an upper version of MySQL, so that after wards if we install lower version it should not be affected by any left overs of the previous installation. Thank you sujay

MySQL C API Version incompatibility

hi, I was connecting to MySQL 5.0.4 through the C API and it was workign fine. But when I downgraded to MYSQL 4.1.13, the same code is giving the following error. mysql_stmt_bind_result() failed Using unsupported buffer type: 0 (parameter: 1) I tried uninstalling all the existing mysql rpm's

RE: my.cnf not found

Thanks a lot stassen :) sujay -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 10, 2005 9:50 PM To: Sujay Koduri Cc: MySQL mailing list Subject: Re: my.cnf not found Sujay Koduri wrote: > hi, > > I tried installing MySQL4.1.13 a

my.cnf not found

hi, I tried installing MySQL4.1.13 and in the process I installed the following packages * MySQL-client-4.1.13-0.i386.rpm * MySQL-server-4.1.13-0.i386.rpm * MySQL-shared-standard-4.1.13-0.rhel3.i386.rpm I am able to make connections to mysql and able to do update,insert,select

Getting the data dictionary in MySQL 4.1.13

Hi, Initially I used MySQL 5.0.4 for all my development. At that time I used the following SQL query to load the whole data dictionary into my local memory to reduce load on DB as I am using the prepared statements API, that requires column types as one of the inputs. select Table_Name,column_n

RE: Please Give me Solution for this

First check whether MySQL server is running on your machine or not. You can use 'ps -aux | grep mysql' for checking this. sujay -Original Message- From: Kumar Gaurav [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 02, 2005 10:31 AM To: mysql@lists.mysql.com Subject: Please Give me Solut

RE: Phone Number Storage

-Original Message- From: Joerg Bruehe [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 26, 2005 1:34 AM To: mysql@lists.mysql.com Cc: Sujay Koduri; Asad Habib Subject: Re: Phone Number Storage Hi! Sujay Koduri wrote (re-ordered): > -Original Message- > From: Asad Habib [mailto:

RE: Phone Number Storage

I think it is better to store the phone numbers as strings only. As phone numbers may also include '-', if you allow entering international numbers, it is good to store them as strings only. Or you can ask the area code and the actual number seperately and store them seperately in two columns as

RE: Prepared statements in MySQL

Hi, Though MySQl initially provided support for Prepared statements in MySQL 5.0, they have removed that support in the later beta versions of MySQL 5.0. Right now MySQL does not recommend using prepared statements inside SP. So it would be better if you go for some work around's like using 'if e

RE: Prepared grant statement?

Yes even I have problems working with stored procs without prepared statements support. It would be great if someone from MySQL team can tell if they have plans to include prepared statements in stored procs in the production release of MySQL5.0. Regards sujay -Original Message- From:

Update not returning any warning on failure

I have a problem working with the stored procs. The stored proc looks like this create procedure unit_swap() BEGIN DECLARE b INT DEFAULT 7; DECLARE c INT; DECLARE CONTINUE HANDLER FOR 1176 SET b = ; DECLARE CONTINUE HANDLER FOR NOT FOUND, SQLEXCEPTION, SQLWARNING SET b = 111

Good book on MySQL 5.0

stable version of MySql 5.0 is going to come out. Thank you sujay Sujay Koduri Project Trainee Andale INDIA pvt Ltd Bangalore -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Number of Rows in DB.

page for a couple of years now on 2 other databases. Mike Sujay Koduri wrote: > hi.. > > > > you can use... > > > > select */count(1) /*from table_name; (it will traverse only column 1) > > > > as count(*) will g

RE: Number of Rows in DB.

hi.. you can use... select count(1) from table_name; (it will traverse only column 1) as count(*) will go through all the columns, it will take much time compared to this which generally will take less time. by the way, can you send the shell script which you are using, it might be

prepared statements in C API not working...headers needed!!

people actually this is a stupid question i suppose..but.. i tried out to run a query from my C program using prepared statements.. It is giving .."undefined reference..".. so anyone who worked on prepared statements can give me the headers that i should include to run them.. Thanx in adva

nawal lodha..u can easily get this i think...

ot;%s %s\n",row[0],row[1]); > 37 } > 38 mysql_free_result(result); > 39 } > 40 > 41 mysql_close(&mysql); > 42 return 0; > 43 }//end of main > > The procedure sujay1() which i am using in my program is > > create procedure sujay1() > begin > select name,species from pet; > end > > > > Thanx > sujay koduri > (plez sent back the corrected one) > I am using.. > > Red hat-9.0 > MySQL - 5.0 > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

stored procedure not returning multiple rows...

s %s\n",row[0],row[1]); 37 } 38 mysql_free_result(result); 39 } 40 41 mysql_close(&mysql); 42 return 0; 43 }//end of main The procedure sujay1() which i am using in my program is create procedure sujay1() begin select name,species from