On 8/23/06, Gregor Reich <[EMAIL PROTECTED]> wrote:
Hi all
Is there a possibility to have some tables write-protected while others
in the same db are not (and yet the write-protected ones are updatable
through the replication mechanism, ie. there are tables on a slave
server). I guess that both,
I am fairly new to SQL and have run into a problem I can't figure
out. I am trying to construct a query that returns an occurrence
ranked list of results.
I have the following tables and fields:
components
id
name
componentsToPartsList
-
On 8/24/06, Dan Buettner <[EMAIL PROTECTED]> wrote:
Sure - in your sql script, put in
SELECT "text to the screen";
Then you'll get 2 copies...
Try this:
SELECT "text to the screen" AS '';
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
- Original Message -
From: "Dave Shariff Yadallee - System Administrator a.k.a. The Root of the
Problem" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, August 23, 2006 10:15 PM
Subject: Chemistry search
Has anyone come up with searching a chemicals based database using
mols or smilies?
Hi,
We maintain a pool ..it is just a collection, where we maintain a list
of connections.
Regards
prasad
-Original Message-
From: Robert DiFalco [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 23, 2006 11:41 PM
To: Prasad Ramisetti (WT01 - Broadband Networks); mysql@lists.mysql.com
S
Dilipkumar wrote:
Hi,
While taking backup in MySQL 5.0.24 for (ndbcluster tables) i am getting the
following errors :
mysqldump: Error 1296: Got error 241 'Invalid schema object version' from ndbcluster when dumping
table `iib_candidate_tracking` at row: 0
When i checked out using ndberror :
Neil Tompkins wrote:
OK, I appear to be getting somewhere with the FULL TEXT search. Does anyone
have any good resources about producing search engine type results ? for
example if some enters a search phrase like londn how would I suggest the
word london ?
I was listening to a podcast a
Jerry Schwartz wrote:
Actually, by default a full text search ignores words that are three
characters or less, not less than three characters.
I found this out by searching on "red".
Ahh, oops :) Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubsc
Visolve DB Team wrote:
hi
MySQL automatically converts a date or time type value to a
number (numeric context) & viceversa.
When the server starts, it attempts to determine the time zone of the
host machine and uses it to set the *system_time_zone* system variable.
The value does not chang
axis wrote:
Hi,
I'm trying to copy between two databases with the same tables, but the
destination one has a different number of rows.
I used SQLyog first to create the script with the necessary commands and
it partially worked after applying it to the second table, but my
problem is with one
matt_lists wrote:
chris smith wrote:
On 8/23/06, matt_lists <[EMAIL PROTECTED]> wrote:
We did not see this on 5.0.19, with 5.0.24 our backup jobs lock the
tables for selects
the backup takes 3 hours, so the site is down the whole time
I'm using this backup line
mysqldump -d -f --quote-names
matt_lists wrote:
It's not a bug. I guess this is a myisam table?
http://dev.mysql.com/doc/refman/5.1/en/table-locking.html
Any time the table is changed with myisam, the whole table is locked.
That's the way it works.
Innodb doesn't do it this way but it might cause other issues for you.
T
Has anyone come up with searching a chemicals based database using
mols or smilies?
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:h
Hi Folks,
Does anybody know if it is possible to restrict access to these commands
on an individual basis? I have a need to exclude users, who would
otherwise have most privileges, and was wondering if there was a
particular privilege that I could revoke.
If not, does anybody have a technique t
There apparently isn't a PRINT or RAISERROR function like there is in
SQL Server, I've asked about this before.
I created a stored procedure to dump debug text into a table (which is
timestamped) and another to output the rows in there in a SELECT. It
isn't the same but it's something.
Dan
Hi, i was sleep during 2 years and yet no update mysql 3.2X... :)
First i download :
MySQL-server-4.0.23-0.i386.rpm
MySQL-client-4.0.23-0.i386.rpm
MySQL-devel-4.0.23-0.i386.rpm
MySQL-shared-4.0.23-0.i386.rpm
MySQL-shared-compat-4.0.23-0.i386.rpm
But when rpm -Uvh *.rpm
warning: MySQL-client-4.0.
Yes, it's running on Windows XP, but the Windows Firewall has been
disabled.
Just figured it out... This was a version of MySQL bundled with an
application. I wrongly assumed that shutting down the application also
shut down the included MySQL server. The original my.cnf had a
bind-address
Hi,
I'm trying to copy between two databases with the same tables, but the
destination one has a different number of rows.
I used SQLyog first to create the script with the necessary commands and
it partially worked after applying it to the second table, but my
problem is with one of the table
Is it running on Windows, James? You may have to allow connections
through to MySQL in Windows Firewall.
Otherwise it seems like maybe it's been started with --skip-networking ?
Dan
On 8/23/06, James Eaton <[EMAIL PROTECTED]> wrote:
- Original Message -
From: "Dan Buettner" <[EMAIL P
- Original Message -
From: "Dan Buettner" <[EMAIL PROTECTED]>
I believe MySQL listens on all IPs ... what if any error message are
you getting?
From SQLyog I get:
Error No. 2003
Can't connect to MySQL server on '192.168.9.2' (10061)
Can you access other services (SSH, telnet,
That's a tough one. Basically, you need a spell checker plug-in for your
application, I don't think there's much hope of doing this in MySQL alone.
You might find a spell checker that uses MySQL for a back end, of course,
but I doubt it.
Doing a search on Google, I found some open-source spell che
Sure - in your sql script, put in
SELECT "text to the screen";
Dan
On 8/23/06, Jesse <[EMAIL PROTECTED]> wrote:
Is it possible to output text to the screen from a .sql script? If so, how?
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
On Wed, 2006-08-23 at 22:23 +0200, spacemarc wrote:
> Hi,
> I have a query like this:
>
> SELECT table1.*,(
> SELECT COUNT( field2 )
> FROM table2
> WHERE id=10
> ) AS total
> FROM table1
> GROUP BY id
> LIMIT 1
>
> but the subqueries do not work with mysql < 4.1. How can I convert it
> (or make
See http://dev.mysql.com/doc/refman/5.0/en/rewriting-subqueries.html
for some tips
Dan
On 8/23/06, spacemarc <[EMAIL PROTECTED]> wrote:
Hi,
I have a query like this:
SELECT table1.*,(
SELECT COUNT( field2 )
FROM table2
WHERE id=10
) AS total
FROM table1
GROUP BY id
LIMIT 1
but the subqueries
Is it possible to output text to the screen from a .sql script? If so, how?
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I believe MySQL listens on all IPs ... what if any error message are
you getting?
Can you access other services (SSH, telnet, FTP) over the same routes?
Can you telnet to MySQL over those routes? If so you may have an
authentication problem, not a connection problem. Here's a sample of
what a
Hi,
I have a query like this:
SELECT table1.*,(
SELECT COUNT( field2 )
FROM table2
WHERE id=10
) AS total
FROM table1
GROUP BY id
LIMIT 1
but the subqueries do not work with mysql < 4.1. How can I convert it
(or make to work) in MySQL 3.x, 4.0 possibly in one only query?
thanks
--
http://www.sp
> OK, I appear to be getting somewhere with the FULL TEXT search. Does
> anyone have any good resources about producing search engine type results
> ? for example if some enters a search phrase like londn how would I
> suggest the word london ?
Hi Neil,
That's a completely different thing, b
Is there a way to query a MySQL (5.0.xx) server to find out which IP
address(es) it's listening on? It should be listening on all, but I'm
unable to connect from remote machines, so need to troubleshoot a bit.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
OK, I appear to be getting somewhere with the FULL TEXT search. Does anyone
have any good resources about producing search engine type results ? for
example if some enters a search phrase like londn how would I suggest the
word london ?
> From: [EMAIL PROTECTED]> To: [EMAIL PROTECTED]; [EMA
What connection pool code are you using? My guess is that the problem is
in your code somewhere. Either transactions are not being closed (i.e.
because of a connection pool flaw maybe?) or you have two threads trying
to update the same row at the same time (in which case this would be
expected beha
Emi, it appears in 3.23 your limit is 16 MB. In 4.0 and later, it is 1 GB.
http://dev.mysql.com/doc/refman/4.1/en/packet-too-large.html
Dan
On 8/23/06, Emi Lu <[EMAIL PROTECTED]> wrote:
Hello,
Just curious to know whether Mysql 3.23 has any length constraint about
where part, such as
Que
--On August 23, 2006 1:55:36 PM -0400 Emi Lu <[EMAIL PROTECTED]>
wrote:
Hello,
Just curious to know whether Mysql 3.23 has any length constraint about
where part, such as
Query =
[
select col1, col2, ... coln
from table 1, table2,
where
constraint1 + constraint2 +
Hello,
Just curious to know whether Mysql 3.23 has any length constraint about
where part, such as
Query =
[
select col1, col2, ... coln
from table 1, table2,
where
constraint1 + constraint2 +constraintN
]
Is there any length arrange for the Query str such as
Nico, as a first stab, I would try optimizing the tables in question.
OPTIMIZE TABLE mysql.user
etc.
The one with 194,177 entries would be a good candidate for this especially.
I wonder also if you would see something logged in the slow query log
as this happens? Perhaps the tables_priv table
Hey,
I have this query:
SELECT team. * ,
COUNT(*) - IF(team_id IS NULL, 1, 0) AS numberofmember
FROM team
LEFT JOIN teammember ON ( team.id = teammember.team_id )
WHERE CONCAT( team.name, team.description ) LIKE '% %'
AND team.status =1
AND team.inviteonly =0
GROUP BY team.id
ORDER BY numberofm
Hi,
I am facing a strange problem with INNODB. My application communicates with
mysql server using JDBC. I am using mysql 5.1 version.
Even after issuing connection.commit() / connection.rollback() commands, still
on the sql side the transactions are not getting closed properly. In our
applic
More than likely, the OS file system is caching the files that make up the
tables.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Ratheesh K J [mailto:[EMAIL PROTECTED]
Sent: Wed
Actually, by default a full text search ignores words that are three
characters or less, not less than three characters.
I found this out by searching on "red".
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
On
Hello,
as the title reads, when a user X with access to few tables runs "show
databases"
the query executes _very_ slowly and there's a sudden HUGE load (mysqld
takes 99% cpu for the whole
duration of the query):
show databases;
++
| Database |
+--
When a query goes from 18 to 10 seconds, or similar times, it is likely
because of caching at the MySQL or OS/disk level, not query caching. The
first time, the info had to be found on the disk and read, which is
relatively slow. After that it's in memory and can be accessed more quickly
in the
In the last episode (Aug 23), C.R.Vegelin said:
> Hi List,
>
> I have a table with a FULLTEXT KEY column,
> and I would like to get a list of all the FULLTEXT KEY words, eg:
> acetic
> acid
> acidified
> acrylic
> ...
> Any idea how to make such a list ?
You can run the myisam_ftdump program to g
chris smith wrote:
On 8/23/06, matt_lists <[EMAIL PROTECTED]> wrote:
Not sure if this is a bug
we are updating a large table with replace delayed from our feeder
systems, 1000 records at a time using limit's on the input data pull
this works great when there's fast selects from the table, whi
chris smith wrote:
On 8/23/06, matt_lists <[EMAIL PROTECTED]> wrote:
We did not see this on 5.0.19, with 5.0.24 our backup jobs lock the
tables for selects
the backup takes 3 hours, so the site is down the whole time
I'm using this backup line
mysqldump -d -f --quote-names --skip-add-locks da
It's not a bug. I guess this is a myisam table?
http://dev.mysql.com/doc/refman/5.1/en/table-locking.html
Any time the table is changed with myisam, the whole table is locked.
That's the way it works.
Innodb doesn't do it this way but it might cause other issues for you.
Try changing the tab
On 8/23/06, matt_lists <[EMAIL PROTECTED]> wrote:
We did not see this on 5.0.19, with 5.0.24 our backup jobs lock the
tables for selects
the backup takes 3 hours, so the site is down the whole time
I'm using this backup line
mysqldump -d -f --quote-names --skip-add-locks database > outfile
mys
On 8/23/06, matt_lists <[EMAIL PROTECTED]> wrote:
Not sure if this is a bug
we are updating a large table with replace delayed from our feeder
systems, 1000 records at a time using limit's on the input data pull
this works great when there's fast selects from the table, while the
insert is goi
DBTools Software is pleased to announce the new DBManager Professional 3.3.3
Enterprise Edition.
This version is a major bug fix with a few extra funcionality added to the
application.
For a complete lists of changes check
http://www.dbtools.com.br/EN/article.php?id=00071.
You can download the lat
We did not see this on 5.0.19, with 5.0.24 our backup jobs lock the
tables for selects
the backup takes 3 hours, so the site is down the whole time
I'm using this backup line
mysqldump -d -f --quote-names --skip-add-locks database > outfile
mysqldump -t -f --skip-add-locks database > outfile
On 8/23/06, Ratheesh K J <[EMAIL PROTECTED]> wrote:
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
Not sure if this is a bug
we are updating a large table with replace delayed from our feeder
systems, 1000 records at a time using limit's on the input data pull
this works great when there's fast selects from the table, while the
insert is going
when a site does a large pull, which can t
Hi,
While taking backup in MySQL 5.0.24 for (ndbcluster tables) i am getting the
following errors :
mysqldump: Error 1296: Got error 241 'Invalid schema object version' from
ndbcluster when dumping
table `iib_candidate_tracking` at row: 0
When i checked out using ndberror :
NDB error code 129
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
Is there a possibility to have some tables write-protected while others
in the same db are not (and yet the write-protected ones are updatable
through the replication mechanism, ie. there are tables on a slave
server). I guess that both, LOCK TABLES and read-only in my.cnf, don't
get this resul
The problem is now the slave is saying there are duplicate key entries.
Im not sure
how this is possible. Any thoughts ?
Your procedure looks right. Do you use innodb tables?
Otherwise, single-transaction does not work as you expect.
--
MySQL General Mailing List
For list archives: http://l
Hi List,
I have a table with a FULLTEXT KEY column,
and I would like to get a list of all the FULLTEXT KEY words, eg:
acetic
acid
acidified
acrylic
...
Any idea how to make such a list ?
TIA, Cor
Jürgen Ladstätter wrote:
hi all,
i developed a programm which needs my external mysql database server. now i
have to transfer a lot of data and i have todo a lot of select queues. how
can i tune that, so that it would be faster? in my monitoring system i saw,
that CPU load is 0, the only thi
hi all,
i developed a programm which needs my external mysql database server. now i
have to transfer a lot of data and i have todo a lot of select queues. how
can i tune that, so that it would be faster? in my monitoring system i saw,
that CPU load is 0, the only thing thats working when my pro
Hi all
Is there a possibility to have some tables write-protected while others
in the same db are not (and yet the write-protected ones are updatable
through the replication mechanism, ie. there are tables on a slave
server). I guess that both, LOCK TABLES and read-only in my.cnf, don't
get t
hi
MySQL automatically converts a date or time type value to a number (numeric
context) & viceversa.
When the server starts, it attempts to determine the time zone of the host
machine and uses it to set the system_time_zone system variable. The value does
not change thereafter.
The global time
60 matches
Mail list logo
