e storing the statement.
>>>
>>> This can however be done in the Percona build.
>>>
>>> http://www.percona.com/docs/wiki/percona-server:features:query
>>> _cache_enhance#query_cache_strip_comments
>>> http://www.percona.com/docs/wiki/percona-server:fe
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,
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 fil
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 wrote:
> Hi All,
>
> I have asked this question before But, I think I am not able to describe
> it better.
>
> Sorry for a
>
> > Note: as you can see in the above, CHAR data DOES take up room for it's
> > full size, stupidly enough.
> >
> > On Tue, Nov 10, 2009 at 6:37 PM, Waynn Lue wrote:
> >> Hey all,
> >>
> >> I was building a table for storing email addresse
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 byt
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 addi
>
> 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:
>>
>
>
> http://dev.mysql.
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> DELE
pisode (Nov 12), Waynn Lue said:
>> 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 = ORDER BY UserId DESC LIMIT 1;
>> SELECT * F
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 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 = ORDER BY UserId DESC LIMIT 1;
SELECT * FROM Users WHERE UserId = ORDER BY UserId LIMIT 1;
Is there any way to combine
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 database [Lost connection to MySQL server during
query]'
Similarly, we're seeing stack tr
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 App
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 colum
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 = WHERE ActionsReceived =
where foo and bar change for multiple sets of values. Is there a way to do
this in one SQL st
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:
>>
>>>
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, ).
So I have an index on values that I'll potenti
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 functi
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,
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
> > 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 on
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 arch
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
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 perceiv
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 tryin
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 solution
ens.
I'll 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 "
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 fi
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", e
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 Use
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:
n what the
> > user has set. This means adding a method every time I add a preference
> > setting, which on the one hand means adding code - on the other hand,
> > chances are very high that if I am adding the ability for a user to set a
> > preference, I'm already add
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. I
of the two 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 state
ctions desc limit 10;
>
> HTH, Cor
>
>
>
> - Original Message -
> From: "Waynn Lue" <[EMAIL PROTECTED]>
> To:
> Sent: Friday, February 22, 2008 10:38 AM
> Subject: SELECT ascending incremental values
>
>
> > I
TECTED]> wrote:
>
> At 05:55 AM 2/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,
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 dro
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, 984
ng 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
>
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 auto_incre
45 matches
Mail list logo
