mentation_details:details_query_cache_with_comments
Cheers,
Ewen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=waynn...@gmail.com
--
Sent from my mobile device
__
Waynn Lue
I currently have a dedicated database server with 8 GBs of RAM and 8 1.60
GHz processors. The tables on my databases are almost exclusively InnoDB,
except for 2-3 tables that are MyISAM and used for logging purposes (lots of
INSERT DELAYED statements). I have the following settings in my my.cnf,
I fixed this by using symlinks for the directories for the underlying
databases. The limit for files is significantly higher than
directories.
Waynn
On 11/24/09, Manasi Save manasi.s...@artificialmachines.com wrote:
Hi All,
I have asked this question before But, I think I am not able to
On Wed, Nov 25, 2009 at 12:53 AM, Manasi Save
manasi.s...@artificialmachines.com wrote:
Thanks Waynn,
I could not get your point of using symlinks. Because as per my knowledge
symlink will store same data which is there in original directory.
and What do you mean by The limit for files is
, CHAR data DOES take up room for it's
full size, stupidly enough.
On Tue, Nov 10, 2009 at 6:37 PM, Waynn Lue waynn...@gmail.com wrote:
Hey all,
I was building a table for storing email addresses today and ran into an
issue that I couldn't find an answer for using Google. If I declare
Hey all,
I was building a table for storing email addresses today and ran into an
issue that I couldn't find an answer for using Google. If I declare the
column as a VARCHAR (this is an InnoDB table), does it matter what size I
declare it as if it's between 1 and 255? I know there's an extra
I currently have a RAID 5 setup for our database server. Our space is
running out, so I'm looking to increase the disk space. Since I'm doing
that anyway, I decided to re-evaluate our current disk array. I was told
that RAID 5 isn't a good choice for databases since it's slower to write.
In
If I have a table like this:
CREATE TABLE `Test` (
`TestId` bigint(20) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Does using --safe-updates mean that it's impossible for me to ever delete
from it, since it doesn't have a key? For example:
If I have a table like this:
CREATE TABLE `Test` (
`TestId` bigint(20) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Does using --safe-updates mean that it's impossible for me to ever delete
from it, since it doesn't have a key? For example:
INSERT INTO Test VALUES (1), (2);
mysql
Yeah, so a UNION would work, would this solution be faster than using
a subquery (my instinct says yes) but thought I would ask. They both
execute fast on my system so it's hard to say under load.
Thanks,
Waynn
On 11/12/08, Dan Nelson [EMAIL PROTECTED] wrote:
In the last episode (Nov 12), Waynn
I'm trying to find the first row before and the first row after a specific
row. Essentially I want to do these two queries, and get each row.
SELECT * FROM Users WHERE UserId = userId ORDER BY UserId DESC LIMIT 1;
SELECT * FROM Users WHERE UserId = userId ORDER BY UserId LIMIT 1;
Is there any
Whoops, just realized I made a mistake in the examples. What I'm really
looking for is these two queries:
SELECT * FROM Users WHERE UserId *userid*;
SELECT * FROM Users WHERE UserId *userid*;
Waynn
On Wed, Nov 12, 2008 at 12:14 AM, Waynn Lue [EMAIL PROTECTED] wrote:
I'm trying to find
We've started seeing mysql errors in the logs, and when i look at the output
of mysql_error() (in php), i get lost connection to mysql server during
query. Here's an example stack trace:
'Can't connect to name database [Lost connection to MySQL server during
query]'
Similarly, we're seeing stack
Out of curiosity, is it generally faster to do a sub query or do it in
code for something like this.
Schema of Settings table, where the PK is (ApplicationId, SettingId):
ApplicationId, SettingId, SettingValue
Select SettingValue from Settings where SettingId = 10 and
ApplicationId IN (select
Thanks, I'll take a look at that.
Appreciate the help,
Waynn
On Sat, Jul 12, 2008 at 9:02 PM, Rob Wultsch [EMAIL PROTECTED] wrote:
On Sat, Jul 12, 2008 at 8:01 PM, Waynn Lue [EMAIL PROTECTED] wrote:
Is there any way to have an UPDATE statement change a column value based
on
the WHERE
Is there any way to have an UPDATE statement change a column value based on
the WHERE statement?
Essentially, I want to do something like this
UPDATE Actions SET ActionsSent = foo WHERE ActionsReceived = bar
where foo and bar change for multiple sets of values. Is there a way to do
this in one
On Mon, Jul 7, 2008 at 4:20 AM, Ananda Kumar [EMAIL PROTECTED] wrote:
Yes, i definitly agree on the third table if APPLICATION FUNCTIONALITY
increase and need to add more columns into the current tables.
On 7/7/08, metastable [EMAIL PROTECTED] wrote:
Ananda Kumar wrote:
I feel creating
On Mon, Jul 7, 2008 at 2:49 AM, Ananda Kumar [EMAIL PROTECTED] wrote:
Problem is that there are combinations that I'll never care about
What do u mean by the above statement.
What I meant is that I will never do a query for (e.g.) (30, anything).
So I have an index on values that I'll
I have two tables, Applications and Settings. Here are the two schemas:
mysql desc Applications;
+-+-+--+-+-++
| Field | Type| Null | Key | Default |
Extra |
Thanks for the suggestion--is that essentially using
http://www.php.net/posix_mkfifo within PHP?
[JS] Yes, that's what I had in mind. Be warned, though: I've never used this
from PHP; and, although I found no references to this in the PHP
documentation, I couldn't find the POSIX functions in a
Hey,
I'm looking to write a queue backed by MySQL to enable batch updates
of a system I'm writing. Essentially what I wanted to do was every
time I want to enqueue, I just INSERT a new row into a table. Then I
have a cron job that runs every X minutes, selects all the existing
rows and does the
Thanks for the suggestion--is that essentially using
http://www.php.net/posix_mkfifo within PHP?
On Mon, Jun 30, 2008 at 7:11 AM, Jerry Schwartz
[EMAIL PROTECTED] wrote:
-Original Message-
From: Waynn Lue [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2008 6:04 AM
To: MySQL List
Subject
I assume I should check if my mysql has support for UTF-8,
I believe it just has to be 4.1 or newer. And, that's only necessary so
you can get UTF-8 aware sorting and such. You don't need any special
support to just _store_ UTF-8 data.
Ah, that's actually the critical part. I'm
I'm trying to store the symbol (R) (that's the registered trademark
symbol) in my database, but I get a weird Ctrl-A (^A) character
whenever I try. At first, I thought it was because I was calling
htmlentities without passing in UTF-8 as the last argument, but that
only solved one of my problems.
I'll do that, thanks. (Sorry for the long response time, I was in
Dublin this past week...).
On Mon, Apr 21, 2008 at 3:16 PM, Wm Mussatto [EMAIL PROTECTED] wrote:
On Mon, April 21, 2008 07:28, Waynn Lue wrote:
Is there any way to prevent UPDATEs on one database on one mysql
instance from
Is there any way to prevent UPDATEs on one database on one mysql
instance from affecting SELECTs on other databases in the same
instance? I'm noticing a whole bunch of backed up connections on
other databases when I run massive UPDATEs on one.
Thanks!
--
MySQL General Mailing List
For list
I'm thinking of buying a license for this tool to do a migration from
one server to another, but it's been hard for me to find good
documentation on it after searching for awhile last night. Is it
possible for me to migrate from a 32-bit to a 64-bit system across a
network? How long would
Oh, and a followup question that I forgot to ask--what if the two
systems have different db schemas? Is it possible to do some sort of
mapping between the two?
On Fri, Mar 21, 2008 at 1:48 PM, Waynn Lue [EMAIL PROTECTED] wrote:
I'm thinking of buying a license for this tool to do a migration
Say I have this schema
CREATE TABLE temp (
EntityId BIGINT AUTO_INCREMENT PRIMARY KEY,
CreationTime DEFAULT NOW()
);
Now let's say I want to find all rows created within the last 24 hours. If I do
select * from temp where CreationTime DATE_SUB(NOW(), INTERVAL 24 HOUR)
that's going to do
Thanks for the responses, Inline:
On Sun, Mar 9, 2008 at 7:49 PM, Tim McDaniel [EMAIL PROTECTED] wrote:
On Sat, Mar 8, 2008 at 11:55 PM, Waynn Lue [EMAIL PROTECTED] wrote:
Subject: Re: mysqldump on specific columns only?
I'm trying to dump all the columns of a table but one
SHOW DATABASES; shows that I have a database called test, but when I
call DROP DATABASE test, I get
ERROR 1008 (HY000): Can't drop database 'test'; database doesn't exist
When I run any queries on that database, I get errors like:
mysql select * from Users;
ERROR 1017 (HY000): Can't find file:
post back with results.
Thanks for all the advice,
Waynn
On 3/8/08, Baron Schwartz [EMAIL PROTECTED] wrote:
Hi,
On Sat, Mar 8, 2008 at 6:58 AM, Waynn Lue [EMAIL PROTECTED] wrote:
SHOW DATABASES; shows that I have a database called test, but when I
call DROP DATABASE test, I get
I'm trying to dump all the columns of a table but one in a
restructuring of my schema. I found this post:
http://www.jsw4.net/info/listserv_archives/mysql/05-wk49/msg00131.html
which seems to indicate that this isn't possible, but I was wondering
if anyone had any suggestions. My current
I've been noticing strange load spikes on our mysql machine, throwing
back the dreaded max connections error, even though the value is set
to 500. I'm wondering if this is related to an hourly script I run
that does a few somewhat-db intensive queries. The script runs a
query that groups by
In response to an email offlist, I forgot to specify that these are
InnoDB tables.
On Mon, Mar 3, 2008 at 2:53 PM, Waynn Lue [EMAIL PROTECTED] wrote:
I've been noticing strange load spikes on our mysql machine, throwing
back the dreaded max connections error, even though the value is set
, I'm already adding code somewhere to ensure that preference
has
an effect.
HTH,
Dan
On Thu, Feb 28, 2008 at 9:50 AM, Waynn Lue [EMAIL PROTECTED] wrote:
I'm looking for a good way to store user preferences. The most
straightforward way is just to add a column to the Users table
Whoops, finished my thought too early. I was going to append, should
we also have UserId, PreferenceId be the PRIMARY KEY? Then possibly a
secondary index on UserId in case I ever want to get all preferences
for a user?
On Sun, Mar 2, 2008 at 6:18 PM, Waynn Lue [EMAIL PROTECTED] wrote
I'm looking for a good way to store user preferences. The most
straightforward way is just to add a column to the Users table for
each preference we're looking to store. Downside is that it requires
an ALTER TABLE which gets prohibitively expensive as it gets larger,
as it's fairly inflexible.
columns is now different.
On Mon, Feb 25, 2008 at 7:50 AM, mos [EMAIL PROTECTED] wrote:
At 05:16 PM 2/24/2008, Waynn Lue wrote:
That's actually why I'm dropping/recreating, because I thought the
changes I have to make require multiple statements. Let me know if
that's a wrong assumption
/23/2008, Waynn Lue wrote:
I have three or four different ALTER TABLE commands I need to run on a
9 million row table (related to the previous email I sent). I've
tried running it before and it just takes way too long, so I was
thinking the fastest way to get this done is to create new
- Original Message -
From: Waynn Lue [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, February 22, 2008 10:38 AM
Subject: SELECT ascending incremental values
I'm doing a top 10 list from a database based on a group by and order
by, something like
select UserId
I have three or four different ALTER TABLE commands I need to run on a
9 million row table (related to the previous email I sent). I've
tried running it before and it just takes way too long, so I was
thinking the fastest way to get this done is to create new tables with
the final schema, then
I'm doing a top 10 list from a database based on a group by and order
by, something like
select UserId, count(*) as NumActions from Actions group
by UserId order by NumActions desc limit 10;
Is there any way to put a separate column so I get results like
Rank, UserId, NumActions
1, 123, 43
2,
I'm trying to change the definition of a field and getting 1025 errors
when I try. Here's a simplified reproducible test case, on MySQL 5.
CREATE TABLE `Users` (
`UserId` int(11) NOT NULL,
PRIMARY KEY (`UserId`)
) ENGINE=InnoDB;
CREATE TABLE `Actions` (
`ActionId` int(11) NOT NULL
it will take?
Thanks again,
Waynn
On Feb 19, 2008 5:11 PM, Baron Schwartz [EMAIL PROTECTED] wrote:
Hi Wayne,
On Feb 19, 2008 4:52 PM, Waynn Lue [EMAIL PROTECTED] wrote:
I'm trying to change the definition of a field and getting 1025 errors
when I try. Here's a simplified reproducible test case
45 matches
Mail list logo