related queries in the general query log. Does the general
log include invalid SQL?
I've also tried to use the driver logging, but on Windows it overwrites
with the last SQL command so I cannot get a good capture as requests are
sent to the DB.
DB is MySQL 5.0.x
you can try MySQL proxy
--
Sebastian
, but don't forget to run mysql_convert_table_format after upgrade
(beside mysql_fix_privilege_tables)
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Now i do not know what to do,Can someone help me?
My english is not well.Do i speak clearly?
take a look into your mysql error log, windows event viewer
most common reason for not starting mysql is missconfigured InnoDB
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http
Hi,
for all you people out there loving phpMyAdmin ;-)
please visit http://hackontest.org and vote for or suggest your favorite
feature you would like to see in phpMyAdmin and that can be implemented
within 24 hours by a team of three
Thank you very much!
--
Sebastian Mendel
--
MySQL
?
SELECT `sales_date`, COUNT(*)
FROM `sales_activity`
WHERE `sales_type` = 1
GROUP BY `sales_date`
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
exactly is the problem?
What exactly did you tried? What was the error?
How are the foreign keys defined?
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
lettercase conversion, convert the
string to a non-binary string:
mysql SET @str = BINARY 'New York';
mysql SELECT LOWER(@str), LOWER(CONVERT(@str USING latin1));
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
| Using where |
++-+---+--+--+--+-+--+--+-+
1 row in set (0.05 sec)
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
your quotes are wrong, did you tried
mysql -u $DBUSER --password=$DBPASS --batch --execute=update
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
) |
+---+
| 85232 |
+---+
1 row in set (0.97 sec)
rows is how many rows MySQL thinks it must examine to execute the query,
not the number of rows possible returned
http://dev.mysql.com/doc/refman/5.1/en/using-explain.html
--
Sebastian Mendel
--
MySQL General Mailing List
For list
= copy_low.pk
AND copy_low.date 100
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
into the
eAccelerator cache but the resource returned by eA does not appear to
be recognised by mysqli_fetch_assoc.
than you need to fetch the result, and store this result like any other
array, but not the resource
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
AND T.val = Q.val
HAVING ISNULL(Q.ID)
OR ISNULL(T.ID)
)
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
??
with SET NAMES, you tell MySQL which charset it should use to return content
to you, or which charset has the content you send to the server
http://dev.mysql.com/doc/refman/5.1/en/charset-connection.html
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http
`) FROM `domain_payments` GROUP BY `Domain`)
you can also save this as a VIEW
btw. `Domain` should have an index, and i think `Invid` and `Custid` too
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
MySQL is doing, with times
you could also prioritize background processes instead of desktop processes
to speedup MySQL start
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jack Bates schrieb:
Given columns a, b, and c, where I GROUP BY a, how do I get the value of
column b in each group which corresponds to the maximum value of column
c?
http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group-row.html
--
Sebastian Mendel
--
MySQL General Mailing
Hi,
is there a way or a function like NOW() except it returns the client time
and not the server time?
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Paul DuBois schrieb:
On May 7, 2008, at 4:36 AM, Sebastian Mendel wrote:
Hi,
wouldn't it be very helpful if mysql connectors support some sort of
per session persistent connection?
this would save a lot of queries in many apps, for example SET NAMES,
setting variables, creating temporary
this?
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
isn't this the general mysql list? isn't mysqlnd maintained by mysql?
Michael Dykman schrieb:
This is a little off-topic for this list (recent PHP tutorials
nowithstanding)... replying offline
On Wed, May 7, 2008 at 5:36 AM, Sebastian Mendel
[EMAIL PROTECTED] wrote:
Hi,
wouldn't
with numeric ISBN
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
will be omitted, and writes/reads go
directly to the disk and not the RAM (cache)
you do not need to worry about loosing data caused by a full cache
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Ananda Kumar schrieb:
Hi All,
I am using mysql 5.0.41 on debain.
I have 8 processor, 8 GB RAM.
I have atable with 95 Million records, each day there will be about 1.5
Million records deleted, and around 3.5 Million records added using LOAD
FILE script.
Since there would daily deletes happening,
to search this index ...
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
at this problem for the whole day and did not make
much of a progress. If someone has any idea how to resolve this problem,
I'll appreciate a tip greatly.
a similar question was just answered on this list about 15 hours before your
question ...
http://lists.mysql.com/mysql/212457
--
Sebastian
(TO_DAYS([Q_start]),
TO_DAYS([date_start]))
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
bet is to
rewrite the query as UNION clauses with one of your WHERE conditions
in each. I know it sounds crazy, but before MySQL 5 the use of
indexes with OR queries was not very good.
IMHO not in this case, cause it is just a simple WHERE field IN ()
--
Sebastian Mendel
--
MySQL General Mailing
', '$rcpt_dom');
you could also vary with thee index length if wite_what.
and what indexes do you have currently exactly?
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
in my personal E-mail address also.
$username instead of '$username'
same for '$password'
but what has this to do with MySQL???
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
this to do with MySQL???
If the above works I want to use mssql_connect command.
mssql extension for PHP has absolutely nothing to do with MySQL, or?
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
D Hill schrieb:
On Thu, 24 Apr 2008 at 08:58 +0200, [EMAIL PROTECTED] confabulated:
D Hill schrieb:
I have something I am trying to resolve with an over abundant number
of slow queries. Perhaps it is because of some additional indexes
needed. As soon as I enabled the option
,
Thanks again for the tip! Have a great day.
oh, yes, for sure, sorry, my mistake! :-)
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
and/or rebuild the indexes?
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
is the right value )
I was wondering why it didn't gave me the same value and after some
time doing a select max gave me the right value Y
seems your index was corrupted
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
ON items.id = taggings.item_id
INNER JOIN tags
ON tags.id = taggings.tag_id
AND tags.name = 'blue'
AND tags.name = 'red';
or
SELECT DISTINCT items.*
COUNT(items.id)
FROM [your join above]
WHERE tags.name IN ('blue', 'red')
HAVING COUNT(items.id) = 2;
--
Sebastian
liaojian_163 schrieb:
thank you Sebastian!
I have re-created the table.there are not any problems in the table.
if the table is new,need to rebuild de indexes?
no
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
/innodb-init.html
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
://www.pastie.org/185419
You can generate the values with the integers table.
http://www.xaprb.com/blog/2005/12/07/the-integers-table/
i knew that you would answer this ... ;-)
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Hiep Nguyen schrieb:
hi list,
reading manual on mysql regarding auto_increment with multiple-column
index:
CREATE TABLE animals (
grp ENUM('fish','mammal','bird') NOT NULL,
id MEDIUMINT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
PRIMARY KEY (grp,id)
);
INSERT INTO
Sebastian Mendel schrieb:
Hiep Nguyen schrieb:
hi list,
reading manual on mysql regarding auto_increment with multiple-column
index:
CREATE TABLE animals (
grp ENUM('fish','mammal','bird') NOT NULL,
id MEDIUMINT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
PRIMARY KEY
. It would even have the same IP address.
additionally, depending on data size it could much more easier to just
install our old HDD into the new server ... whether copy the data to the new
HDD or sue the old ones ...
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http
on all versions, and the example is from the MySQL manual
http://dev.mysql.com/doc/refman/5.1/en/example-auto-increment.html
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
set pic1=%s where id=%s;'
instead of
'update products set pic1=%s where id=%s, ;'
or even without ';' too
and is this some sort of prepared statement, or are the parameters escaped
somewhere else?
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
'
SELECT DISTINCT items.*
FROM [your join above]
WHERE tags.name IN ('blue', 'red');
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Pam Astor schrieb:
Hi,
I have about a half dozen small databases associated with a
couple of small shopping carts, discussion forums, etc. All six databases have
usernames and
passwords associated with them, and all the databases are connected to the php
based forums and shopping carts, no
the second non root user I created –
it has just one line and shows localhost as the host. All the rest of the
users I created show the
% character in the host column.
would be much more easier if you would send this output here (with faked
names, passwords and hosts ...)
--
Sebastian
Sebastian Mendel schrieb:
Hiep Nguyen schrieb:
hi all, i have an existing database (internal) with a user named
'admin', everything works fine as far as privileges concern.
i just created a new database (test) and want to grant admin's
privileges on test as same as internal.
how do i do
Changying Li schrieb:
why does mysql use group_id index ?
because in this case group_id would be faster than user_id
but in fact group_id is very slow (51.21 sec), user_id is (0.00 sec)
ok, at least MySQL does think so
I know, but I what I really want to know is how does mysql think so ?
Jonathan Mangin schrieb:
I'm trying to total certain nutrients consumed on a given date
(though I've removed date temporarily).
You'll see I have three items (in two meals) in itemized,
and two meal totals in simple.
mysql select id, item, carb from my_menu where id in (10, 11, 22);
case
when table names are in uppercase you have also write this in your queries:
select * from TABLE_NAME
or read:
http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Perrin Harkins schrieb:
On Tue, Apr 15, 2008 at 4:21 AM, Sebastian Mendel
[EMAIL PROTECTED] wrote:
use UNION
You can't use UNION to add the results of two queries. It would
return two rows.
of course!
you need to use this UNION as subquery
sorry for being not imprecise
--
Sebastian
Chris W schrieb:
I have the following query...
SELECT c.NLCID, n.publishdate
FROM newsletter n
JOIN newslettersection s using (NLID)
JOIN newslettercontent c using(NLCID)
WHERE contenttype = 1 AND n.publishdate AND c.`timestamp` = '-00-00
00:00:00'
I want to run an update on
Hiep Nguyen schrieb:
hi all, i have an existing database (internal) with a user named
'admin', everything works fine as far as privileges concern.
i just created a new database (test) and want to grant admin's
privileges on test as same as internal.
how do i do this???
i tried (as root):
Tristan Marly schrieb:
First, thanks for all your suggestions and for beeing so reactive.
@Martin: the explain result was in attachment, but you will have more results
in this current mail.
@Rob: you are right, the 'show index' shows strange things, cf. below.
@Rodolphe: indeed the
Changying Li schrieb:
Hi. there is a table photo and two queries:
mysql show index from photo;
mysql
show index from photo;
Changying Li schrieb:
Sebastian Mendel [EMAIL PROTECTED] writes:
Changying Li schrieb:
Hi. there is a table photo and two queries:
mysql show index from photo;
mysql
Products ON Products.ProductID =
ProductsPurchases.ProductIDGROUP BY Products.ProductID ORDER BY
varProductCount+Products.ProductReviewDESC
ORDER BY COUNT(ProductsPurchases.ProductID)
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Neil Tompkins schrieb:
Hi
I want to order by the totalled fields varProductCount and Products.ProductReviewDESC
just put them together, separated with comma, like it is written in the manual
ORDER BY varProductCount + Products.ProductReviewDESC,
COUNT(ProductsPurchases.ProductID)
--
MySQL
Sebastian Mendel schrieb:
Neil Tompkins schrieb:
Hi
I want to order by the totalled fields varProductCount and
Products.ProductReviewDESC
just put them together, separated with comma, like it is written in the
manual
ORDER BY varProductCount + Products.ProductReviewDESC,
COUNT
Neil Tompkins schrieb:
Thanks Sebastian, but I now get the error message
[MySQL][ODBC 3.51 Driver][mysqld-3.23.58]Invalid use of group function
i am not familiar with ODBC or MySQL 3.x
but possible just GROUP BY is missing
check the manual for your mysql version for the exact syntax
if
Malka Cymbalista schrieb:
Thanks for your reply. When I do show grants, I get back
GRANT SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO 'super' @ 'localhost' ( mailto:super'@ 'localhost' ) identified by password...
So it looks like super doesn't have rights to select
Carlos Savoretti schrieb:
Hi all!
Well, question is how could I to retrieve information about
types supported.
IMHO, no
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Brown, Charles schrieb:
Here is a follow-up question: Using mysqldump, I'm about to dump all
databases and import to another instance - new . My question is do I
need to define all security and users in the new mysql or the security
definitions and privileges will be included in the dump file
John Taylor-Johnston schrieb:
I want to make a relational link from `data` to `shopping` so when I
insert a new record in `shopping`, I will see the contents of
`data`.`name` and `data`.`email` as drop-down menus in `shopping`.
This is InnoDB so I should be able to do this by SQL, right?
the result is large.
yes. of course, size matters, if your whole DB is small enough you will not
even get any performance impacts without any index ... ;-)
but it requires more resources, or?
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Paul McCullagh schrieb:
Hi All,
I have just released the first fully durable version of PBXT. Because of
the amount of new code I have reverted PBXT to Alpha status. This
version, 1.0-alpha, can be downloaded from:
http://www.primebase.org/download.
will there be any Windows builds
Rob Wultsch schrieb:
On Sat, Mar 15, 2008 at 2:42 PM, Nacho Garcia [EMAIL PROTECTED] wrote:
Hi, im having troubles with one query, hope someone can help.
on this table:
messages:
id_fromint(10)
id_toint(10)
textvarchar(1000)
time
with index on id_form and id_to
i want to
design is better to do.
search for: nested sets or something similar
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Velen schrieb:
Hi,
I need to write up a select statement something like:
Select a.supcode,a.code,b.desc,sum(c.qty),c.dept where
a.supcode=b.supcode and a.code=c.code and a.code=b.code and c.dept
between $tring1 and $tring2. group by supcode
This is fine but the problem is that there is
MariSok schrieb:
I have a products table with historical price information. Some
records are missing price information. I added another field -
closest_price, to be populated for records with 0 price. This would
be price values from the same table, same product with non-zero price
with earliest
Krishna Chandra Prajapati schrieb:
Hi All,
While i was going through mysql reference manual. I saw that
A query cannot be cached if it contains any of the functions shown below
BENCHMARK()
CONNECTION_ID() CONVERT_TZ()
CURDATE()
CURRENT_DATE()
Velen schrieb:
Hi,
I need to write up a select statement something like:
Select a.supcode,a.code,b.desc,sum(c.qty),c.dept where
a.supcode=b.supcode and a.code=c.code and a.code=b.code and c.dept
between $tring1 and $tring2. group by supcode
This is fine but the problem is that there is
Phil schrieb:
In my never ending quest for speed ups I've been trying the following..
I pull in xml data for roughly (at the peak) 1.8M hosts from the BOINC
[EMAIL PROTECTED] hosts files.
Each host will have a unique id, a score, createdate and possibly a country
team (as well as a number of
BY
comments.id
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dave M G schrieb:
PHP List, MySQL List
In my PHP environment, I have Magic Quotes turned off, and I use the
mysql_real_escape_string() function clean strings of SQL syntax before
inserting them into my database.
So the data stored in my database does not have escape characters in it.
Ian schrieb:
Hi,
I am running mysql 5.0.45 on freebsd 4.11 and for some strange reason
/tmp/mysql.sock keeps on disappearing and we are forced to kill -9 mysql and
restart it causing db corruptions as there is no other way of telling it to
stop once that file has gone. I have tried to find any
Ian schrieb:
Hi,
I wouldnt have thought so but whenever that file is missing and try the
stop/restart it just sits at the waiting for pids part of the stop loop
(where it lists the pids), and it never stops the server - i have left it
for over an hour and it never stops - just keeps on in the
Lenin Lakshminarayanan schrieb:
Hello,
I was pulling data from one datasource [ oracle ] earlier which had a couple
of fields as integer. Now i am moving to a newer data source and the same
fields are now varchar's in the newer oracle database.
I am planning to change the data types of those
mysql mysql schrieb:
Can anyone explain the following? I encountered the following very strange
behaviour while attempting to optimize a query (more details are provided
later on for those interested):
1) execute query
takes 2 minutes
2) add index
3) execute same query
takes 11 seconds
4)
David Ruggles schrieb:
I have googled, read the mysql documentation and searched the list archive.
I don't know if I just don't know the correct term to use or if I have some
other problem.
In a nutshell I generate packing lists where the items are normally sorted
alphabetically. However, there
Mário Gamito schrieb:
Hi,
I'm trying to get a single number out of a SELECT statement:
SELECT comment_approved, COUNT(comment_agent) from wp_comments WHERE
comment_agent LIKE '%Linux%' OR comment_approved=0 GROUP by
comment_approved
But instead i get two rows:
Joris Kinable schrieb:
Optimize query
I've got one query, which I would like to improve a lot since it takes
very long (24 hours) to execute. Here is the idea:
1. Take the table ipv4_srcipv4_dstport_dst (other rows in this
table are not mentioned for clearity) and remove all duplicate
tuple's.
Jerry Schwartz schrieb:
I am having trouble inserting special characters into a table. I am using
the MySQL client. I put the following commands into a text file (I'm on
WinXP, using Notepad), copy them, and paste them into the MySQL command line
client.
SET NAMES utf8;
CREATE TEMPORARY TABLE
legolas schrieb:
Hi
Thank you for reading my post
Is there any scheduled date mysql 6 release?
don't know
I heard that it is based on falcon and can perform better...
based on in the wrong term, MyISAM will still be the default storage
engine, it just adds Falcon as a new storage engine
Brian E Boothe schrieb:
how can i join three fields Values into one field? so in three select
boxes i have date :
Projects type 1 - 7 and project type 1 - 6 so the third Filed would
be 116200824 generated by the other three fields?
please clarify!
or did you mean CONCAT() or CONCAT_WS()
Hiep Nguyen schrieb:
hi all,
i have a table looks like this:
ID sDate
1 1997-03-21
2 1997-04-30
3 1997-05-30
4 1998-01-29
5 1998-02-24
6 1998-03-21
7 1999-05-10
8 1999-07-12
9 1999-10-20
10 2000-01-01
11 2000-02-15
12 2000-03-20
13
Kerry Frater schrieb:
Can someone please advise. I am looking to create a multiuser friendly way
of getting a subset number of rows from a table into another whilst making a
modification.
I thought that this could be done using a temporary table in a batch script
that is unique to that session
[EMAIL PROTECTED] schrieb:
Hello everybody!
I have a huge query (something similar to a search engine), full of left joins
and my testing server takes several minutes each time to output the recordset.
I was looking for some (right) way to optimize the search.
there were some solutions
be either a host name or an IP address. Passing the NULL value or
the string localhost to this parameter, the local host is assumed. When
possible, pipes will be used instead of the TCP/IP protocol.
http://php.net/mysqli_connect
--
Sebastian Mendel
--
MySQL General Mailing List
For list
Richard Heyes schrieb:
Will this bring good things to MySQL?
$800,000,000 tends to bring good things. Hopefully. :-)
??? why, this payment goes to current owners and investors, not to MySQL
itself ...
but anyway, using Suns structures and power will help of course ...
--
Sebastian
--
OldManRiver schrieb:
I uploaded the mysql console screenshot at:
http://www.sitepoint.com/forums/showthread.php?t=525160
this requires a login ...
why not just post (copy and paste) the console output, with all the commands
and results your where trying to execute?
--
Sebastian
--
MySQL
disable networking speedup MySQL?)
On Jan 14, 2008 6:54 PM, Sebastian Mendel [EMAIL PROTECTED] wrote:
Moon's Father schrieb:
On Jan 14, 2008 7:00 AM, Daevid Vincent [EMAIL PROTECTED] wrote:
I saw this on the PHP list and was wondering if there is any merit to
it?!
I would be surprised
Moon's Father schrieb:
On Jan 14, 2008 7:00 AM, Daevid Vincent [EMAIL PROTECTED] wrote:
I saw this on the PHP list and was wondering if there is any merit to it?!
I would be surprised if disabling networking made a difference. I'm only
concerned about the added speed. I get the security
C.R.Vegelin schrieb:
Sebastian,
MySQL uses only one index for searching.
As far as I know this applies to all MySQL versions, right ?
IMHO, but i heard elselike too, but cannot find any proof in the manual ...
--
Sebastian
--
MySQL General Mailing List
For list archives:
Anup Shukla schrieb:
C.R.Vegelin wrote:
Sebastian,
MySQL uses only one index for searching.
As far as I know this applies to all MySQL versions, right ?
AFAIK, MySQL (atleast from version 5.0 onwards) is capable of
using multiple indexes.
i have heard of something similar too, but cannot
Perrin Harkins schrieb:
On Jan 11, 2008 7:22 AM, Sebastian Mendel [EMAIL PROTECTED] wrote:
i can only find one source in the manual, where MySQL is using more than on
index:
http://dev.mysql.com/doc/refman/6.0/en/index-merge-optimization.html
Uh, how many sources do you need?
1
Sebastian Mendel schrieb:
Anup Shukla schrieb:
C.R.Vegelin wrote:
Sebastian,
MySQL uses only one index for searching.
As far as I know this applies to all MySQL versions, right ?
AFAIK, MySQL (atleast from version 5.0 onwards) is capable of
using multiple indexes.
i have heard
x schrieb:
thanks
may you point out which chapter says?
From manual I get the following answer agaist to my result(my server
version 5.0.45),
For |InnoDB| before version 5.0.3, |TRUNCATE TABLE| is mapped to
|DELETE|, so there is no difference. Starting with MySQL 5.0.3, fast
|TRUNCATE
Barry Newton schrieb:
OK, never mind. I finally found the 'locate' function. I knew it had
to be there somewhere!
or just:
... `column` IN ('name1', 'name2', 'name2', ...)
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
1 - 100 of 141 matches
Mail list logo
