As far as i know, using IN( SUBQUERY ) will give very poor performance,
especially if the record set returned by the large query is really large.
try to use a join instead of WHERE IN( XXX )..
Im not sure why its that much better in INNODB though...
Foo Ji-Haw wrote:
Hi all,
Just want to sh
Hi all,
Just want to share and confirm my findings on a performance issue I've
been experiencing.
My database is strictly non-transactional, but it's got about 200,000
records in this particular table. The table has a primary index, and 2
integers - one for the date and the other for the tim
Hi,
If mysql database server installed on Linux without problem, but on
win2000/XP:
select substring_index(user(),_utf8'@',-1) return the local windows
station computer name instead of IP ?
Best regard!
Shuming Wang
Your method is wrong because if you are looking for "5", then "56" will
match and also everything that has "5" in it.
Unless you include the spaces and look for : '% 5 %' but then you need
to add a space at the beginning and at the end of your attributes field.
That method is way too cumbersome a
Dear all:
I use Tomcat 5.5.9 and Mysql Server 5.0 (with the driver
mysql-connector-java-3.1.12-bin.jar)
to run my Application on Windows XP.
It run smoothly many times throughout the whole Application without any problem
!
But in an unexpected time, I get the following Error messages.
I can
Been wondering this for a while now, I can explain how I do it, but I am
sure there are better ways.
I have products and attributes, for example:
Product A
nice
sweet
fast
funny
Attributes are arbitrary, attributes are in a separate table. Yes, I could
add fields for the attribut
- Original Message -
From: "fbsd_user" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, March 07, 2006 11:40 PM
Subject: Table with multiple primary keys - How
What I am trying to do here is have 3 separate primary keys.
Creating a mysql select on either of the Logon_id, email_addr,
or last_
Eli,
>Example: I want to search on all the directories under 'd4' that
contain the word "music".
>I got several solutions, but not satisfying:
>A) Loop from 'd4' to sub-dirs in first level, and use buffer list for
next iterations
>when going deeper into levels. [not good: there can be many su
In the last episode (Mar 07), fbsd_user said:
> What I am trying to do here is have 3 separate primary keys. Creating
> a mysql select on either of the Logon_id, email_addr, or last_name
> fields will do a single read to the matching value. Like having 3
> different indexes into the same table.
C
What I am trying to do here is have 3 separate primary keys.
Creating a mysql select on either of the Logon_id, email_addr,
or last_name fields will do a single read to the matching value.
Like having 3 different indexes into the same table.
I don't want those 3 field concatenated together as a
http://sourceforge.net/projects/jtds docs say
"jTDS does not need any special installation. Just drop the jar file into your
application's classpath"
How do I figure out where that is on a win box?
I am trying to connect it to MsSql using http://java.com/getjava and
http://sourceforge.net/pro
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 07 Mar 2006 19:54:02 -0500
Mathieu Bruneau <[EMAIL PROTECTED]> wrote:
> kalin mintchev a écrit :
> > hi all...
> >
> > what's the best way to periodically back up mysql data?
> > so that databases and tables can be still usable even after a
On 3/7/06, Mathieu Bruneau <[EMAIL PROTECTED]> wrote:
> kalin mintchev a écrit :
> > hi all...
> >
> > what's the best way to periodically back up mysql data?
> > so that databases and tables can be still usable even after a mysql upgrade?
> >
> > thanks...
> >
> >
>
> The only absolutely portable
kalin mintchev a écrit :
> hi all...
>
> what's the best way to periodically back up mysql data?
> so that databases and tables can be still usable even after a mysql upgrade?
>
> thanks...
>
>
The only absolutely portable way is the dump in text file...
Good luck
--
Mathieu Bruneau
aka RO
Hi,
I have a table of directories. Each row represents a directory, which
holds his name and desc. Another table lists sub-directories from each
directory source to its sub-directories targets.
dirs:
+--+--++
| dir_id | dir_name | dir_desc |
+--
Hi Kishore,
That's an interesting idea. However, given that the healthy slave
and the corrupt slave now have different values for
Exec_Master_Log_Pos, would restoring the tables from the healthy
slave necessarily be a good move?
I would be worried that the corrupt slave's counter positio
an "rsync" with the right options from the unaffected slave to the corrupt
one might prove to be an elegant technique
Kishore Jalleda
On 3/7/06, Michael Jeung <[EMAIL PROTECTED]> wrote:
>
> Hi Folks,
>
> We've got a Single Master/Multiple Slave environment.
> Recently, we had some corruption on o
Check this GUI out for monitoring running processes.
http://www.student.nada.kth.se/~f91-men/qps/
It will show you the connection parameters passed to the
mysqld daemon.
I've had a terrible time trying to work out whether mysqld
was actually running or not.The error messages are not too
help
> What else can I do to observe myslqd?
mytop may be of some use: http://jeremy.zawodny.com/mysql/mytop/
-Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello Daniel,
> > To find the reason causing the problem I started mysqld with the
> > "--log"-option and the "--log-error"-option ...
>
> Try --log-warnings, so you know about ...
I will have a look at the documentation and - if possible - I will
even try "--log-everything". ;-)
> Also try low
Hi Folks,
We've got a Single Master/Multiple Slave environment.
Recently, we had some corruption on one of the slaves and I had to
repair the affected tables.
After the repair completed, some of the rows on the slave had been
deleted - so the Master and the Slave weren't exactly in synch.
Hello Keith,
> The web applications below will allow you to connect to and
> monitor and administer MySQL databases.
>
> http://www.phpmyadmin.net/home_page/index.php
it helps a lot when MySQL is running. Thank you.
But when "mysqladmin --user=x --password=y ping" says that
the "connect failed"
Hello,
> how can I see the value of max-connections
I found it in phpmyadmin. It is 100.
> Can I set max-connections? If so: where can I set it? In /etc/my.cnf?
I found the answer in the mysql-documentation. RTFM I know. ;-)
Bye
Karl
--
MySQL General Mailing List
For list archives: http://l
no ideas?
--
Sebastian Mork
[EMAIL PROTECTED]
--
On Mon, 06 Mar 2006 19:46:53 +0100
Sebastian Mork <[EMAIL PROTECTED]> wrote:
> Hi,
> is it not possible to lock federated tables (creating a lock on the remote
> machine to lock the table on the machine containing the data?)
>
> I've a situation
The web applications below will allow you to connect to and
monitor and administer MySQL databases.
http://www.phpmyadmin.net/home_page/index.php
Check out the DEMO link in the top menu bar, RHS.
Or there is the MySQL Administrator at:
http://www.mysql.com/products/tools/administrator/index.ht
Am Dienstag, den 07.03.2006, 11:30 -0500 schrieb Kishore Jalleda:
Hello Kishore,
> May be the mysqld server has exceeded max-connections, and is therefore not
> able to serve any clients
how can I see the value of max-connections and how can I see how many
connections are active at the moment?
C
On 3/7/06, Karl Schock <[EMAIL PROTECTED]> wrote:
> Hello,
>
> my problem: I run a phpbb-Forum with a mysql database on a linux
> server.
> Every 5 - 7 days the mysql database runs in a vicious circle:
>
> "mysqladmin --user=x --password=y ping" says that the "connect failed".
> The socket /var/lib
"J A" <[EMAIL PROTECTED]> wrote on 03/07/2006 12:31:57 PM:
> 1. Support for N-types for the future. UNICODE support for NCHAR,
NCLOB and
> NVARCHAR datatypes
> 2. Support for UCS-2 or UTF-16 for future.
> 3. Support for N-types in Stored Procedures
> 4. Automatic translation of N-type to
1. Support for N-types for the future. UNICODE support for NCHAR, NCLOB and
NVARCHAR datatypes
2. Support for UCS-2 or UTF-16 for future.
3. Support for N-types in Stored Procedures
4. Automatic translation of N-type to SPs Unicode
5. Embedded database server within a client
"Martijn Tonies" <[EMAIL PROTECTED]> wrote on 03/07/2006 10:46:58 AM:
> Hello Shawn,
>
> Thanks for replying.
>
> INSERT_METHOD is an option valid for merge tables.
> See http://dev.mysql.com/doc/refman/5.0/en/create-table.html
>
> From what I can see, the only way to get it, is parse the
> SH
May be the mysqld server has exceeded max-connections, and is therefore not
able to serve any clients ( but you should have a log for that), is this
your server, and does this happen at peak times, and what happens after the
circle, mysqld just dies
Kishore Jalleda
On 3/7/06, Karl Schock <[E
Osvaldo,
Osvaldo Sommer wrote:
Heikki:
All servers have the auto upgrade on, so all the windows upgrade has been
install.
this is interesting. Error 995 might then be a hardware problem.
We have a raid 5 on all servers. Could that give a random error? We can try
a give a low format to the d
Heikki:
All servers have the auto upgrade on, so all the windows upgrade has been
install.
We have a raid 5 on all servers. Could that give a random error? We can try
a give a low format to the disks.
Osvaldo Sommer
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]
Sent:
On 07/03/2006, [EMAIL PROTECTED] wrote:
> "insert_method" ??
>
> I thought I knew a little about databases and table design but that's
> a new term for me. What does it mean and how would I apply it in
> order to modify a table's contents?
>From http://dev.mysql.com/doc/refman/5.0/en/merge
Hello Shawn,
Thanks for replying.
INSERT_METHOD is an option valid for merge tables.
See http://dev.mysql.com/doc/refman/5.0/en/create-table.html
>From what I can see, the only way to get it, is parse the
SHOW CREATE TABLE output.
Martijn Tonies
Database Workbench - tool for InterBase, Firebir
"Martijn Tonies" <[EMAIL PROTECTED]> wrote on 03/07/2006 09:57:17 AM:
> Hi,
>
> Anyone got a clue where to get a hold of "insert_method"
> after creating the table?
>
> Is the SHOW CREATE TABLE output the only way to
> get it?
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebi
Hello Guys,
I was able to connect to mysql database using perl DBI.
I was using the wrong version of Perl on HP-UX to install the DBI and DBD.
There were two versions , 32 bit and 64 bit perl. by default the 32 bit perl
was picked up. I changed the path to 64 bit perl interpreter and the DBI
Hi,
Anyone got a clue where to get a hold of "insert_method"
after creating the table?
Is the SHOW CREATE TABLE output the only way to
get it?
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
My thoughts:
h
Oh yeah got it u meant UNION clause .
Still i have no idea about that i usally see it in show create tables
statements .
Sorry :(
--Praj
On Tue, 7 Mar 2006 15:10:51 +0100
"Martijn Tonies" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> > Simple way is show table status; there is a column Type : value MR
Hi, Ron.
I think REGEXP can help you..
http://dev.mysql.com/doc/refman/5.0/en/regexp.html
Im trying to select an IP from a TEXT (details) type field, which works if I do
this:
select id from `table` where `details` like '%192.168.0.1%' :
But If I want any record with an IP in that TEXT type
Hello,
my problem: I run a phpbb-Forum with a mysql database on a linux
server.
Every 5 - 7 days the mysql database runs in a vicious circle:
"mysqladmin --user=x --password=y ping" says that the "connect failed".
The socket /var/lib/mysql/mysql.sock is there.
"ps aux | grep mysqld" shows me
Dan Rossi <[EMAIL PROTECTED]> wrote on 03/07/2006 05:47:41 AM:
> yet just another multi-national gupling up its competitors, i stumbled
> across this blog
> http://golgote.freeflux.net/blog/archive/2005/10/08/oracle-buys-
> innodb.html and had no idea, its just as bad the the latest Eola patent
Im trying to select an IP from a TEXT (details) type field, which works if I do
this:
select id from `table` where `details` like '%192.168.0.1%' :
But If I want any record with an IP in that TEXT type field it seems a little
tricky.
I have tried:
select id from `table` where INET_ATON(details)
Manuel Schmitt (manitu) wrote:
Hi,
I'am searching for a way to have mysqld log all passwords which clients
are using ("trying") while connecting.
As to the documentation and to my trials neither the error log nor the
general query log contain passwords, only the usernames.
I already tried to g
Hi,
> Simple way is show table status; there is a column Type : value MRG_MyISAM
is the base table.
No, that's not what I meant -- I meant, the merge
table uses a UNION clause to get signal where it
get it's data from.
Where can I get the sources for the merge table?
That is, what is used in the
Resend,
Anybody please give me information about different insert performance
between MySQL 5.0.18 and MySQL 4.1.18
as my posting at
http://forums.mysql.com/read.php?22,74279,74279
Thank your
Heikki
Please see my testing result on MySQL Forum
http://forums.mysql.com/read.php?22,74279,7427
Hi
Simple way is show table status; there is a column Type : value MRG_MyISAM is
the base table.
--Praj
On Tue, 7 Mar 2006 14:02:44 +0100
"Martijn Tonies" <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> How do you know what the sources are for a MERGE
> table?
>
> SHOW TABLE STATUS doesn't show
Hi there,
How do you know what the sources are for a MERGE
table?
SHOW TABLE STATUS doesn't show it, as far as I
can see?
Is it really only available in SHOW CREATE TABLE?
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://
Hi
Thanks for you support hope you have a grate day ..
On 3/7/06, Martijn Tonies <[EMAIL PROTECTED]> wrote:
>
> Hello Gregory,
>
>
> > What, is the easest way to select all the records created in the last 20
> min
> > stay based on a column that has a timestamp record.
>
> select * from mytable
>
Hello Gregory,
> What, is the easest way to select all the records created in the last 20
min
> stay based on a column that has a timestamp record.
select * from mytable
where some_timestamp > date_add(current_timestamp, interval -15 minute)
Martijn Tonies
Database Workbench - development tool
Hi, Gregory
Hmm.. I think you just should add something like 'create_time >
DATE_SUB(NOW(), INTERVAL 20 MINUTE)' to a where clause of your query. Or
something similar..
You can find more at
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html.
Also consider creating of an in
When setting up several instances in the instance manager, if you don't want
them all to start at once, but you want to
start instances on demand (like when you have instances of different MySQL
versions) the only way I found to achieve
this goal is is to set the option "nonguarded".
Then, when y
select * from table where mytimestamp > (unix_timestamp - 20) ??
Gregory Machin schrieb:
> Hi
> What, is the easest way to select all the records created in the last 20 min
> stay based on a column that has a timestamp record.
>
> Many Thanks
>
> --
> Gregory Machin
> [EMAIL PROTECTED]
> [EMAIL PR
yet just another multi-national gupling up its competitors, i stumbled
across this blog
http://golgote.freeflux.net/blog/archive/2005/10/08/oracle-buys-
innodb.html and had no idea, its just as bad the the latest Eola patent
case against microsoft and others its getting out of hand. What are
*MySQL Manual - Chapter 12.7.4. Full-Text Restrictions* says: *Full-text
searches are supported for MyISAM tables only. *
You could try to do what i did... with some overhead... I also had InnoDB
tables for an application and also was in a great need of Full-Text
Searches.
I made a mirror MyISAM
Hi, Rich.
What is skip_count? I couldn't find any reference to it in mysql
documentation.
I'm not sure I understood your question, but I beleive you're asking for
LIMIT modifier.
SELECT * FROM $table LIMIT $offset, $record_count;
or
SELECT * FROM $table LIMIT $record_count OFFSET offset;
Hi folks.
I'm wanting to provide some safety for a search. I'll be grabbing about
45 fields, and perhaps thousands of records, so that I can build an xml
file using my middleware. How can I structure an SQL statement so that
I can jump through records 100 at a time? Do I use offset or skip_
57 matches
Mail list logo
