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: mysql@lists.mysql.com
Sent: Monday, August 08, 2005 4:12 PM
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
Hi Anoop,
In order to validate a date I am using next query:
select date_format(date_sub(date_add('yourdate', interval 1 day), interval
1 day),'%Y%m%d') = date_format('yourdate','%Y%m%d');
It will give you 1 if date is valid.
Best regards,
Mikhail.
- Original Message -
From: Anoop
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
Missed FROM clause... ;)
Best regards,
Mikhail.
- Original Message -
From: Mário Gamito [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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
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
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 where
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 to return
Could you execute show create table 321st_stat and show create table
stat_in
and send results back?
Best regards, Mikhail.
- Original Message -
From: matt ryan [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, August 27, 2004 4:45 PM
Subject: Re: 1 day 28 min insert
Mikhail
: [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 back?
I have no key's on the temp table, stat_in, do you think adding keys
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
: [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 extension that permits
non
Hi,
insert into 321st_stat select * from stat_in group by primary key fields
from 321st_stat table;
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
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]
Sent: Wednesday, May 12, 2004 10:11 AM
Subject: Re: Max
Just
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
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
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
avoid having
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 usually a
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
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:
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).
I'm
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]
Cc: [EMAIL PROTECTED]
Subject: Re: data file too big
I believe that this will flush those logs
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:
hostname-bin.001
...
hostname-bin.00N
Best regards,
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 of
.
- 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 because the problem is reproducible also
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
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]
Sent:
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 on the screen
and
on the server the thread is still
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]
Sent:
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: Monday,
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 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
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,
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
Subject:
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: Friday,
.
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 Mikhail-
Thanks for responding; the presentation is very helpful; However, I
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 use
you have been using as a test.
- Forwarded message from Mikhail Entaltsev [EMAIL PROTECTED] -
From: Mikhail Entaltsev [EMAIL PROTECTED]
To: MySQL list [EMAIL PROTECTED]
Subject: Re: MySQL 5.0.0 has been released
Date: Mon, 29 Dec 2003 14:45:24 +0100
Hi,
First of all, thanks
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]
Sent:
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: Mikhail Entaltsev [EMAIL PROTECTED]
Cc: [EMAIL
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
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]
Sent:
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.
-
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
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
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:
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
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: Setting
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 Entaltsev [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, October
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
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
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]
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?
Dear
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
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.
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 slow?
Thanks
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`
this. You are probably using the query cache in 4.0. Then
SELECT can return immediately without acquiring any locks.
Of course, it can be discussed if the query cache, too, should respect
LOCK
TABLES. I am forwarding this to Sanja.
Thank you,
Heikki
- Original Message -
From: Mikhail
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 to make a
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
Hi
mysql SELECT prezzo, totale FROM ordini WHERE numordine=1157;
mysql UPDATE ordini SET prezzo = prezzo/1.024, totale = totale/1.024
WHERE numordine1385 AND dataord'2003-06-01';
You are selecting data for numordine = 1157, but are updating all records
that have
numordine 1385. 1157 1385.
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 [EMAIL PROTECTED]; Mikhail
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: Timestamp field in the InnoDB table
Mikhail,
- Original
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,
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,
If you would like to get such resultset
namefield1 field2 field3field4 field5 field6
-
test 12 5 6 9 10
test 12 5
[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.*,b.*,c.* FROM ?? WHERE b.field3=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 fill in
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
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
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
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
Subject:
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 =
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 clues to
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 Entaltsev [EMAIL PROTECTED]
Sent
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 [EMAIL
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, August 27, 2002 2:13 PM
Subject: Re: Slow select query
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 PROTECTED]
Sent: Tuesday, August 27, 2002 2:49 PM
Subject
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
Subject: Re: Slow select query, need some clues to speed it up please
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]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, August 27, 2002 4:28 PM
Subject: Re: Slow select query
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 you try again?
Sure.
query 1 :
SELECT Field1,Field2,Field3,Field4,Field5,Field6
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: [EMAIL PROTECTED]
Sent:
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: [EMAIL
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];
[EMAIL PROTECTED]
Sent: Monday, August 19, 2002 10
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
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: Re: mysql console buzzer problem
Mikhail Entaltsev wrote
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 does it mean
(in
doculmentation I found only Be more silent.), but may be it will help
you.
No change.
2. Generally
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 pattern in
* 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 :
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.id
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
...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.
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.
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]
Sent:
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 this
Jesse,
try to make dump (mysqldump) with option --add-drop-table or --opt (it
will be faster).
Description of this options see here
http://www.mysql.com/doc/m/y/mysqldump.html
Best regards,
Mikhail.
- Original Message -
From: Jesse Sheidlower [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Marek,
check this URL http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html
Best regards,
Mikhail.
- Original Message -
From: Marek Wysmulek [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 01, 2002 6:56 PM
Subject: efficiency of mysql 2.23
Dear group.
I have on server Intel
(C.CompanyID) = 2. In
this case it will take:
C.CompanyIDC.B2bCount(C.CompanyID)
77N2
Best regards,
Mikhail.
- Original Message -
From: Arul [EMAIL PROTECTED]
To: Mikhail Entaltsev [EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]
Sent: Saturday, June 29
Jonas,
try to execute this command:
SELECT count(1) FROM table_name;
Result should be 28. Do you have 28?
Mikhail.
- Original Message -
From: Jonas Olofsson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, June 29, 2002 11:20
Subject: Hidden rows in table.
Hi.
I have just
1 - 100 of 109 matches
Mail list logo