Hi,
I'm wondering what the status of MySQL 5.1.11 is regarding the roadmap
for 5.1 changing from beta to generally available?
Regards
--jm
--
Jacques Marneweck
http://www.powertrip.co.za/
http://www.powertrip.co.za/blog/
#include std/disclaimer.h
--
MySQL General Mailing List
For list
Hi,
I need fast text searching on a transactional table. Is it possible to
use transactions and text-search on a table together yet in any
production stable version of mysql?
Thanks,
LL
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hello everyone:
I want to get some SQL statistics including executions, CPU time for each SQL
Statement.
How can I get it from MySQL?
regards,
Gu Lei
On Mon, 2006-08-07 at 08:49 +0100, Lexington Luthor wrote:
Hi,
I need fast text searching on a transactional table. Is it possible to
use transactions and text-search on a table together yet in any
production stable version of mysql?
Hi,
One of approaches is to have shadow MyISAM table
what us the maximum filesize for longblobs in kb? Is there anything bigger?
Ross
Hi. I'm running MySQL on a Windows 2003 server and connecting using
classic ASP.
I'm trying to connect and query two databases using a statement like:
strSQLCombo = select sfproducts.products.sku as psku,
sfproducts.products.sortName,
[EMAIL PROTECTED] wrote:
what us the maximum filesize for longblobs in kb? Is there anything bigger?
That's answered in the documentation - http://dev.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
On Mon, 2006-08-07 at 09:18 +0100, [EMAIL PROTECTED] wrote:
what us the maximum filesize for longblobs in kb? Is there anything bigger?
http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html
As you can see in theory it is about 4GB.
It is however also limited by max_packet_size which
Peter Zaitsev wrote:
Hi,
One of approaches is to have shadow MyISAM table in addition to your
Innodb table to perform full text search, which you can update in bulks
or via triggers.
How can I ensure isolation for queries on this shadow table? The
documentation says that the table type does
On Mon, 2006-08-07 at 09:49 +0100, Lexington Luthor wrote:
Peter Zaitsev wrote:
Hi,
One of approaches is to have shadow MyISAM table in addition to your
Innodb table to perform full text search, which you can update in bulks
or via triggers.
How can I ensure isolation for queries
Peter Zaitsev wrote:
Right. If you want full text search to follow transaction isolation
as well you're in trouble.In most search applications however it is
not that critical.
Thats a pity. I will have to port the application to PostgreSQL then.
Thanks anyway,
LL
--
MySQL General
Greg 'groggy' Lehey wrote:
I have downloaded a code on c++ to talk to MySQL database from net which
included a file sqlplus.hh , where may I find the file?Please help me
soon.
That's the main header file for MySQL++ v1.7.9. You can download that
release from the official MySQL++ page:
Hi,
What if I want certain variables initialized and certain code to run
at the database service startup? I am running 5.0.22 on Windows XP
Service Pack 2. Are there any tirggers that can tell me that the
database is starting up?
--
Thanks in advance,
Asif
--
MySQL General Mailing List
For
This might help you
http://kjalleda.googlepages.com/maxconnbymysql
Kishore Jalleda
Thanks Kishore.
Regards,
Rithish.
On 8/7/06, Asif Lodhi [EMAIL PROTECTED] wrote:
Hi,
What if I want certain variables initialized and certain code to run
at the database service startup? I am running 5.0.22 on Windows XP
Service Pack 2. Are there any tirggers that can tell me that the
database is starting up?
You can write
On 8/6/06, Ro BGCT [EMAIL PROTECTED] wrote:
Hello,
I installed MySQL on a remote server and am having a problem. I am
connected to it via SSH and I can do mysql -u root -h localhost just
fine and connect. However, when I try to connect via mysql -u root
-h web1.server.com, I get the following
On 8/6/06, Bill [EMAIL PROTECTED] wrote:
Hi
Can you remind me how to tell mysql to list vertically instead of horiz in
text mode?
Ex:
select all * from a_tablesends field1 field2 .
I want
field1
field2
field...
Thanks
if you type help you can find a lot o information
mysql
On 8/6/06, Ro BGCT [EMAIL PROTECTED] wrote:
Hello,
I installed MySQL on a remote server and am having a problem. I am
connected to it via SSH and I can do mysql -u root -h localhost just
fine and connect. However, when I try to connect via mysql -u root
-h web1.server.com, I get the following
On 8/7/06, 古雷 [EMAIL PROTECTED] wrote:
Hello everyone:
I want to get some SQL statistics including executions, CPU time for each SQL
Statement.
The number of each type of query can be found using the show status
like 'Com%';, I don't believe there's a way to know how much CPU time
MySQL is
Good day,
After a whole day of researching I finally found an answer for Ms Access not
displaying the columns of more than one table in a MySQL 5 view...
The bugfix was posted in a mysql forum here:
http://forums.mysql.com/read.php?65,52721,100434#msg-100434
which contains a link to a download
From: root
To: mysql@lists.mysql.com
Subject: mysqld won't start
Description:
In an attempt to upgrade to MySQL 5.0.24 it was necessary to use
rpm -e ... to remove version 5.0.22 then rpm -U ... to install
the shared,server and client modules.
When I do a rpm -qa it shows that
Peter Zaitsev wrote:
On Fri, 2006-08-04 at 15:54 -0400, Ed Pauley II wrote:
I am looking into a scale-out solution for MySQL. I have read white
papers and searched the web but I can't find a load balancer that claims
to work well for MySQL. MySQL's white paper shows NetScaler in the
The select statement I am trying to run is:
select * from c2iedm_dev2.act where act_id =(select obj_act_id from
c2iedm_dev2.act_functl_assoc where subj_act_id =24);
But I get the error below:
You have an error in your SQL syntax. Check the manual that corresponds to
your MySQL server version for
On Monday 07 August 2006 12:02 pm, William DeMasi wrote:
The select statement I am trying to run is:
select * from c2iedm_dev2.act where act_id =(select obj_act_id from
c2iedm_dev2.act_functl_assoc where subj_act_id =24);
Well the problem I'm seeing is that you're not using IN anywhere in the
On Monday 07 August 2006 12:13 pm, William DeMasi wrote:
I meant to have it say :
select * from c2iedm_dev2.act where act_id IN (select obj_act_id from
c2iedm_dev2.act_functl_assoc where subj_act_id =24);
What does the output of (the subselect):
select obj_act_id
from
I want to design a database for lots of users. Each user will be
managing their own messages. Does it make sense to create a table
for each user after they've registered?
Or should I just create one MESSAGES table and store messages there
keyed off of their user_id?
If I create a table
I want to design a database for lots of users. Each user will be managing
their own messages. Does it make sense to create a table for each user after
they've registered?
Or should I just create one MESSAGES table and store messages there keyed off
of their user_id?
If I create a table for
One table,
USERS
Another table
MESSAGES
With a foreign key referencing users.
Maybe a second foreign key referencing the destinating user as well.
-Original Message-
From: James Tu [mailto:[EMAIL PROTECTED]
Sent: Monday, August 07, 2006 1:56 PM
To: mysql@lists.mysql.com
Subject:
Thanks everyone.
Now I feel confident that one table will be fine (Tripp's stat of 30
million records put me at ease :) ).
Cheers,
-James
On Aug 7, 2006, at 4:08 PM, John Meyer wrote:
One table,
USERS
Another table
MESSAGES
With a foreign key referencing users.
Maybe a second foreign key
Wow, I didn't know that can happen. I'll definitely take that into
consideration. Thanks Brent.
On Aug 7, 2006, at 4:26 PM, Brent Baisley wrote:
If you're looking to be put at ease, I've got a table with 250+
million records, but I've heard of people with larger tables than
that on this
I'm planning on installing MySQL 5.0 today and will try rebuilding some of
the indexes for one of my tables to conduct some benchmarks. I will
probably reboot back to MySQL 4.10 and continue using the database. Have
the table formats changed from 4.10 to 5.0? Or can I create/modify tables
in
Ed Pauley II wrote:
Continuent's m/cluster will not work for me as it does not allow
replication across a WAN. We have an offsite backup that needs to be in
the replication (2-way to make switching back and forth easy) chain. I
am thinking of a master, slave setup at each location where
Mike, if this data is at all important to you, I'd highly recommend
doing your testing on copies of your data files, rather than your
originals.
If it's not important, then I'd go ahead and try it. The MyISAM
storage engine is pretty mature and stable. For safety's sake once
you get it back to
On 8/7/06, James Tu [EMAIL PROTECTED] wrote:
If I create a table for each user (I can potentially have hundreds of
thousands of users), will MySQL be able to handle this?
If I just have one table, I could potentially have millions of
records in one table. Will MySQL be able to handle this?
I'm trying to use LOAD DATA INFILE to read a csv formatted file into a mysql 5.0.22
table. Some of the fields contain text that has newline characters in it. After
reading the manual to learn how special characters are treated, I altered the csv
file so newlines are represented by '\\n', that
At 05:00 PM 8/7/2006, you wrote:
Mike, if this data is at all important to you, I'd highly recommend
doing your testing on copies of your data files, rather than your
originals.
If it's not important, then I'd go ahead and try it. The MyISAM
storage engine is pretty mature and stable. For
Thanks a lot for your reply.
I need know SQLs that consume most resources(CPU time, disk IO etc.) of
database server.
Sometimes the same SQL could be executed many times to hold most time of CPU.
Sometimes executed only one time.
Maybe I can say I am looking for something like STATSPACK of
Hello,
I'm not sure if this is possible (or what it's called, and how to search
for it) at the db layer or if this has to be done at the application
layer... I would like to be able to delete one record in one table and
then automatically (without making an extra call to the db) delete other
On 8/7/06, 古雷 [EMAIL PROTECTED] wrote:
Thanks a lot for your reply.
I need know SQLs that consume most resources(CPU time, disk IO etc.) of
database server.
If its an application, you can use EXPLAIN to find out how MySQL is
processing the most used queries, and use this knowledge to
On 8/7/06, Chris W. Parker [EMAIL PROTECTED] wrote:
Hello,
I'm not sure if this is possible (or what it's called, and how to search
for it) at the db layer or if this has to be done at the application
layer... I would like to be able to delete one record in one table and
then automatically
You want cascade deletion via foreign keys.
http://dev.mysql.com/doc/refman/5.1/en/ansi-diff-foreign-keys.html
is one such place to learn more.
Tim
-Original Message-
From: Chris W. Parker [mailto:[EMAIL PROTECTED]
Sent: Monday, August 07, 2006 9:11 PM
To: mysql@lists.mysql.com
Chris W. Parker wrote:
Hello,
I'm not sure if this is possible (or what it's called, and how to search
for it) at the db layer or if this has to be done at the application
layer... I would like to be able to delete one record in one table and
then automatically (without making an extra call to
Chris mailto:[EMAIL PROTECTED]
on Monday, August 07, 2006 6:19 PM said:
Foreign keys with an on delete cascade should do it.
http://dev.mysql.com/doc/refman/5.1/en/example-foreign-keys.html
Thanks everyone!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hello,
Me again. Excuse for sending two questions so closely together.
I'm looking through the MySQL manual (as well as searching Google and
the PHP site's MySQL functions) trying to find out how to test an Insert
statement (or any other statement for that matter).
Although I haven't found a
Chris W. Parker wrote:
Hello,
Me again. Excuse for sending two questions so closely together.
I'm looking through the MySQL manual (as well as searching Google and
the PHP site's MySQL functions) trying to find out how to test an Insert
statement (or any other statement for that matter).
Hi All,
I need to develop an utility in C++ (don't want to use
mysql++ lib) which provides services to other modules in the system
like createTable( ), createRow( ),
updateAttr( ) Etc. wherein these APIs are called dynamically by the
other modules to do the DB operations.
Is
Charlie Stanton wrote:
From: root
To: mysql@lists.mysql.com
Subject: mysqld won't start
Description:
In an attempt to upgrade to MySQL 5.0.24 it was necessary to use
rpm -e ... to remove version 5.0.22 then rpm -U ... to install
the shared,server and client modules.
When I do a
Chris White wrote:
On Monday 07 August 2006 12:13 pm, William DeMasi wrote:
I meant to have it say :
select * from c2iedm_dev2.act where act_id IN (select obj_act_id from
c2iedm_dev2.act_functl_assoc where subj_act_id =24);
What does the output of (the subselect):
select obj_act_id
from
Hi All,
I need small help from you. I am using Replication, i am using this
technique to give live support to Support team. But my Server and Slave are
not in LAN. So some times i am getting network delay. Can anybody tell me a
good suggestion to over come this.
regards,
balaraju
49 matches
Mail list logo