Hi Eric,
you can setup replication on your laptop (master) and your PC (slave).
http://dev.mysql.com/doc/mysql/en/replication.html
Best regards,
Mikhail.
- Original Message -
From: "Eric Dahlenburg" <[EMAIL PROTECTED]>
To:
Sent: Monday, August 08, 2005 4:12 PM
Subject: Exporting a dat
Matthijs,
in the bug report Heikki Tuuri wrote:
***
[13 Apr 20:59] Heikki Tuuri
The bug was introduced in 4.0.24 and 4.1.10. The fix will be in 4.1.12 and
5.0.5.
***
Best regards,
Mikhail.
- Original Message -
From: "Matthijs van der Klip" <[EMAIL PROTECTED]>
To: "MySQL mailing list"
C
Hi Anoop,
In order to validate a date I am using next query:
select date_format(date_sub(date_add('', interval 1 day), interval
1 day),'%Y%m%d') = date_format('','%Y%m%d');
It will give you 1 if date is valid.
Best regards,
Mikhail.
- Original Message -
From: "Anoop kumar V" <[EMAIL
Jigal,
create table YourTable
(
id INT(11),
name VARCHAR(32),
value INT(11),
PRIMARY KEY(id,name,value)
)
let's assume that PRIMARY KEY works like you want (accept NULLs)
and we have a row in your table: (id,name,value) = (1,NULL,12)
Then you insert a new row:
insert into YourTable (id,name,v
Missed FROM clause... ;)
Best regards,
Mikhail.
- Original Message -
From: "Mário Gamito" <[EMAIL PROTECTED]>
To:
Sent: Friday, March 11, 2005 1:49 PM
Subject: Problem in a very simple SQL statement
> Hi,
>
> Why do i get an error on this statement:
>
> select count(email) where email
Hi,
Today I was surprised by MySQL... :)
I have a table like
create table MyTable (a int default 0 not null, b date);
insert into MyTable (a, b) values (1, null), (1, null), (1, null);
And today morning I executed update query:
update MyTable set a = 0 and b = now() where a = 1;
After that I h
abs()
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 01, 2004 12:59 PM
Subject: A question of negative numbers..
Hi,
I have a query that returns a list of numbers ranging from -10 to +10
I would like to be able to have a 2nd column whe
select concat(ifnull(Field1,'NULL'), Filed2) from My Table;
- Original Message -
From: "A Z" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 31, 2004 2:25 PM
Subject: Concat
>
> Hi,
>
> Concat() returns Null if any field in the field list
> is Null. How can I use it
- Original Message -
From: [EMAIL PROTECTED]
To: Mikhail Entaltsev
Cc: matt ryan ; [EMAIL PROTECTED]
Sent: Friday, August 27, 2004 10:40 PM
Subject: Re: 1 day 28 min insert
If that were a valid SQL statement, I would agree with you. What you wrote
**only** functions through a MySQL-specific SQL ext
> You _could_ try adding an identical primary key to the stat_in table as
> you have on the 321st_stat table. However, since we need all of the rows
> from stat_in in the results, I am not sure that it will help speed up the
> join (because it's a left join). Even though I think the index would be
ROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, August 27, 2004 9:25 PM
Subject: Re: 1 day 28 min insert
> Mikhail Entaltsev wrote:
>
> >Could you execute "show create table 321st_stat" and "show create table
> >stat_in"
> >and send results ba
4 4:45 PM
Subject: Re: 1 day 28 min insert
> Mikhail Entaltsev wrote:
>
> >Hi,
> >
> >insert into 321st_stat select * from stat_in group by >from 321st_stat table>;
> >
> >did you try to use this query?
> >
> >Best regards,
> >Mikhail.
> &g
Hi,
insert into 321st_stat select * from stat_in group by ;
did you try to use this query?
Best regards,
Mikhail.
- Original Message -
From: "matt ryan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 19, 2004 6:06 PM
Subject: 1 day 28 min insert
> I think oracle
Hi,
I have found that messages
"
a.. Non-standard behavior of UNION statements has changed to the standard
ones. So far, a table name in the ORDER BY clause was tolerated. From now on
a proper error message is issued (Bug #3064).
a.. Added max_insert_delayed_threads system variable as a synonym fo
Thank you for correction. You are absolutly right!
Best regards,
Mikhail.
- Original Message -
From: "Brian Mansell" <[EMAIL PROTECTED]>
To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
Cc: "A Z" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
S
Hi,
select YourField from YourTable order by YourField limit 1;
Best regards,
Mikhail.
- Original Message -
From: "A Z" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 11, 2004 3:01 PM
Subject: Max
>
> Hi,
>
> A field of type VarChar() with following syntax:
> ABA1.
> H
Adam,
> I've got to create a table that has the following:
>
> CREATE TABLE access (
>query VARCHAR(255) NOT NULL,
>INDEX (query)
> );
>
> and mysql is telling that the max bytes allowed is 500 for key length.
> The docs say I can change this by recompiling, which I would like to
> avo
Alan,
> Now I'd love to know why I can't upgrade :)
You can upgrade to version 4.0.17 ;)
It seems you hit the bug that was introduced in 4.0.16, and fixed in 4.0.17.
Look at this: http://www.mysql.com/doc/en/News-4.0.17.html
"Fixed optimizer bug, introduced in 4.0.16, when REF access plan was
pr
Hi,
actually it depends on table type.
Since you said that it will be temp table then I guess it will be MyISAM
table.
In this case it is better to use 2 way:
> 2-nd case: I create table, filling data and then create indexes?
But if you will create InnoDB temp table that (according to Heikki Tuu
Hi,
I am not sure, but may be you had Key_read_requests overflow.
Best regards,
Mikhail.
- Original Message -
From: "John David Duncan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 29, 2004 11:40 PM
Subject: key_reads > key_read_requests
> Hi,
>
> key_reads is
Hi,
"show table status;"
In the last field (Comment) you could find it.
Mikhail.
- Original Message -
From: "Tile Tatonko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 28, 2004 10:48 AM
Subject: available spaci in InnoDB data files !??!
> I need help (ASAP).
Hi,
> I'm newbie in MYSQL. Would please tell me about Mysql Security ?
Generally you can find a lot of information about MySQL on
http://www.mysql.com/doc/en/
About your question you can read here:
http://www.mysql.com/doc/en/Privilege_system.html
Mikhail.
- Original Message -
From:
8:18 PM
Subject: Re: data file too big
> On Fri, 23 Jan 2004, Mikhail Entaltsev wrote:
>
> > Date: Fri, 23 Jan 2004 09:34:52 +0100
> > From: Mikhail Entaltsev <[EMAIL PROTECTED]>
> > To: Gregory Newby <[EMAIL PROTECTED]>, Asif Iqbal <[EMAIL PROTECTED]>
&g
Hi,
I have email from Georg Richter about this problem in my MySQL archive:
From: "Georg Richter" <[EMAIL PROTECTED]>
Hi,
>From http://www.mysql.com/doc/en/Mathematical_functions.html:
Note that the behaviour of ROUND() when the argument is half way between two
in
.
- Original Message -
From: "Massimo Petrini" <[EMAIL PROTECTED]>
To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
Sent: Friday, January 23, 2004 5:11 PM
Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4 from client
running xp
> 1) yes, I am sure
select t2.* from TableTwo t2 left join TableOne t1 on (t2.ID = t1.ID)
where t1.ID is NULL
- Original Message -
From: "Phillip S. Baker" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 23, 2004 7:26 AM
Subject: Comparing Table IDs
> Greetings all,
>
> I have 3-4 tables
> I believe that this will flush those logs:
>
> mysql> reset master;
No.. It won't shrink any of InnoDB datafiles:
> > 101Mib_logfile0
> > 101Mib_logfile1
> > 1.9Gibdata1
> > 1.5Gibdata2
It could help if you have some MySQL binary logs:
-bin.001
...
-bin.00N
Best regards,
Mikha
ver?
Are you sure that your application or someone between doesn't use
connections pool?
Mikhail.
- Original Message -
From: "Massimo Petrini" <[EMAIL PROTECTED]>
To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursd
imo Petrini" <[EMAIL PROTECTED]>
To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, January 22, 2004 11:08 AM
Subject: Re: temporary table in 4.0.17 on Windows W2000 and NT4
> no; because the client have still the result of the query
Hi Massimo,
May be after some minutes of inactivity client closes connection to MySQL
server?
In this case MySQL deletes all temp tables that were created by this client.
Best regards,
Mikhail.
- Original Message -
From: "Massimo Petrini" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sen
Hi,
since MySQL stores stored procs in "mysql" db you need to make backup of
"mysql" db.
But it would be nice to have a possibility to make backup of stored procs in
readable format.
Best regards,
Mikhail.
- Original Message -
From: "Bing Du" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Hi Asbjørn,
try to use "replace" function:
http://www.mysql.com/doc/en/String_functions.html
update YourTable set YourMoney = REPLACE('255,55', ',', '.') where ... ;
Best regards,
Mikhail.
- Original Message -
From: "Asbjørn Konstad" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: M
Hi Leandro,
It is absolutly correct. Please read in doc about timestamp data type
http://www.mysql.com/doc/en/DATETIME.html
The TIMESTAMP column type provides a type that you can use to automatically
mark INSERT or UPDATE operations with the current date and time. If you
Hi,
Look at /usr/local/mysql/support-files directory.
There are several examples of my.cnf files for different configurations
there (my-huge.cnf, my-large.cnf, ...).
Best regards,
Mikhail.
- Original Message -
From: "Kirti S. Bajwa" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Fri
Hi,
try to use "group by" clause in your select, e.g.
select name, city from mytable group by name, city order by name, city;
Best regards,
Mikhail.
- Original Message -
From: "Veysel Harun Sahin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 02, 2004 4:42 PM
Subje
> But you can do DROP table1; DROP table2; DROP table3; etc..
You can do even better:
drop table table1, table2, table3;
:)
Best regards,
Mikhail.
- Original Message -
From: "Arne K. Haaje" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 02, 2004 12:29 PM
Subject: Re
Hi Tom,
Look at the docs:
http://www.mysql.com/doc/en/DROP_TABLE.html
Happy New Year and best regards,
Mikhail.
- Original Message -
From: "tom poe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 01, 2004 8:33 AM
Subject: dropping multiple tables with one command q
Try to change "localhost" in connection string to real IP address or
127.0.0.1.
Actually it is not the fix of the problem it is a workaround.
Best regards,
Mikhail.
- Original Message -
From: "Carlos Andre Moura de Amorim" <[EMAIL PROTECTED]>
To: "Mikha
Hi
You need to install first rpm with "dynamic client libraries
(including 3.23.x libraries)". You can find them on
http://www.mysql.com/downloads/mysql-4.0.html
Best regards,
Mikhail.
- Original Message -
From: "Carlos Andre Moura de Amorim" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
east
one).
>
> You may also wish to send me test program you have been using as a test.
>
>
>
>
> - Forwarded message from Mikhail Entaltsev <[EMAIL PROTECTED]> -
>
> From: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
> To: "MySQL list
Hi Terence,
> Just a dumb question perhaps, but I am looking at upgrading to 5.0, and as
> we are
> happy with the performance and features on 4.1, can we expect the same
> features
> to have the same level of "stability" on 5.0?
I wouldn't expect the same level of stability if you would like to
.
Mikhail.
- Original Message -
From: "Rick Robinson" <[EMAIL PROTECTED]>
To: "'Mikhail Entaltsev'" <[EMAIL PROTECTED]>; "'Mysql'"
<[EMAIL PROTECTED]>
Sent: Tuesday, December 30, 2003 2:27 AM
Subject: RE: 5.0 binary question
Hi,
I have found slides show
http://mysql.progen.com.tr/events/uc2003/slides/stored-procedures.pdf
and examples in mysql-5.0/mysql-test/t/
- sp.test
- sp-error.test
Best regards,
Mikhail.
- Original Message -
From: "Rick Robinson" <[EMAIL PROTECTED]>
To: "Mysql" <[EMAIL PROTECTED]>
Se
Hi,
First of all, thanks a lot.
I have installed MySQL 5.0.0 on my test machine (Suse Linux 8.2 kernel
2.4.20 i586)
and have populated data (~40 InnoDB tables with max. 50 000 000 rows)
So far it works stable and I didn't have any big problem, but I have found
that speed of inserting data is ~3-5
Hi,
I have noticed also that SHOW TABLE STATUS became slower in 5 times at least
(from 1 sec to 5-6 secs).
Since I've switched to version 3.23.53 to version 4.0.14.
But I have changed type of all my tables (~30 tables) from MyISAM to InnoDB
as well.
> How long does an "ls" command in the database
Hi,
> innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
> innodb_buffer_pool_size = 6G
it looks like your InnoDB tablespace is less than 2G.
If it is true then IMHO it doesn't make any sense to allocate 6G for
innodb_buffer_pool.
InnoDB won't use it.
Best regards,
Mikhail.
- Ori
Forgot to mention...
OS is not swapping... The load on MySQL server is the same...
Usually my system has ~100 selects/sec and 0.2 inserts/sec.
And I found that during inserts MySQL uses 100% of CPU,
before it used ~5-10% CPU maximum...
I understand that it's difficult to say what is going wrong
show statusHi all,
I am running MySQL version 4.0.14-standard-log on Suse Linux 2.4.20 i686.
All tables in my db are InnoDB tables.
Today morning I've got troubles with perfomance...
Generally all queries are slower in 4-5 times than usually.
Also I see that number of deadlocks is in 10-15 times
Hi,
I would create one field (char(200) or char(255)) for all criteria.
After that I will store:
in the first byte of that string Y if hotel has swimming pool, N - doesn't
have, Q - no idea
in the second byte of that string Y if hotel has TV, N - doesn't have, Q -
no idea
in the third byte of that
Hi,
If I understand you correctly the this query should help you:
select
date_format(date_add(DateTime, interval 7 hour), "%Y%m%d") as Date,
count(1)
from Table1
group by Date
order by Date
Best regards,
Mikhail.
- Original Message -
From: "Graeme B. Davis" <[EMAIL PROTECTED]>
To:
is that you have put timezone variable into [mysqld]
section,
but you need to put it into [mysqld_safe] section. But I am not sure. Check
it, please.
Best regards,
Mikhail.
- Original Message -
From: "Juan Antonio Ruiz Zwollo" <[EMAIL PROTECTED]>
To: "Mikhail Entalt
Hi,
I am using these lines in my.cnf at [mysqld_safe] section.
[mysqld_safe]
timezone = GMT
It works fine for me.
Best regards,
Mikhail.
- Original Message -
From: "Juan Antonio Ruiz Zwollo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 13, 2003 5:38 PM
Subject: Se
Hi,
You need to use UNION, but it's not possible in version 3.23.*
So it's better to upgrade MySQL server first.
SELECT table1.cod
FROM table1
LEFT JOIN table4 ON table1.cod=table4.cod
WHERE table4.cod IS NULL
UNION
SELECT table2.cod
FROM table2
LEFT JOIN table4 ON table2.cod=table4.cod
WHERE t
Hi,
Does InnoDB use any of these variables:
bulk_insert_buffer_size
join_buffer_size
key_buffer_size
read_buffer_size
read_rnd_buffer_size
sort_buffer_size
table_cache
thread_concurrency
Thanks in advance,
Mikhail.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Edwin,
check this link. Hope it will help you.
http://www.mysql.com/doc/en/Resetting_permissions.html
Best regards,
Mikhail.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 12, 2003 7:22 PM
Subject: How to recovery the root password?
> De
Hi,
IMHO it's nice idea...
http://www.ashleyit.com/blogs/brentashley/archives/000339.html
Best regards,
Mikhail.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I've found the phrase in MySQL documentation
http://www.mysql.com/doc/en/Temporary_table_problems.html
"You can't use temporary tables more than once in the same query. For
example, the following doesn't work.
mysql> SELECT * FROM temporary_table, temporary_table AS t2;"
Does it mean that I
InnoDB does not use fdatasync() or O_DSYNC
because there have been problems with them on many Unix flavors.
**
Mikhail.
- Original Message -
From: Paul Gallier
To: Mikhail Entaltsev ; [EMAIL PROTECTED]
Sent: Tuesday, September 02, 2003 4:24 AM
Subject: Re: InnoDB
Paul,
if your MySQL server is runnign under Linux then try to play with
"innodb_flush_method" variable.
I've changed it to O_DSYNC and InnoDB became ~ 9 times faster (Suse 8.2
Linux 2.4.20-4GB i386).
Also check that you didn't allocate too much memory (OS shouldn't swap).
Best regards,
Mikhail.
a.
>
> Thank you,
>
> Heikki
>
> - Original Message -
> From: ""Mikhail Entaltsev"" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.mysql
> Sent: Thursday, July 24, 2003 3:44 PM
> Subject: InnoDB locking: Different behavior on 3.23.55
Hi
I have 2 MySQL servers:
Server1 is 3.23.55-max-log
Server2 is 4.0.13-standard-log
Let's assume that we have 2 connections (Conn1 and Conn2) and table test:
CREATE TABLE `test` (
`id` int(3) NOT NULL auto_increment,
`name` char(
Hi,
> configure: error: Didn't find the mysql library dir in
I had the same problem and I've fixed it manually (just edit
configure.in file).
In this file path to MySQl library directory is
"/usr/local/mysql/lib/mysql", I changed it to "/usr/local/mysql/lib".
But I had a lot of other problems dur
Hi all,
My MySQL crashed during simultaneous execution of "ALTER TABLE ... ENABLE
KEYS"
and "SHOW TABLE STATUS" statements.
There were 2 threads: #3 and #4.
In thread #4 I executed:
4 Query DROP TABLE IF EXISTS History
4 Query CREATE TABLE History ...
4 Query
Try to use 'concat()' function.
if ('stop' <'start', stop, concat(stop,'+++'))
Best regards,
Mikhail.
- Original Message -
From: "Fabrizio Tivano" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 10, 2003 13:07
Subject: possible query?
>
> hello dear all,
>
> i need
Hi
> mysql> SELECT prezzo, totale FROM ordini WHERE numordine=1157;
> mysql> UPDATE ordini SET prezzo = prezzo/1.024, totale = totale/1.024
> WHERE numordine>1385 AND dataord<'2003-06-01';
You are selecting data for numordine = 1157, but are updating all records
that have
numordine > 1385. 1157
Hi,
I have found one unclear place for me regarding to the timestamp field in
the InnoDB table.
Please, explain me am I correct or not.
Let's say we have a table Test with 'timestamp' field:
CREATE TABLE `Test` (
`id` int(3) NOT NULL auto_increment,
`UpdateDate` timestamp(14) NOT NULL,
PRI
in the documentation.
Thank you.
Best regards,
Mikhail.
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, October 21, 2002 1:20 PM
Subject: Re: Timest
Devi,
As I understand you need to update timestamp field in some tables.
And you have only 4-5 milliseconds for it?
Is it correct? What is the problem?
Best regards,
Mikhail.
- Original Message -
From: "Devi Annisetty" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <
Juha,
select dep.Ref, dep.ActionDate as Departure, arr.ActionDate as Arrival,
dlv.ActionDate as Delivery
from
Table1 dep left join Table1 arr on (dep.Ref = arr.Ref and arr.Timestamp =
'ARR')
left join Table1 dlv on (dep.Ref = dlv.Ref and
dlv.Timestamp = 'DLV')
where
Peter Stöcker" <[EMAIL PROTECTED]>
To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, September 19, 2002 11:56 AM
Subject: Re: Re: JOIN-Question
Hi Mikhail!
The query should be released automaticly and it shoulb be something like:
SELECT a.
Peter,
If you would like to get such resultset
> namefield1 field2 field3field4 field5 field6
> -
> test 12 5 6 9 10
> test 12 5
Check TIMESTAMP type in the documentation.
Best regards,
Mikhail.
- Original Message -
From: "neal" <[EMAIL PROTECTED]>
To: "mySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, September 18, 2002 10:32 AM
Subject: date field - default value = current date
> Is there a wat to have mySQL auto fi
Prafulla,
please check documentation http://www.mysql.com/doc/en/DATETIME.html
"...
The TIMESTAMP column type provides a type that you can use to automatically
mark INSERT or UPDATE operations with the current date and time. If you have
multiple TIMESTAMP columns, only the first one is updated au
Roman,
try to execute this query:
select e.cid,d.amount,dd.amount
from eee e
left join ddd d on (d.cid=e.cid and d.c>=2 and d.c<=3)
left join ddd dd on (dd.cid=e.cid and dd.c=3)
and after that try to group by them manualy. What do you have as result?
Best regards,
Mikhail.
- Original Mess
Xavier,
select
ID,
description,
if (ifnull(date1, 20201231) < ifnull(date2, 20201231), ifnull(date1,
20201231), ifnull(date2, 20201231)) as date
from MyTable
order by date
I didn't test it, but it should work.
Any questions? don't hesitate to ask.
Best regards,
Mikhail.
- Original Mess
Wouter,
set @ID = 173633;
select @Name := Name from MyTable where ID = @ID;
select @Name;
Best regards,
Mikhail.
- Original Message -
From: "Wouter van Vliet" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Wouter @ Witbier" <[EMAIL PROTECTED]>
Sent: Friday, August 30, 2002 5:59 PM
Sub
From: "David Bordas" <[EMAIL PROTECTED]>
To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, August 27, 2002 5:16 PM
Subject: Re: Slow select query, need some clues to speed it up please ...
> ME> In this case...
> ME> Can
- Original Message -
From: "David Bordas" <[EMAIL PROTECTED]>
To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
Sent: Tuesday, August 27, 2002 4:55 PM
Subject: Re: Slow select query, need some clues to speed it up please ...
> ME> :( That's str
ecords in resultset)
and query works much slower...
May be occasionally anybody run another big query in parallel? in other case
I have no idea... :(
Mikhail.
- Original Message -
From: "David Bordas" <[EMAIL PROTECTED]>
To: "Mikhail Entaltsev" <[EMAIL PROTECTED
:(
So...
question: Do you actually need this condition? ;)
Best regards,
Mikhail.
- Original Message -
From: "David Bordas" <[EMAIL PROTECTED]>
To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, August 27, 2002 3:31 PM
IMHO the problem is in this condition
...Field5 LIKE '%John'...
Can you remove it from query and try again?
Mikhail.
- Original Message -
From: "David Bordas" <[EMAIL PROTECTED]>
To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
Cc: <[EMAIL PR
Can you send result of the query, please:
select * from MyTable PROCEDURE ANALYSE();
Mikhail.
- Original Message -
From: "David Bordas" <[EMAIL PROTECTED]>
To: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, Aug
Check the query plan
EXPLAIN SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM
MyTable WHERE
Field7=15 AND Field2=0 AND (Field3 LIKE '%John%' OR Field4 LIKE '%John%' OR
Field5 LIKE '%John') ORDER BY Field6 LIMIT 0,20;
Mikhail.
- Original Message -
From: "David Bordas" <[EMA
> Already done something like optimize :
> myisamchk -v -a -S --sort-records=1 ../data/jeuxvideo/MyTable
And? No result?
Mikhail.
P.S. Can you send a copy to mysql-list, please.
- Original Message -
From: "David BORDAS" <[EMAIL PROTECTED]>
To: "Mikhail E
As first step, try to optimize table with help of
OPTIMIZE TABLE MyTable
command.
Any progress?
Best regards,
Mikhail.
- Original Message -
From: "David BORDAS" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 27, 2002 12:34 PM
Subject: Slow select query, need some clu
select
m.Name,
mp1.Points as Round1,
mp2.Points as Round2,
mp3.Points as Round3,
mp4.Points as Round4,
mp5.Points as Round5
from
member m,
member_points mp1,
member_points mp2,
member_points mp3,
member_points mp4,
member_points mp5
where
m.Id = mp1.Member__id
and m.Id = mp2.M
Robert,
> ... WHERE field LIKE '%search%'
means everything that contains "search".
Examples: "abcsearch", "searchabc", "abcsearchabc".
But it doesn't mean "abcearch", "searcabc", "searc".
Best regards,
Mikhail.
- Original Message -
From: "Robert Macwange" <[EMAIL PROTECTED]>
To: <[EMAI
ame,p.LastName
from Answer a left join Account c on (a.AccountID = c.AccountID) left join
Person p on (c.PersonID = p.PersonID)
:)
Best regards,
Mikhail.
- Original Message -
From: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
To: "Nicolas Ivering" <[EMAIL PROTECTED]
Nicolas,
select a.AnswerID,a.QuestionID,a.Value,a.AccountID,p.FirstName,p.LastName
from Answer a left join Account c on (a.AccountID = c.AccountID), Person p
where c.PersonID = p.PersonID
Best regards,
Mikhail.
- Original Message -
From: "Nicolas Ivering" <[EMAIL PROTECTED]>
To: <[EMA
> I'd like to find all the records that contains this : "wr??"
>
> That's why I did this query : "SELECT * FROM table WHERE rights LIKE
> 'wr??'"
Try to use this one:
"SELECT * FROM table WHERE rights LIKE 'wr%'" (It means everything that
begins from 'wr')
Next point:
'?' - it is not pa
AM
Subject: Re: mysql console buzzer problem
> Mikhail Entaltsev wrote:
>
> >>It's making loud noise on each error. It is *extremely* annoying.
> >>
> >>
> >Try to use these ways:
> >1. -s, --silent option in mysql console. I don't know what doe
n change settings of PC speaker in OS settings.
3. Just turn off speaker totally (remove it from your PC :)
Best regards,
Mikhail.
- Original Message -
From: "Max Morawski" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 16, 2002 10:45 AM
Subject:
Max,
What's wrong with your PC speaker in mysql console?!
I am using the same version and have no problem with it.
Best regards,
Mikhail.
- Original Message -
From: "Max Morawski" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 16, 2002 10:36 AM
Subject: mysql console
> ...I'm really hoping to
> find is a GUI that updates itself on the fly, kind of like the Win2k
> Task Manager processes tab. Anybody got anything like this?
I am really happy with this one http://www.anse.de/mysqlfront/
It can do that and a lot of other nice features.
Best regards,
Mikhail.
Reinier,
> It seems that when i do a select and the result is minimal it uses the
> index(fast about 3 sec), but when the result is much more it is not using
> the index. this results in a lot of disk io and taking to much time.
It is correct, because (http://www.mysql.com/doc/en/MySQL_indexes.h
Oleh,
> SELECT t1.id, Max(t2.data)
> FROM test1 t1 left join test2 t2 ON t1.id = t2.parent_id
> GROUP BY t1.id
> HAVING Max(t2.data) IS NULL;
As temporary solution try to use next query:
SELECT t1.id, Max(t2.data) as MaxData
FROM test1 t1 left join test2 t2 ON t1.id = t2.parent_id
GROUP BY t1.i
* Pushkar Pradhan
> I'm trying to enforce one column of my table to contain strictly 6 chars.
> string. However I've some columns of type VARCHAR (e.g name, etc.) so
> mysql silently changes the column to VARCHAR.
It is ok for MySQL. You can find some info here :
http://www.mysql.com/doc/en/Silen
I had the same problem.
It occurs when you try to load (3.23.51 or higher) dump file to lower
version of MySQL.
Look at this line...
> /*!4 ALTER TABLE mobile_dev DISABLE KEYS */;
As soon as version is not equal 4 everything in comments will be
deleted.
So we have
> ;
empty query.
Mikhai
Hi Mike,
I am not sure, but as I remember Microsoft SQLServer has Import/Export
utility (standard installation) that can import data from different sources
(Oracle?! why not).
Best regards,
Mikhail.
- Original Message -
From: "Mike Townend" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Se
select u.userid , c.companyname from
users u left join company c on (u.companyid = c.companyid)
where u.status = 'ACT'
Best regards,
Mikhail.
- Original Message -
From: "Arul" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Tuesday, July 02, 2002 5:15 PM
Subject: help me with
1 - 100 of 114 matches
Mail list logo
