;t see any 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 prox
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
ation?
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]
| amc_rch | fulltext | ER_IT_CTX_IDX_0805201045 |
ER_IT_CTX_IDX_0805201045 | 0 | |1 | Using where |
++-+---+--+--+------+-----+--+--+-+
1 row in set (0.05 sec)
--
Sebastian Mendel
R() (and UPPER()) are ineffective when applied to binary strings
(BINARY, VARBINARY, BLOB). To perform 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));"
--
Seb
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]
t; Select count(id) from log where date between '2008-05-01' and
'2008-05-30';
+---+
| count(id) |
+---+
| 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 ro
a windows-1256 dump file??
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 Lis
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]
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
h_date.pk = 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]
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
dd the MySQL log?
there you can see what 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]
`) 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
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 temp
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,
this?
--
Sebastian Mendel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
r you use two fields, one with formated ISBN and one indexed 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]
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
o it seems not unusual to me that it takes more time 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]
InQ2,
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]
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
'log_queries_no
t what has 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.
ite\htdocs\script.php on line 6
Keine Verbindung möglich!
What is Iam missing? Any help is appreciated.
Please send a copy of the answer in my personal E-mail address also.
$username instead of '$username'
same for '$password'
but what has this to do with MySQL???
--
Seba
$oct1.$oct2.$oct3',
'$oct1.$oct2.$oct3.$oct4', '[EMAIL PROTECTED]',
'[EMAIL PROTECTED]', '$from_dom', '$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]
ise, you're best 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 ()"
--
Seb
TO_DAYS([date_end]), TO_DAYS([Q_end])) - MAX(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]
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
--
Seba
for the dates that do not have
an event would work.
Example of the events table and the above query in action:
http://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 ... ;-)
-
aces”.
http://dev.mysql.com/doc/refman/5.0/en/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]
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 unsubscr
FROM items
INNER JOIN taggings
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
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 unsub
here classid=41
> and id >0 order by id desc limit 10;
> Empty set (0.00 sec)
did you tried to repair the table 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]
#x27; and 'red'
- items tagged with 'blue', 'red' and 'green'
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]
on class, but
the last comma seems to be wrong
try
'update products 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 stat
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]
cal server. 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 arch
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
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 anima
e seventh line shows 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 .
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 pro
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
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):
g
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 newslettercon
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
-
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
To
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);
++
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 ?
be
Changying Li schrieb:
Sebastian Mendel <[EMAIL PROTECTED]> writes:
Changying Li schrieb:
Hi. there is a table photo and two queries:
mysql> show index f
Changying Li schrieb:
Hi. there is a table photo and two queries:
mysql> show index from photo;
mysql>
show index from photo;
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 STRAIGHT_
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 this
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:
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
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
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?
where
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 c
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]
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 from
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 availabl
a problem unless
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://lis
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]
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 t
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 dup
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
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 dup
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()
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
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.
Part
d
GROUP 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]
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 st
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 r
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 fi
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) drop
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
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 (other rows in this
table are not mentioned for clearity) and remove all duplicate
tuple's. This is done by subquery
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:
|
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
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 `
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
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() o
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 propose
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
--
' uses sockets,
127.0.0.1 uses networking
"host Can 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/
but why should 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 meri
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 G
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 bene
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
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: http://lists.mysql.
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 of
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 f
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 TABLE|
Michael Stearne schrieb:
For a query like:
SELECT id FROM properties WHERE `Country` = 'USA' AND Type='Residential'
Is an multi-column index that is (Country, Type) better or worse or the
same as a single index Country and another single index Type.
better
two single indexes depending on
1 - 100 of 141 matches
Mail list logo
