Please check out http://q4m.31tools.com/*. *It is a message queue storage
engine with sql interface. Havent used it in a production setup though we
did some tests.
--
Thanks
Alex
http://alexlurthu.wordpress.com
I would also add Baron's maakit http://www.maatkit.org/ ( innotop ) for
innodb details to the arsenal.
On Fri, Jun 20, 2008 at 3:11 PM, Ian Simpson [EMAIL PROTECTED] wrote:
I tend to use the 'mytop' program, which shows the average
queries/second for the entire lifetime and for the last 5
Please check if the my.cnf configurations to be the same.
What are your configuration parameters in terms of innodh flush log trx
commit , bin logging, sync binlog and innodb unsafe for binlog ?
If the systems have raid, check if the BBWC is enabled on the new host and
WB is enabled.
On Fri,
Variable_name: sync_binlog
Value: 0
Variable_name: innodb_locks_unsafe_for_binlog
Value: OFF
Thanks
--
Ian Simpson
On Fri, 2008-06-13 at 17:43 +0530, Alex Arul Lurthu wrote:
Please check if the my.cnf configurations to be the same.
What are your configuration parameters
The new server, which is just trying to handle replication
Device: tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn
sda 77.83 1367.55 2914.72 358474084 764029986
Thanks,
--
Ian Simpson
On Fri, 2008-06-13 at 19:15 +0530, Alex Arul Lurthu wrote:
also how often do you issue a commit. batching
Chain replication is fine as long as reading stale data from the last slave
in your chain is ok. the staleness depends on the write throughput and
capacity of the intermediate slaves. But Chain replication with circular
replication is a definite no no in prod since if any intermediate fails, you
How about looking at the .frm file of the table.
On 11/28/07, Richard Edward Horner [EMAIL PROTECTED] wrote:
FYI, this did not work :)
Thanks though!
Rich(ard)
On Nov 23, 2007 3:37 AM, Paul McCullagh [EMAIL PROTECTED]
wrote:
Maybe this will work:
SHOW CREATE TABLE table_name;
You can set pager command to grep out unwanted fields.
On 11/28/07, bruce [EMAIL PROTECTED] wrote:
hi..
simple question!!
mysql show slave status
returns a number of fields, with information on the status of the slave. is
there a way to only return the field(s) i'm interested in...
i
The second query might be faster due to caching.
On 11/26/07, Alexander Bespalov [EMAIL PROTECTED] wrote:
Hi,
I have a problem with SELECT speed. The first execution takes up to several
minutes while the next (with the same statement) takes not more then several
seconds.
The statement
The checksum errors might be due to various reasons. We had similar issue
where we restored the database multiple times, replaced the ram sticks
nothing helped. Finally we drilled down the issue to the chassis. Recommend
testing the restore on a different machine to rule out any hardware issue.
stop slave;
change master to master_log_file='Relay_Master_Log_File' ,
master_log_pos=Exec_master_log_pos;
#Get the values for the above command from your show slave status output.
start slave;
The above process should fix your problem.
On 9/4/07, Russell E Glaue [EMAIL PROTECTED] wrote:
I
reply inline
On 9/5/07, Olaf Stein [EMAIL PROTECTED] wrote:
delete from geno_260k where ident=(select ident from geno_260k where a1=0
group by ident having count(a1)25);
When a sub query returns more than one row in a where clause, then =
should be replaced by the in .
--
Thanks
Alex
select * from Products order by Visited desc limit 10; should give
you the top 10 products.
On 9/5/07, Tomas Abad [EMAIL PROTECTED] wrote:
HI All,
I have a Table and want to know the most visited products.
Products
- Id
- Name
- Visited
To have a good understanding on the show innodb status output checkout
http://www.mysqlperformanceblog.com/2006/07/17/show-innodb-status-walk-through/
One area you can look at is the LATEST DETECTED DEADLOCK. But in most
cases have found calculations on the status variables more helpful.
--
Alex
If you want to track the schema level changes, updates, inserts etc you
always have the binlogs/update logs. If you want to track select queries
also you have the general query log. Check out
http://dev.mysql.com/doc/refman/4.1/en/log-files.html for the different logs
available. Of course be wary
I am not sure whether you are talking about innodb_thread_concurrency. If so
please check out
http://www.mysqlperformanceblog.com/2006/06/05/innodb-thread-concurrency for
more details. Innodb_thread_concurrency works on linux.
Thanks
Alex
On 8/29/07, Andrew Braithwaite [EMAIL PROTECTED] wrote:
On 8/7/07, Tharabar [EMAIL PROTECTED] wrote:
SELECT `field1`,`field2`,`field3` FROM 'table' WHERE `field5` LIKE
'%keyword%1' AND `field5` LIKE '%keyword2%'
The most trivial way to speedup a query is to add an index on the columns
that are being used in the where clause. But doing 'LIKE'
Hi Ace,
If you cant affort downtime and if you are using innodb try removing auto
extend on the current data file and create a datafile in a different
partition and put autoextend on the same. If you are using MyISAM , you can
move few tables to different disk use symlinks.
--
Thanks
Alex
Anand,
If the dump was taken from the slave then the binlog positions that were
dumped out are that of the slave. Now you might do 2 things :
1. Setup a slave of your master
To do this use the binlog positions that you obtained using the
command show slave status on your slave. The
.
--
Thanks
Alex
http://blog.360.yahoo.com/alex.lurthu
On 7/9/07, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi Alex,
Thanks a lot,
I missed on taking the exe_master_log position value.
If i start from Read_Master_Log_Pos: 106683511, will it cause any harm.
regards
anandkl
On 7/9/07, Alex Arul Lurthu
On 7/6/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
How does the cpu power influence the speed of a query?
Sort is a cpu intensive process.
*Check if you are suffering from locks on the tables you look up.*
Also, was the table in the system where the queries are running faster
rebuilt
On 7/6/07, Ananda Kumar [EMAIL PROTECTED] wrote:
-- CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.03',
MASTER_LOG_POS=311;
As see in the mysqldump is saying to start recovery from bin-log file '
mysql-bin.03' and position=MASTER_LOG_POS=311,
You need to use the positions specified
On 7/6/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
How does the cpu power influence the speed of a query?
Sort is a cpu intensive process.
*Check if you are suffering from locks on the tables you look up.*
Also, was the table in the system where the queries are running faster
rebuilt
You havent mentioned which version of mysql your are on. If on an older
version i would recommend the option --opt. Also if you are running a dump
using single-transaction option on a loaded system with writes, things might
slow down significantly due to different versions of rows which the
Chris,
Did you check if there are any user level MAX_USER_CONNECTIONS restriction
set while granting access ?
Thanks
Alex
On 7/4/07, Chris Faust [EMAIL PROTECTED] wrote:
Folks,
I'm wondering is someone could help us in trying to resolve the above
error,
we have read through what threads
Hi,
Run explain plan on both the machines and post the same.
~Alex
On 7/4/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hello Ananda,
yes, the testmachine has the same data.
Regards,
Spiker
--
GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
Alle Infos und kostenlose
Ratheesh,
If you still want to place you blob data in the database, seperate out the
blob storage to a seperate table. This will help you alleviate few of your
performance and maintenance problems.
~Alex
On 6/22/07, Steve Edberg [EMAIL PROTECTED] wrote:
At 12:11 PM +0530 6/22/07, Ratheesh K
check if you are seeing any access denied errors in the mysql error log.
~Alex
On 5/14/07, richard [EMAIL PROTECTED] wrote:
Ian P. Christian wrote:
richard wrote:
as far as I can see, these commands select which db's to replicate on
the slave that currently exist on the master server.
the ask lies in expire_logs_days. If you set this to optimal number of days,
logs older than the configured days will get purged.
~Alex
On 5/15/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
One question about this, is it safe to turn of log_bin?
i think, you can. the log is necessary for
On 5/15/07, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi All,
I have take a mysqldump of my entire database, is it possible to restore
just one table from this mysqldump.
Yes thats possible.
cat your-dump-filename | grep tablename u want to restore mysql -u
user -ppassword should do it.
On 5/15/07, Christoph Klünter [EMAIL PROTECTED] wrote:
I have set the sort_buffer_size to 1G but even this doesn't help.
Any hints ? Should we try a 64Bit-OS ?
setting sort_buffer_size to 1GB is not recommended. it is a thread specific
configuration parameter which means each thread will
On 5/15/07, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi Alex,
Thanks for the info,
For the second question, do you mean i should restore the entire backup or
just that one file from my backup.
All the files should be from the same backup. AFAIK, MySQL doesnt have an
option to recover only one
On 5/15/07, Micah Stevens [EMAIL PROTECTED] wrote:
I think you may be able to get around this by using multiple key
buffers? (MySQL 4.1 or later)
key buffers caches only index data and they dont help with sorting like
sort_buffer. they dont impact innodb engine. even while using multiple key
techincally yes you can have. replication is all about the queries that are
getting executed on the master will be executed on the slave. So , if the
database that exists on the master exists on the slave , then you should
have no problems.
Thanks
Alex
On 5/14/07, richard [EMAIL PROTECTED]
On a different note just running a slave will not help when there is some
accidental deletion of data or tables or databases. Hence have a slave as
Mikhail mentioned and also run regular backups on the slave. Preferably a
tar of your mysql server after shutting it down, also ensure you have
and also an index on users.entity_id (will help the join) should solve your
problem.
Thanks
Alex
On 1/24/07, Brent Baisley [EMAIL PROTECTED] wrote:
You should create indexes on the fields you search on most. In this case,
you are searching on the user_type field, so create an
index on that
Hi,
MySQL Dump is logical. Hence it is mostly slower than locking the MyISAM
tables and copying them or shutting down the server and taring the entire
MySQL directory if you are using innodb. If you are using innodb tables only
you can run mysqldump with --single-transaction option to take a
ref: tallydb.TFMM.FLD_MSG_ID
rows: 1
Extra: Using where
- Original Message -
*From:* Alex Arul [EMAIL PROTECTED]
*To:* Ratheesh K J [EMAIL PROTECTED]
*Sent:* Tuesday, January 23, 2007 11:57 AM
*Subject:* Re: Urgent - MySQL 5 - mysqld using a lot
count(*) is slow in innodb due to Multi Versioning. Which table type are you
using ?
Thanx
Alex
On 6/9/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hi everybody,
MySQL 5.0.21 running on RedHat EL4, 2GHz CPU, 2,5GB RAM, RAID5/128MB
RAM. At one point I had to issue the following query on a
Hi All,
Our current setup has the mysql server and the client app run on the
same host. We are using mysql++ (ports/mysql++-1.7.9) for the database
client api. The application returns huge data sets in the order of 50K. When
we do a show processlist most of the threads spend their time in
On 4/28/06, Daevid Vincent [EMAIL PROTECTED] wrote:
vmware reviewit # mysql --version
mysql Ver 14.12 Distrib 5.0.19, for pc-linux-gnu (i686) using readline
5.1
Given two tables:
CREATE TABLE `logs` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`user_id`
HI,
Take look at your my.cnf and obtain the location of your mysql data
directory. Login into mysql create the database into which you want to
import the tables. What this effectively does is create a directory under
your mysql data directory. Now copy the .myd, .myi and .frm files to the
Hi
Just try this
select distinct(a.id) from test a , test b where a.code = 23 and b.code = 45
and a.id = b.id
Regards,
-Arul
- Original Message -
From: Robert Gehrig [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Wednesday, December 04, 2002 10:52 PM
Subject: Select Problem
as
org.gjt.mm.mysql.Driver
What could be going wrong
Regards,
-Arul
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
Hi All
Does MySQl Support Boolean Datatypes
-Arul
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
Hi Guys
Sorry this is quite off topic.
Any idea hows IT doing in Brazil...
-Arul
sql , query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Hi SImon
Try this
INSERT INTO
table1
SELECT
12 as fixedvalue1 , 20 as fixedvalue2 ,table2.A , table2.B
FROM
table2
WHERE
table2.id = 10
First the SELECT Query is executed from the table 2 which has id = 10
The Result would be
,
companyservices cs3
where
cs1.serviceid = 1
AND cs2.serviceid = 2
AND cs3.serviceid = 3
AND c.companyid = cs1.companyid
Is there any other way , i could achive the result without using a self join
-Arul
sql , query
,
companyservices cs3
where
cs1.serviceid = 1
AND cs2.serviceid = 2
AND cs3.serviceid = 3
AND c.companyid = cs1.companyid
Is there any other way , i could achive the result without using a self join
-Arul
sql , query
Connect to MySQL server on 10.1.1.95 (10061)
What could be the problem
-Arul
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
will not be retrieved
since the count is not 3.But by search criteria , this company should be
retrieved.
So how do we handle these situations
-Arul
- Original Message -
From: Francisco Reinaldo [EMAIL PROTECTED]
To: Arul [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED]
Cc: Arul [EMAIL
Hi All
The Query below took around 175 Secs to return 22 Rows..Any way this query
can be optimized
SELECT
Distinct(C.Company_Name) ,U.UserID , IF(U.CompanyID IS
NULL , NULL ,C.Company_Name) as Company_Name,
U.COMPANYID, U.PASSWORD,
Hi
I Found Group By to be a bit faster...but still it takes 30 secs to execute
a query...
What could be done..I have Indexing on almost all the tables..
-Arul
- Original Message -
From: Dicky Wahyu Purnomo [EMAIL PROTECTED]
To: Arul [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday
Hi
I had written a query which executes in MySql 4.0.1
But this is not working in 3.23.51 coz i had used Union function in the
query which is not supported by 3.23.51
So any idea how this can be made to work on 3.23.51. I need to have only one
Column in the result as TYPENAME
SELECT
Yea Andreas
I had that idea but i thought that would be a performance issue...
So i thought of avoiding this temp table...
I am looking into an option where i can do it in 1 single query...
-Arul
- Original Message -
From: Oswald, Andreas [EMAIL PROTECTED]
To: 'Arul' [EMAIL PROTECTED
Hi All
Can anyone refer me to any document which speaks about Installing MySQL
3.23.51 on Solaris 2.8 Sparc
-Arul
sql , query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
The Document at www.mysql.com/manual
is not clear for a Mysql beginner like me...
Any Step by Step procedure...
What should i do with the downloaded tar file ..
I Had installed MySql in Windows..
But installing it in Solaris is not clear...
-Arul
- Original Message -
From: Arul
, c.companyname from
users u , company c where
u.companyid = c.companyid AND u.status = 'ACT'
This returned only the users who have company...how do i take the users also
who doesnt have a company
Regards
-Arul
-
Before posting
null values for parentid in child table..
This was a feature in 3.23.51 whereas this was not available in 3.23.49
When i tried MySQL 4.0.1 , i was shocked to see that i was not able to
insert null values in the child table which was supported in 3.23.51
Any ideas
-Arul
sql,query
release..
-Arul
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED
Hi Dubey
Actually foreign keys are supporte dfor INNODB Table types..
Whats the version of MYSQL u r using
-Arul
- Original Message -
From: D.K.Dubey [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Sent: Monday, July 01, 2002 4:18 PM
Subject: Foriegn Key
Hi All,
Can anybody
Hi
Can i use left outer join in MySQL.
Like i have one condition in Oracle
ex:
select * from user,company where u.companyid = c.companyid (+)
can i rephrase the query in mysql like this
select * from user left outer join company c using (companyid)
-Arul
sql , query
Hi All
MYSQL Supports Unions in 4.0.1.
Similarly any idea when it will support other SET Operators Like Minus
Regards,
-Arul
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
of returning more rows or the
same rows..I wonder how the number of rows returned is decreased with an OR
Condition
Regards,
-Arul
- Original Message -
From: Arul [EMAIL PROTECTED]
To: Mikhail Entaltsev [EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent: Saturday, June 29, 2002 10:32 AM
' AND U.User_App_Status NOT IN
('NAP')
Could some one please help me
-Arul
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Hi Thomas
I am always ready to give a try ..
But u see Managers will not be ready to take such a risk...and Morever our
client will not give a try ..:((
-Arul
- Original Message -
From: Thomas Spahni [EMAIL PROTECTED]
To: Arul [EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent
Hi
But Still Noone have throwed some light on the Date when MySql 4.0 Release
will be made formally which could enable me to use the Unions
Can anyone in this group please let me know...
-Arul
- Original Message -
From: Arul [EMAIL PROTECTED]
To: Thomas Spahni [EMAIL PROTECTED]
Cc
Hi
Just was curious to know...
I saw a posting by one of the guys here that Yahoo uses MySQL.
Is this true..
Any idea how many MySQL servers does Yahoo Use amd for which domain they use
MYSQL.
-Arul
-
Before posting, please
Hey Mike
I just wanted to know what Database does Yahoo Uses..
Not the OS
:)
-Arul
- Original Message -
From: mos [EMAIL PROTECTED]
To: Arul [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, June 28, 2002 11:05 AM
Subject: Re: Does Yahoo Use MySQL?
At 10:54 PM 6/27/2002, you
Agreed Ralf...
Not all SubQueries can be replaced by Joins..
Thats why we have planned for Temp Tables..
Any ideas on it..
- Original Message -
From: Ralf Narozny [EMAIL PROTECTED]
To: Arul [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED]
Sent: Wednesday, June 26, 2002 3
SELECT
U.UserID
FROM
Transaction_Data T, Rfq_Data R ,Company C
WHERE
T.TransactionID = R.TransactionID AND
(R.Industryid=1 or R.IndustryID IN (SELECT IndustryID FROM
Company_Industries CI WHERE CI.CompanyID = C.CompanyID))
This is to Pass the Mail Server : sql,query
Hi
Any idea when MySQL 4.0 stable release will be made..
As of now only Alpha is released..
Also any sites which run on 4.0 Alpha
Regards,
-Arul
To pass the List : sql , query
-
Before posting, please check:
http
Hi All
Sorry Guys...I just cut a small part of a bi Query where i had problems
but i didnt see the User Table missing in the From List :((
Thanx for your Help..
-Arul
- Original Message -
From: Rob Vieira [EMAIL PROTECTED]
To: 'Benjamin Pflugmann' [EMAIL PROTECTED]; Arul
[EMAIL
, it tells me as 0
Why is this happenning..
I need to get the last inserted value of the primary key ..right
-Arul
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Even the last_insert_id() returns 0
is it coz the table type is INNODB
- Original Message -
From: Jan Peuker [EMAIL PROTECTED]
To: Arul [EMAIL PROTECTED]
Sent: Friday, June 21, 2002 4:16 PM
Subject: Re: @@IDENTITY
You are using M$-Syntax, in MySQL you should use:
SELECT
# a few last transactions
innodb_flush_log_at_trx_commit=1
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
Any idea what could be the problem
Regards
-Arul
sql,query
Hi All
How do i connect to mysql on a remote machine..
Is there any client tools available
Regards,
-Arul
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Hi all
How do i create users in mysql..
After installing i just start mysql and connect to it..
Whats the default username and password it uses..
-Arul
-
Before posting, please check:
http://www.mysql.com/manual.php
subqueries inside decode function...MySql doesnt
support sub queries ...so how do i write queries inside a CASE condition
Regards,
-Arul
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
= 2)
-Arul
- Original Message -
From: Tommy Claasens - Q Data KZN [EMAIL PROTECTED]
To: Arul [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED]
Sent: Wednesday, June 05, 2002 5:54 PM
Subject: RE: Decode to Case
Try a function called coaleace
It will return the non null value.
But i dont have
,
-Arul
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL
Ref : http://www.innodb.com/ibman.html#InnoDB_foreign_keys
The release is
MySQL/InnoDB-3.23.50, April 23, 2002
But where do i get this version...
In www.mysql.org i could only download Max 3.23.49
Any ideas..
-Arul
Hi Heikki Tuuri
I am not sure whether it's the Max version of MySql 3.23.50
Coz the URL differs for ordinary version and Max Version.In the Max version
, i couldnt see anything beyond 3.23.49
-Arul
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent
Hi
Could anyone suggest me the JDBC Drivers available for MySql.
Can the driver support Connection Pooling and RowSet
-Arul
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
Hi All
Is there anything Equivalent in MYSQL for Union in Oracle..
As per my understanding mysql doesnt support unions ...so any suggestions
what could be done..
-Arul
-
Before posting, please check:
http://www.mysql.com
,
-Arul
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL
, but these have to be nested and it gets ugly).
-Arul
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
Hi All
How do i use RowId 's in MYSQL..
Can anyone throw some light on it
Regards,
-Arul
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Thanx Lewis..It worked
- Original Message -
From: Neville Lewis [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Friday, May 31, 2002 12:34 PM
Subject: RE: Alternative to decode() in Oracle
Have a look below:
--
If expr1 is TRUE (expr1 0 and expr1 NULL) then
Hi All
Is it that i can make a column auto increment only if its data type is
integer.
Can i not set auto increment value for a numeric datatype
-Arul
sql,query
-
Before posting, please check:
http://www.mysql.com
afftect the child table...
So can anyone let me know the steps involved in creating an Inno Db and to
achieve the Foreign key relationship
Regards,
-Arul
-
Before posting, please check:
http://www.mysql.com/manual.php
...
-Arul
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL
executed the Query
mysqlshow table status
This says that the Table is of type MyISAM.
This confuses me a lottt...Also the table i had created is not working for
Foreign Key Relations..
What could be the soltuion...Kindly Advice
-Arul
;
After creating the tables when i executed the Query
mysqlshow table status
This says that the Table is of type MyISAM.
This confuses me a lottt...Also the table i had created is not working for
Foreign Key Relations..
What could be the soltuion...Kindly Advice
-Arul
- Original Message -
From
- Original Message -
From: Luca Lafranchi [EMAIL PROTECTED]
To: Arul [EMAIL PROTECTED]
Sent: Thursday, May 30, 2002 5:10 PM
Subject: Re: JDBC Transactions
Hi Arul, this is not a direct answer to your question, only a note about
foreign keys and MySQL: if I'm right (please someone
Hi All
i am running MySql 3.23.49 Max on Win 2K
Does this version of MySQL supports subqueries.
Also does this support transaction..
Where can i get the details reg this..
Regards,
Arul
-
Before posting, please check
and if i use a like
condition in my query , it would be a performance problem.
Could anyone suggest a solution for this
Regards,
-Arul
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
97 matches
Mail list logo
