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 MySQL
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
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
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
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
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
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
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
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
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 10/17
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 peak time..
But now the peak
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)
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]
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 the reason why the server hasn't
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
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;
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
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
-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 happened
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,
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
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
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
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
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
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
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)
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 probably the strategy that we would use
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 higher
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
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,
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:
], 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:37 PM
To: Sujay Koduri
Cc
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
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
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
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
@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 to MySQL
hi ,,
we
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
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
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,
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
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:
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.
* This worked absolutely fine.
* I
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
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,
The problem
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 also attached the file
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
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:
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
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 suggest you
a choice, send the list of packets which
you got to the list.
Sujay Koduri [EMAIL PROTECTED] wrote:
OS is RH9 and kernel is 2.4.20
I suggest you send this to the MySQL list :-)
With regards,
Can any one list the steps or give me any pointers how to cleanly
uninstall
an upper version
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
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
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
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
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
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
-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:[EMAIL
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
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:
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 =
the 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]
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
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 go through all the columns, it will take much time
compared
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
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
}
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
68 matches
Mail list logo