Hello folks,
Any way to retrieve the error code/error number from a stored proc.
Scenario
--
calling a stored proc from PHP - using mysqli_multi_query()
The stored proc has multiple queries. Lets say one of the queries generates
an exception.
How do I retrieve the error message w
Hello All,
I set up replication between 2 servers recently. I just need one db to be
replicated and the SHOW SLAVE STATUS shows this:
Relay_Master_Log_File: gyana01-bin.02
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB: tallydb,tallydb
Now the problem is that there is anoth
Hello All,
I need to add a couple of more tables to the list of tables to be replicated
from a particular db in the salve my.cnf.
Can this be done without restarting the mysql server on the slave?
Thanks & regards,
Ratheesh
Hello all,
I cannot afford to stop my slave server. I have list of tables of the master
that are being replicated on the slave.
Now I want to remove a couple of tables from this list without affecting the
master and slave. How is this possible?
Thanks & regards,
Ratheesh
@all,
Currently we run all our complex reporting queries on a different server. We
are not using replication though.
What we are doing is to restore the backup of the live data every night onto
the reporting server. So we are running reports on data that is not real time.
And we are OK with tha
Hello all,
What is the best possible values in my.cnf for a 8 processor (Quad core-2 cpu)
8 GB RAM machine dedicated for MySQL server only. No other application will run
on this machine.
the innodb_buffer_pool_size cannot accept values above 2000 MB due to 32 bit
machine constraint. So what ot
and has been skipped from the relay log?
4.. How do I know immediately that replication has failed? ( have heard that
the enterprise edition has some technique for this )?
Thanks & regards,
Ratheesh
- Original Message -
From: "Jan Kirchhoff" <[EMAIL PROTECTED]>
To: &q
Hello all,
I issued a create table statement on the master for a table which was not
present on the master but present on the slave.
I did this purposely to see the error on slave.
I am a newbie to replication. Now when i see SLave status on the slave machine
it shows that the SQL Thread has st
Hello All,
I just wanted to know whether there are any known issues in defining and using
Foreign key constraints in MySQL 4 and MySQL 5.
To be specific, are there any issues on using ON DELETE CASCADE and ON UPDATE
CASCADE?
Would there be any performance issues when we define Foreign key const
Hello All,
I want a clarification. Whe run a forum wherein people send messages
with/without attachments. Attachments may contain images, documents etc.. We
are actually storing the attachment in a blob column. Sometimes the attachments
are big. And today the table size has grown to 40 GB. This
?
- Original Message -
From: "Chris" <[EMAIL PROTECTED]>
To: "Ratheesh K J" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, May 15, 2007 2:42 PM
Subject: Re: Data security - help required
Ratheesh K J wrote:
Hello all,
I have a requirement of maintaining some secret i
L
rows: 1059133
Extra: Using where
-----
Thanks
Ratheesh K J
M` (`FLD_TICKET_NUM`),
KEY `FLD_MARK_AS_DELETED` (`FLD_MARK_AS_DELETED`),
KEY `FLD_ACC_ID` (`FLD_ACC_ID`),
KEY `FLD_BLOCK_STATE` (`FLD_BLOCK_STATE`),
KEY `FLD_FWD_FLAG` (`FLD_FWD_FLAG`),
KEY `FLD_ISSUE_CLOSED` (`FLD_ISSUE_CLOSED`),
KEY `FLD_REPLY_FLAG` (`FLD_REPLY_FLAG`),
KEY `FLD_SUBJECT` (`FL
age -
From: Alex Arul
To: Ratheesh K J
Sent: Tuesday, January 23, 2007 11:57 AM
Subject: Re: Urgent - MySQL 5 - mysqld using a lot of memory consistently
you threads connected is 38 but your thread cache has only 8. So please do
bump it up. Also generate explain plan on both versio
,
Ratheesh K J
.
Previously(MySQL 4.1.11) Explain showed the usage of primary Key as the index.
How can this be resolved?
Thanks
Ratheesh K J
rrors
as shown in my previous post. But everything seems to be working fine. There
have been no problems accessing the data.
What I can I possibly do to get everything right. How can I correct the log
sequence error?
Should the log files of App server be in the DB server?
Thanks,
Rathees
Hello all,
yesterday we seperated our app server and db server. We moved our 70GB of data
from our app server to a new DB server. We installed MySQL 4.1.11 on the DB
server.
Now the following happened. On the DB server the ibdata1 and all the databases
are the old ones (which were copied from
s)?
What exactly is the difference between the two set of rpms? Where (which
system) are the Linux x86 generic RPM (dynamically linked) rpms installed then?
Thanks,
Ratheesh K J
- Original Message -
From: "Jacques Marneweck" <[EMAIL PROTECTED]>
To: "Ratheesh K J
Hello all,
Just wanted to know what is the difference between
Red Hat Enterprise Linux 3 RPM (x86) downloads and
Linux x86 generic RPM (dynamically linked) downloads
Which one should I download for a RHEL 3 system?
Thanks,
Ratheesh Bhat K J
Hlo,
We have all our tables as Innodb type. As I understand the variable
key_buffer_size is used only for MyISAM tables. Currently we have this var set
to 256M on a 4GB RAM machine. Only the Temporary tables created using (CREATE
TEMPORARY TABLE) will be of MyISAM type. And there are a lot of t
-
From: "Chris" <[EMAIL PROTECTED]>
To: "Ratheesh K J" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, September 27, 2006 12:50 PM
Subject: Re: Mysql Stat - Help required
Ratheesh K J wrote:
Hlo,
I got this Stat of MySQL. I want to know is there something to worry
abou
Hlo,
I got this Stat of MySQL. I want to know is there something to worry about,
especially the number of temp tables.
Key Reads/Key Read Requests = 0.007094 (Cache hit = 99.992906%)
Key Writes/Key Write Requests = 0.239130
Connections/second = 8.741 (/hour = 31467.279)
KB received/second =
Hlo all,
I wanted to move around 50 GB of data on Machine A to Machine B. Both the
machines are of same architecture ( LAMP )
Dumping and restoring takes a lot of time. Is there a faster method to
accomplish the same?
Is there a way to tar the whole thing and untar on Machine B? or any other
Hlo all,
I wanted to move around 50 GB of data on Machine A to Machine B. Both the
machines are of same architecture ( LAMP )
Dumping and restoring takes a lot of time. Is there a faster method to
accomplish the same?
Is there a way to tar the whole thing and untar on Machine B? or any other
hello all,
We do not run transactions at all on our db. All our queries are autocommit. So
what should be the value set to this variable : innodb_flush_log_at_trx_commit
We currently have it set to 1 and all our tables are Innodb. Since we are not
running any transactions at all, is it better t
What is this solidDB? where can i get much info on this??
Thanks,
Ratheesh Bhat K J
hlpful
Thanks
Ratheesh K J
- Original Message -
From: "Brent Baisley" <[EMAIL PROTECTED]>
To: "Ratheesh K J" <[EMAIL PROTECTED]>;
Sent: Monday, August 28, 2006 7:33 PM
Subject: Re: Seperating Application server and Database server
In addition to what the
Hello all,
I need to find out to some point of accuracy the ratio of Number
Inserts/Updates to that of Selects. This is because we are thinking of setting
up a Replication sysytem with one master and one slave. Now replication would
be optimal only if there if the Select queries are dominating,
Hello all,
Currently our application and MySQL server are on the same machine.
When should these be seperated?
What are the main reasons that we should be having a seperate DB server?
Ratheesh Bhat K J
Hello all,
I wanted to know why a select query takes ,say, 18 sec to execute the first
time I execute it and then for every successive execution it takes, say, 10 sec.
I have disabled Query Caching on the server. If its not Query Caching then what
else is causing this variation in exec time?
1
Hello all,
I have a couple of questions on storage engine types wrt performance
1.. Will there be any performance degrade when we do "joins with tables
having different storage engines" ?
2.. Where are the temporary tables created? (by default why not memory
storage engine?) will it be he
Hello All,
I wanted to know what is the best size for Innodb key cache. We are currently
running MySQL 4.1.11
And we have set the buffer size to 1GB.
innodb_buffer_pool_size = 1G
The system has 4 GB RAM.
1) In such a case is the above setting ok?
2) All the tables are of Innodb type
3) We are
Hello All,
Need a suggestion for this:
We have tables which have very few number of rows ( less than 600 ). For a long
period of time the number of rows are going to remain almost the same.
1) Is it better to index the columns of such tables?
2) There are Joins on this table and then a search
Hello all,
I have a doubt on Index Merge.
We are currently using MySQL server 4.1.11. As a part of DB management I am
currently doing an analysis on all the Tables.
While looking into the table structures, their columns and Indexes I found that
most of the tables have an Index on fields that
Hello all,
Another question on cardinality.
Consider a table with 1000 rows and columnns. Details of the columns are as
below:
FLD_1 - int - cardinality 1000 - PRIMARY KEY
FLD_2 - tinyint- cardinality 400
FLD_3 - varchar - cardinality 10
FLD_4 - varchar - cardinality 2
FLD_5 - varchar - ca
Helo all,
Just wanted to know when should a Table be considered for partitioning ( or
should it be archiving ).
Almost all of our tables are of Innodb type. I am looking for an estimate
rather than a "Depends on situation" kind of an answer.
We have few of our table swhich are very huge ( in t
Hello all,
Need an explanation for this:
I did the following -
SELECT DISTINCT COLUMN1 FROM TBL_XXX ;
I got the foll result
1
2
3
4
5
7
8
10
11
12
13
14
16
17
18
19
20
21
23
24
25
26
27
28
29
30
--
Hello all,
Need an explanation on this:
SELECT col1, col2, ...
FROM tbl1 JOIN tbl2 ON (some cond)
JOIN tbl3 ON (some cond)
.
.
.
WHERE
col1 > AND col2 > etc...
Running an EXPLAIN o
Hello all,
Just wanted to know how many columns are preferable in table. At present we are
having nearly 50 - 60 columns in some of the tables. Is this ok or should we be
splitting the tables for normalization.
If we really need to split then how better would it be in terms of performance.?
1
Hello all,
I am required to analyze all the tables of our system. I need to know the key
parameters that should be taken into consideration for analysis. I am not
speaking about ANALYZE TABLE . I am required to manually look into
all table structures and pin point problems ( if any ).
So it wo
Helo all,
I need explanation on EXPLAIN here.
I am trying to JOIN 2 tables TBL1 and TBL2 on TBL1.fld_id = TBL2.fld_id . And
finally I filter out the results that i need in the where clause using
where TBL1.fld_col = 100;
Running an EXPLAIN shows that it is an impossible where condition. This m
Hello all,
Just wanted to know if using IN in the where clause is better than OR in terms
of performance.
that is :
Are these both same in terms of performance
SELECT * FROM TABLE
WHERE ( COLUMN = 1 OR COLUMN = 2 );
SELECT * FROM TABLE
WHERE COLUMN IN ( 1, 2 );
thanks,
Ratheesh Bha
...
Any suggestions would help...
Thanks,
Ratheesh K J
type. Very soon we are planning to use transactions.
Thanks,
Ratheesh K J
by 6 secs rather than 10 secs?
Is this a right strategy to track slow queries?
Any suggestions would help.
Thanks,
Ratheesh K J
46 matches
Mail list logo