rows match as
far as I know), but that made it a little slower (I'd expect that, if
anything). Is there any explanation for why adding wild-cards would
make a search faster?
Thanks in advance!
Matt
P.S. Sergei, if you see this, in one of your replies to my full-text
suggestions back in September
.
*Force* the case used in queries match that of the directory/file
name...
Matt
- Original Message -
From: Reverend Deuce
Sent: Wednesday, December 17, 2003 3:41 PM
Subject: Re: MySQL 4.0.17 has been released
I agree, 100%. We live in a mixed environment of UNIX and Windows
space, you can do so by running
OPTIMIZE TABLE. Be aware that it may take awhile to run on a large
table!
Hope that helps.
Matt
- Original Message -
From: jamie murray
Sent: Wednesday, December 17, 2003 2:42 PM
Subject: high water mark
Guys,
Does mysql record the high water mark
) |
+---+
| Point(1 1)|
+---+
1 row in set (0.00 sec)
Does anyone know what I am missing?
Thanks,
Matt
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003
Hi Vanessa,
I don't think I saw a reply to this...
You can just reconnect to MySQL if you get this error. :-) Trying to
send the query a second or third time may also make the client try to
reconnect again.
Hope that helps.
Matt
- Original Message -
From: Kiky
Sent: Friday
Hi Peter,
You can probably safely have at least 1000-2000 tables in a single
database.
Hope that helps.
Matt
- Original Message -
From: peter
Sent: Friday, November 28, 2003 12:03 PM
Subject: newbie question
Hi
I am a webdesigner/hosting reseller
my question is this:
I am
to TRUNCATE it, I think.
And actually, if you can TRUNCATE the other tables (if the DELETE
privilege allows it), isn't that just as bad as DROPping them? :-)
Matt
- Original Message -
From: adburne
To: [EMAIL PROTECTED]
Sent: Friday, December 12, 2003 11:31 AM
Subject: Temporary tables rights
that helps.
Matt
- Original Message -
From: Chris Elsworth
Sent: Wednesday, December 10, 2003 12:49 PM
Subject: ALTER TABLE .. ORDER BY
Hello,
Just a quickie. Does anyone know if issueing an ALTER TABLE t ORDER BY
c
is as good as an OPTIMIZE TABLE if I know the order I'll mostly
There's no way to hide a row. However, I can think of a zany solution.
Update your tables using a hash of all the data in the row. That way you
don't need an id field.
Fair warning: this is not a GOOD solution but it does address the problem.
Matt
-Original Message-
From: Stéphane
If the the file is on the same machine as your shell is running,
specify --local when running mysqlimport.
Matt
-Original Message-
From: Pawe Filutowski [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 09, 2003 10:27 AM
To: [EMAIL PROTECTED]
Subject: Problem with mysqlimport
I tryed
MySQL doesn't return HTTP error codes.
Your problem is not with mysql but with Dreamweaver's browser not being
pointed at a running webserver. Did you set up Apache (or some other
server) when you set up PHP and prove that both are functioning?
Matt
-Original Message-
From: Lost Idols
Paul,
--local is a valid option for mysqlimport in 3.23.49 according to the
manual. (Source: http://www.cict.fr/app/mysql/manual.html#mysqlimport)
What is the entire command you are using?
Matt
-Original Message-
From: Pawe Filutowski [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December
want to try your fulltext search IN BOOLEAN MODE to see if
that runs any faster. :-)
Hope that helps.
Matt
- Original Message -
From: [EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 9:13 AM
Subject: fulltext search speed issue with SQL_CALC_FOUND_ROWS
I have some_table
Hi Ed,
Yeah, I just installed today's 4.1.1-alpha-nt on Win2k SP3 and get the
same thing. :-( Sucks, 'cause named pipes are a lot faster for me than
TCP/IP. And I was really looking forward to this release. It's just
not the same with TCP/IP. :-(
Matt
- Original Message -
Subject
Hey All-
Are there any query equivalencies to mysqldump? I am looking for a way
to get a complete database dump via php and I don't have access to the
system CLI to run mysql dump.
TIA-
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
://www.php.net/exec
http://www.mysql.com/mysqldump
looks like
$foo = exec(mysqldump database [options]);
I thought about that Jay, but the mysql server is not on the webserver
machine. Any other suggestions?
-Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
On Wed, 2003-12-03 at 15:22, Jay Blanchard wrote:
[snip]
I thought about that Jay, but the mysql server is not on the webserver
machine. Any other suggestions?
[/snip]
phpmyadmin will allow you to connect to the remote MySQL server and do
dumps
What if I don't have phpmyadmin available?
that it can be searched by the site administrators.
There would also be an original copy of the word doc uploaded to the
server.
Is there a way of doing this?
Cheers,
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi Scott,
Those aren't processes. There is 1 process with many threads and your
system is reporting them as separate processes. :-)
Hope that helps.
Matt
- Original Message -
From: Scott Stingel
Sent: Monday, December 01, 2003 4:47 PM
Subject: mysql 'start' spawns 10 instances
.
For ENABLE KEYS, I think myisam_sort_buffer_size is the important
variable.
Also note: DISABLE/ENABLE KEYS doesn't work in 3.23, but you can do the
same thing using myisamchk.
Hope that helps.
Matt
- Original Message -
From: mos
Sent: Thursday, November 27, 2003 3:44 PM
Subject: RE: Index
? last_response or whatever. Then you have everything you
need right in 1 table and just have to UPDATE the last_response when a
response is made.
Hope that helps.
Matt
- Original Message -
From: brfg3 at yahoo
Sent: Thursday, November 27, 2003 1:00 PM
Subject: list, order and limit data
MySQL
| general |
| 4 | general |
| 5 | inhouse |
| 6 | inhouse |
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Chris,
It doesn't take MySQL any more or less time to update a unique index
than a non-unique one. :-)
Hope that helps.
Matt
- Original Message -
From: Chris Elsworth
Sent: Wednesday, November 26, 2003 12:14 PM
Subject: Unique Index efficiency query
Hello,
Let me just
of that with FLOOR(expr) or TRUNCATE(expr, 0).
Hope that helps.
Matt
- Original Message -
From: Mark Marshall
Sent: Thursday, November 20, 2003 11:05 AM
Subject: Re: Why does -1 show up as 18446744073709551613?
That would be it!
Not sure how I missed that.
Thank you!
Mark
many rows will match
and see if the index can be used. Until then, you have to use (a b OR
a b) if you want it to be optimized.
Matt
- Original Message -
From: [EMAIL PROTECTED]
Sent: Thursday, November 20, 2003 10:12 AM
Subject: strange difference between a != b and (a b OR a b
operators.
Matt Griffin
Software Developer
Nerac, Inc.
One Technology Drive
Tolland, CT 06084
phone: 860-872-7000, ext. 328
[EMAIL PROTECTED]
www.nerac.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
until it's committed, and we would need to convert
the tables on the master without the slaves knowing about it...
Anybody doing anything like this? Or am I simply barking up the wrong tree?
-Matt-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
log on the master until they
are committed, so that's already taken care of. (Rolled back transactions
never appear in the binary log.)
-Matt-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
You can combine those 2 UPDATEs like this:
UPDATE some_table SET some_field=IF(id=some_id, 1, 0);
Or, the standard SQL syntax:
UPDATE some_table
SET some_field=CASE id WHEN some_id THEN 1 ELSE 0 END;
Hope that helps.
Matt
- Original Message -
From: [EMAIL PROTECTED]
Sent
Hi Jon,
The -log suffix is added when you're running with logging (log or
log-bin in my.cnf/my.ini). log-bin may be being used for replication, so
be careful about removing it. And if one server isn't using logging, you
probably don't need it.
Hope that helps.
Matt
- Original Message
this problem.
Also could be disk based if the query examines many rows (large temp
table), but your tmp_table_size would probably cover that.
BTW, 512M is very, very high for tmp_table_size! Do you have enough
memory for 512M * number of connections? :-)
Matt
- Original Message -
From
.
Have you seen this page in the manual:
http://www.mysql.com/doc/en/Delete_speed.html What's the size of your
key_buffer? Might want to increase it.
Also make sure the table doesn't have any unnecessary indexes to make
DELETEs slower.
Hope that helps.
Matt
- Original Message -
From
Hi Yves,
http://www.mysql.com/doc/en/JOIN.html
table_reference [INNER | CROSS] JOIN table_reference [join_condition]
The [ ... ] means that INNER is optional -- in MySQL at least, not
sure about the SQL standard.
Hope that helps.
Matt
- Original Message -
From: Yves Goergen
Sent
that would be hard to work
around is stemming (waiting for that to be implemented internally).
-( Or are you just doing stemming to save space in the index and not for
functionality?
Hope that helps.
Matt
- Original Message -
From: Mike Boone
Sent: Wednesday, November 19, 2003 12:08
exists in 4.0.16. Until you can use
another version, I guess you'll have to use USE INDEX. :-/
Hope that helps.
Matt
- Original Message -
From: Rob Brackett
Sent: Tuesday, November 18, 2003 4:33 PM
Subject: Optimizer Troubles
I've got a table with two indices -- one is a datetime
Hi Thai,
I think you're just joining wy too many tables! LOL
Matt
- Original Message -
From: Thai Thanh Ha
Sent: Sunday, November 16, 2003 8:10 PM
Subject: Please help DB Error: unknown error
Hi all,
I have a problem with my query on mySQL 4.0.
DB Error: unknown error
I
Hi Gunnar,
I agree, this should be optimized.
It says in the Internals manual, I believe, that the code already exists
(in what version(s) I don't know) to optimize such searches on multiple
indexes but it just isn't implemented yet. Hopefully it will be soon...
Matt
- Original Message
Hi Stephen,
You can always omit the connection id in PHP (unless you have multiple
connections open for some reason).
Matt
- Original Message -
From: Stephen Fromm
Sent: Monday, November 17, 2003 8:26 AM
Subject: php and passing implicit connection identifiers
The connection
system can handle files 4GB):
ALTER TABLE your_table MAX_ROWS=1000
AVG_ROW_LENGTH=1024;
The MAX_ROWS and AVG_ROW_LENGTH values don't matter as long as their
product is greater than 4,294,967,295.
Hope that helps.
Matt
- Original Message -
From: Niran Angkawattanawit
Sent
Hi Joe,
No, I don't know exactly. Releases usually come out at about the same
interval. So going by previous releases, I would say 4.0.17 should be
released within 2-4 weeks -- probably shortly after 4.1.1.
Matt
- Original Message -
From: Joe Lewis
Sent: Friday, November 14, 2003 11
the only word you're trying to match? I just tried it and
I can't get somebody\'s to match even as a phrase in BOOLEAN mode
because the somebody part is a stopword. However, Matt\'s works. If
you can't match a non-stopword, are you sure the correct amount of
backslashes are making it to MySQL
happen for you guys unless you're getting tons of
connections/second. I'm pretty sure there was another issue that was
throwing the count off.
I guess you'll have to see if it's fixed in the next release (4.0.17).
Sorry I can't remember more details.
Matt
- Original Message -
From: Joe
without downloading the source, I can send it
to you. :-)
Hope that helps.
Matt
- Original Message -
From: Jason Ramsey
Sent: Thursday, November 13, 2003 4:08 PM
Subject: Format of stopwords file
In the docs is says that you can define your own stopwords file for
fulltext
searching
. Never, ever
any need for stripslashes(), etc. if it was inserted correctly. :-)
Hope that helps.
Matt
- Original Message -
From: Jason Ramsey
Sent: Thursday, November 13, 2003 4:10 PM
Subject: Backslash and full text searches
We make extensive use of full text searches, but have run
Hi Tony,
shell perror 143
Error code 143: Unknown error
143 = Conflicting table definition between MERGE and mapped table
Matt
- Original Message -
From: [EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 4:00 PM
Subject: Merge Tables not working...
Hello,
I've posted
Hi Scott,
This kind of ordering thing has come up before and there's never a great
answer I don't think.
You could try this ORDER BY
ORDER BY l.age + 0.0, l.age, l.date
But I think that might cause sorting problems if age has leading 0s.
Maybe not...
Matt
- Original Message -
From
Hi Gabriel,
No, the order of the WHERE clause shouldn't have anything to do with how
the query is executed. The only exception may be if MySQL thinks 2
different ways of doing something are of equal cost. In that case it may
choose one or the other depending on how the query is written.
Matt
as it will probably arise again in the future?
Thx-
Matt
On Tue, 2003-11-11 at 21:35, Matt W wrote:
Hi Matt,
So one database disappeared all of a sudden while the others are OK?
Is MySQL running on FreeBSD? If so, that'll be the problem :-) and we'll
point you toward the fix.
Matt
- Original
Hi Karam,
Comments per *column* were added in 4.1.0.
Comments per *table* were added in 3.23.0.
http://www.mysql.com/doc/en/News-4.1.0.html
http://www.mysql.com/doc/en/News-3.23.0.html
Hope that helps.
Matt
- Original Message -
From: Karam Chand
Sent: Monday, November 10, 2003 11
Hi Nathan,
I don't think there's a way if MySQL is on a separate machine, as I'm
only aware of checking in PHP.
Hmm, maybe you could create a dummy table and see if it's case-sensitive
or not? He he.
Just curious, why would you need to know what OS MySQL is on?
Matt
- Original Message
query (since Windows uses \r\n to represent newlines).
So the inserted data would be one byte longer, even though it looks the
same.
For this reason, mysqldump (and others) always uses the first version,
to insure that the restored data is *exactly* the same.
Hope that helps.
Matt
- Original
Hi All-
I am running 4.0.15-standard on RH9. My mysql database just stopped
working, is there a way I can log information about why it stops like
this? the *.err was unhelpful.
Any help here is appreciated. Thanks
-Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
restart' and it started working again like
magic. I looked in the .err file and it only shows when the mysql server
stops and starts. I can't see the file on this machine, but it just
seems to be logging starts and stops.
Thanks for the reply hope this helps-
Matt
On Tue, 2003-11-11 at 19:20, Dathan
Hi Matt,
So one database disappeared all of a sudden while the others are OK?
Is MySQL running on FreeBSD? If so, that'll be the problem :-) and we'll
point you toward the fix.
Matt
- Original Message -
From: Matt Babineau
Sent: Tuesday, November 11, 2003 3:28 PM
Subject: RE: Mysql
that LIKE will be faster than the LEFT() function even
if there is no index.
Matt
- Original Message -
From: Erik Osterman
Sent: Tuesday, November 11, 2003 6:39 AM
Subject: RE: Aliases
However, you can use HAVING. HAVING is post-processed, in a brute force
method (no indexes can
queries differ too much that the cache can't be used?
Hope this helps.
Matt
- Original Message -
From: Jeremy Zawodny
Sent: Saturday, November 08, 2003 11:48 PM
Subject: Re: Strategies for optimizing a read-only table
On Tue, Nov 04, 2003 at 08:45:08PM -0500, Jonathan Terhorst wrote
Hi Herb,
You should be able to specify 255 as the PRI KEY length... I think.
CREATE TABLE table (
col TINYBLOB NOT NULL,
PRIMARY KEY (col(255))
);
Hope that helps.
Matt
- Original Message -
From: Herb Rubin
Sent: Friday, November 07, 2003 10:50 AM
Subject: Re: aes
a char(16) binary would work fine as well?
No, since it's a CHAR, trailing spaces would still be removed on
retrieval. BINARY would only make it case-sensitive, not change the
behavior of CHAR.
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Hi,
Yes, that's what I was gonna say. It's not in 4.1.0 because it was
released *before* 4.0.13.
Matt
- Original Message -
From: Jeremy Zawodny
Sent: Friday, November 07, 2003 6:45 PM
Subject: Re: Can't set myisam_repair_threads
On Fri, Nov 07, 2003 at 02:00:39PM +0100, Eric Jain
Hi Jon,
I know, it's been sooo long! :-( But from what's been said on this
list, and since it says To be released soon in the ChangeLog, I would
expect it within the next 2 weeks.
I'm hoping 4.1.2 or 4.1.3 will be upgraded to Beta status. :-)
Matt
- Original Message -
From: Jon
. The additional index is just wasting
space. Drop this index before you run the OPTIMIZE. :-)
ALTER TABLE campaign_t DROP INDEX acct_id;
OPTIMIZE TABLE campaign_t;
Matt
- Original Message -
From: Eric Anderson
Cc: [EMAIL PROTECTED]
Sent: Thursday, November 06, 2003 1:45 PM
Subject: RE
Hi Bernd,
I think you should be able to use a column type such as
field FLOAT(10, 4) ZEROFILL NOT NULL
You might want to change the numbers 10 and 4 depending on how many
leading/trailing 0s you want.
Matt
- Original Message -
From: Bernd Tannenbaum
To: [EMAIL PROTECTED]
Sent
to match that. Are you
trying to match a NUL byte? Or are you trying to match ASCII 17 or
something?
Hello matt,
i am trying to match a binary string (with binary data) against a
column of type
MEDIUMTEXT/MEDIUMBLOB that contains binary data...
I know. :-) I didn't know, though, if you wanted
Hi,
I think log-slow-queries belongs in the [mysqld] section of my.cnf, not
[mysqld_safe].
Hope that helps.
Matt
- Original Message -
From: MaFai
To: [EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 9:00 PM
Subject: Slow query log setting
Hello, mysql,
I have set the slow
Hi Holly,
SHOW INDEX FROM table;
or
SHOW CREATE TABLE table;
are 2 different ways to see indexes -- in different formats.
For reference: http://www.mysql.com/doc/en/Show_database_info.html
Hope that helps.
Matt
- Original Message -
From: Holly Chamberlain
To: [EMAIL PROTECTED
Hi George,
What are you actually trying to match with \017? As far as I know, it's
treating the \0 part as a NUL byte and trying to match that. Are you
trying to match a NUL byte? Or are you trying to match ASCII 17 or
something?
http://www.mysql.com/doc/en/String_syntax.html
Matt
. But if not.
Maybe I should ask on the Internals list sometime.
Matt
- Original Message -
From: Alexis Guia
Sent: Wednesday, November 05, 2003 5:30 AM
Subject: RE: mysql memory usage
Sorry, but I disagree :/
I always used 250MB of key buffer, and MySQL never allocates more than
be as fast as putting it on a RAM disk
or whatever people might suggest.
Matt
- Original Message -
From: [EMAIL PROTECTED]
To: Arnoldus Th.J. Koeleman
Cc: [EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 11:03 AM
Subject: Re: Table in Memory
Maybe look at using a HEAP table? Load
threads (which shouldn't be much
harm, except for a bit of memory usage), don't use persistent
connections, or lower the wait_timeout and/or interactive_timeout server
variables to have MySQL disconnect idle clients sooner.
Hope that helps.
Matt
- Original Message -
From: Jobs PHP
all
queries complete that were running (the 2 Sorting result queries in
your case). Why are those 2 queries running for over 1 and 2 minutes?
Must be examining many rows and/or not indexed properly (if there's a
WHERE that could use an index)...
Hope that helps.
Matt
- Original Message
sort to keycache after awhile -- something
to do with the size of the indexes or something. Not exactly sure about
the criteria.
No idea about InnoDB, but I would guess that it'd be slower? Does
DISBALE/ENABLE KEYS even do anything with InnoDB, or just MyISAM? Hmm.
Matt
- Original Message
that?
---
Quoting Matt Babineau [EMAIL PROTECTED]:
Check out SQLYog, could can connect and copy databases...pretty much
like MSSQL Enterprise manager. They have a trial version on their site:
http://www.webyog.com/sqlyog
On Mon, 2003-11-03 at 19:51, Matt Fletcher wrote:
Hi there,
I
-10-01'
(e.g. the time part is always there), so because of that, it may not
include any rows with a month of 10. Maybe that is what Brent meant. :-)
I was thinking of LIKE instead of BETWEEN: ... WHERE ApacheDate LIKE
'2003-09%'; I think that's correct.
Matt
- Original Message -
From
() LIMIT 1');
Hope that helps.
Matt
- Original Message -
From: Payne
Sent: Tuesday, November 04, 2003 10:33 AM
Subject: RAND ()
Hi,
I have been playing around with RAND(). It works very well if I do a
sql
statement with mysql, but I having problem using with mysql statement
and ApacheDate in the
WHERE, it chose the url index, which tells me that it's more restrictive
than ApacheDate. In which case, it should still be better to composite
index (url, ApacheDate). :-)
Try it both ways to be sure and see what's faster.
Matt
- Original Message -
From: sean peters
Hi Richard,
Correct. A single thread can only run on 1 CPU at any given time, even
though the OS may switch the thread between CPUs over time.
Matt
- Original Message -
From: Richard Bewley
Sent: Saturday, November 01, 2003 9:48 PM
Subject: RE: mySQL with a quad processor system
succeeding column)
or
CASE @type
WHEN equity THEN
[do this complete INSERT statement
WHEN equity THEN
[do this different INSERT statement
WHEN equity THEN
[do this INSERT statement
or
none of the above
Matt Young
EverydaySoftware.biz
--
MySQL General Mailing List
For list archives: http
Hi there,
I have taken the plunge and dropped windows in favour of linux. My
question is what is the best way to get the data from my windows mysql
databases into linux? Can I just copy some files from one partition to
another or what?
Thanks,
Matt
--
MySQL General Mailing List
For list
Check out SQLYog, could can connect and copy databases...pretty much
like MSSQL Enterprise manager. They have a trial version on their site:
http://www.webyog.com/sqlyog
On Mon, 2003-11-03 at 19:51, Matt Fletcher wrote:
Hi there,
I have taken the plunge and dropped windows in favour of linux
Hi,
I believe the row limit is 4,294,967,295... or is it 4 billion even?
Hmm.
Hope that helps.
Matt
- Original Message -
From: joffrey leevy
Sent: Sunday, November 02, 2003 7:41 PM
Subject: theoretical row/record limit of mysql?
Hi all:
Does anyone know the maximum number
count more towards that limit than a TINYTEXT one, even though
they can store the same amount.
Hope that helps.
Matt
- Original Message -
From: Mike Kuhnkey
Sent: Saturday, November 01, 2003 10:40 AM
Subject: Too Many Columns ERROR 175..
What is the relationship between column name
Hi Richard,
Nope, since your OS can run the threads on different CPUs (unlike
FreeBSD w/o LinuxThreads for example). You just need 4+ threads
(clients) running queries at once. :-)
BTW, what kind of system? How fast are those 4 CPUs? ;-)
Matt
- Original Message -
From: Richard
what's best for you, I'm just trying to help.
Yeah, thanks for trying to help!
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
it. :-)
Matt
- Original Message -
From: Avenger
Sent: Wednesday, October 29, 2003 1:41 AM
Subject: Re: Limit Optimization??
That sooo cool... It was the very perfection of beauty.
but i didnt' know.why my index (ClassID, Auditing, CreatedTime) are
slowly as matt's (ClassID, Auditing
Hi,
No, col BETWEEN 'A' AND 'D' is not the same as col = 'A' AND col 'D'.
BETWEEN is equivalent to col = 'A' AND col = 'D'. One will include
cols that equal 'D' and the other won't. :-)
Matt
- Original Message -
From: Brent Baisley
Sent: Thursday, October 30, 2003 3:12 PM
Subject: Re
values).
If you're using MySQL 3.23, I've noticed that the query parser seems
much, much faster in 4.0.
Matt
- Original Message -
From: Knepley, Jim
Sent: Thursday, October 30, 2003 4:48 PM
Subject: WHERE IN performance
Is it anyone elses experience that queries with large IN stanzas
faster than any
OPTIMIZED/non-split dynamic ones.
Oh yeah, also, when I *know* a column will always have n chars, it
should stay CHAR(n), not be changed to VARCHAR(n). An example is columns
with MD5 values. A CHAR(32) would take 32 bytes; VARCHAR(32) uses 33
bytes. :-( :-(
Matt
- Original
on the table? The last
lines of SHOW CREATE TABLE table; with the KEY definitions is fine.
Matt
- Original Message -
From: avenger
Sent: Monday, October 27, 2003 10:24 PM
Subject: Re: Limit Optimization??
good job!!
it short my query time from 30 sec to 0.6 sec.
IOW,now i can not use
);
And then the query should only use the index for execution. Then you can
of course run the second query to get all columns you want:
SELECT * FROM article WHERE ArticleID IN (Comma seperated list of
ArticleIDs from first query) ORDER BY CreatedTime;
Hope that helps!
Matt
- Original Message
around column/index names. Use the -Q or --quote-names
option with mysqldump if you want it to.
How was the reserved name allowed in the first place? Because it must
have had backticks around it -- probably from something stupid like
phpMyAdmin that always puts backticks around everything. :-(
Matt
this problem
also. Can someone tell me if this is true or am I thinking wrong? Hmm.
Hope that helps.
Matt
- Original Message -
From: Larry Brown
Sent: Monday, October 27, 2003 4:29 PM
Subject: RE: I can't figure out what I thought would be a simple query..
I'm interested to see what kind
Hi Mike,
For the corruption, upgrade to 4.0.16, since it may be caused by a
corruption bug in versions before 4.0.15.
Matt
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, October 27, 2003 12:07 PM
Subject: RE: Corruption and weird service terminations
Hi George,
I think the MySQL-Max RPM is dynamically linked (all -max binaries
actually) if you want to give it a try.
Hope that helps.
Matt
- Original Message -
From: George Chelidze
Sent: Monday, October 27, 2003 9:18 AM
Subject: CREATE FUNCTION problem
Hello, I have created new
id FROM table ORDER BY id LIMIT 150, 20;
Then take the first and last of those ids and run this query to get the
other columns:
SELECT * FROM table WHERE id BETWEEN @low_id AND @high_id ORDER BY id;
Hope that helps.
Matt
- Original Message -
From: avenger
Sent: Monday, October 27
Hi,
What version of MySQL are you using? Maybe it's because of a corruption
bug in versions 4.0.3 - 4.0.14. Try upgrading to the latest version.
Hope that helps.
Matt
- Original Message -
From: Datatal AB - Gauffin, Jonas
Sent: Monday, October 27, 2003 6:40 AM
Subject: cause
than science. Any comments much
appreciated!!
Mark
I would also suggest upgrading to MySQL 4 for speed improvements. And
don't forget to set query_cache_size to 32M or so! :-)
Hope that helps.
Matt
(p.s. heres the full list of changes for 24 hours:
Aborted_clients 11
Hi Hector,
Umm, it looks like you're simply doing a SELECT in the first query and
*populating a new table* in the second. Of course inserting 3.3 million
rows is going to take extra time! How can you even compare the 2 when
they're doing different things?
Matt
- Original Message
Hi Mike,
Simple; you don't. :-) Someone please correct me if I'm wrong.
BTW, this isn't a Windows specific question, so I'm sending it to the
General list too.
Regards,
Matt
- Original Message -
From: Mike Karplus
Sent: Friday, October 24, 2003 5:04 PM
Subject: selecting from two
of c code.
To gain access to the development environment, click Develop on the left from
of the opening page.
Matt Young
Everyday Software
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
wish ft_max_word_len_for_sort
would be restored or I'm going to have problems. :-(
Thanks for your time!
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
301 - 400 of 661 matches
Mail list logo