I did some tests a couple of weeks ago, using using SQL_NO_CACHE and
clearing out the OS buffer after each query was enough to give me
consistent results that were based on system load rather than cache
efficiency. These two are by far the major factors in my experience,
although no doubt other
systems, although Unix stuff is
probably similar.
-Micah
On 03/04/2009 07:27 AM, Morten wrote:
>
> Hi, I was hoping that using SQL_NO_CACHE would help me bypass the
> query cache, but judging from the below it doesn't. What can I do to
> avoid the query cache?
>
> Thanks.
Peter Brawley wrote:
Micah,
>each item in `a` has a 1 to 1 relationship to `b`,
>and each item in `c` has a 1 to 1 relationship with `b`.
>Sometimes these correspond, i.e. there's a row in `b`
>that relates to both `a` and `c`, but not always.
So in a given b row, the b_id val
Hi,
I'm somewhat stumped by how to set up a single query that does the
following. Currently I'm accomplishing this through multiple queries and
some PHP 'glue' logic, but it should be possible in a single query I
think, and it's bugging me that I can't figure it out. If anyone has any
ideas,
e jumping into server admin
items. I only say this because in the long run I really believe it will
be much easier for you, and a better strategy based on what little I
understand of your goals. Don't know what language you're using, but
there's lots of libs available for perl and p
>
> Thank you in advance for any suggestions.
>
> Best, Andrej
>
Why not:
SELECT a.symbol FROM test as a, test as b WHERE a.symbol=b.symbol and
a.study != b.study group by symbol;
-Micah
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 11/22/2008 07:14 PM, Micah Stevens wrote:
> On 11/22/2008 04:30 PM, Jujitsu Lizard wrote:
>
>> Summary: (a) Both approaches are quite good, and (b) the CPU efficiency
>> argument for stuffing prepared images into a table or similar may be weak.
>>
>> The Liza
le, in a
production web server environment with many client calls, you want to
distribute this as much as possible to reduce server overhead and I
think anyone here that has done GD processing in a production
environment will tell you, using it isn't free by any stretch of the
imagination.
-Mica
of functions for creating
> images <http://us2.php.net/gd>>.
>
> You can grab data from MySQL and then use the GD functions to create images
> dynamically. It can be tedious, as you create the image pixel by pixel, but
> the results are very good.
>
> David
>
>
Or for reduced CPU overhead, just make some images for beds and rooms
and use tables or positioned DIV tags to place them in the appropriate
place based on the database information.
-Micah
I don't think this is indicative of a design issue. Some tables need
data removed more often than others, however Moon's Father brings up an
excellent point. If you CAN resolve this with a change in design, that
would be the best solution of course.
-Micah
On 11/17/2008 06:50 PM, Moo
0% of your table size before it would be a problem, and more so
on smaller tables.
It's just stuff that the database engine has to work around. Remember
it's referring to data overhead, not CPU overhead.
If this grows quickly in your system, just automate a nightly or hourly
cleaning.
-
Deleted rows.
On 11/17/2008 04:56 PM, sangprabv wrote:
> Hi,
> I just want to know what things that cause table/db overhead? Because I
> have my tables always get overhead problem. And must run OPTIMIZE query
> every morning. Is there any other solution? TIA.
>
>
> Willy
>
>
>
--
MySQL Genera
a subquery, but that would only be marginally
faster than two queries.
Sorry if I'm not more creative in the morning. :)
-Micah
On 11/12/2008 01:10 AM, Waynn Lue wrote:
> Whoops, just realized I made a mistake in the examples. What I'm really
> looking for is these two queries
A working server relies on the MySQL binary, and system libraries, and
the hardware itself. From your description you don't address the library
compatibility. Have you ensured that your set of libraries is the same?
-Micah
On 10/29/2008 11:15 AM, Kevin Stevens wrote:
ello,
I am encount
It's a package for Debian based systems, which include Ubuntu and a few
others..
It's like an RPM for Fedora/Redhat linux.
-Micah
On 10/27/2008 06:39 PM, Moon's Father wrote:
I'm sorry that if I can ask a question.What is DEB?
On Fri, Oct 3, 2008 at 9:49 PM, US Data Expo
es a very important purpose. By normalizing your data, and not
using things like ENUMs, you're maintaining an accurate data structure
which then can be arbitrarily used. But yeah, it's not necessarily fast,
probably the opposite.
Hope that helps.
-Micah
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
)
FROM meals
INNER JOIN mealitems ON meals.meal_id = mealitems.meal_id
INNER JOIN fooditems ON mealitems.fooditem_id = fooditems.fooditem_id
WHERE meals.user_id = '$user_id' AND meals.date = '$meal_date'";
-Micah
On 09/05/2008 03:41 PM, Brian Dunning wrote:
I'
There's probably a password set. Look up how to reset a password:
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
On 08/25/2008 03:25 AM, Matthew Stuart wrote:
I have just loaded MySQL 5 and MySQL Front on to a new computer, and I
am now getting a MySQL-Error which is:
Con
I just want to point out that public IPs are no longer given out as
Class A, B, and C networks, but based on CIDR. You can use rwhois to
figure out who has use of a certain subnet and what the range of it is.
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
affect anything
but you may get some errors during an upgrade at some point if they
decide to use it. It's not a big security issue unless someone gets root
access to the server, but if that's the case, I don't think mysql
security will rank among the greatest of your worries.
ou're suggesting.
Any issues with the file system in Linux would be the same in windows as
well (filename length, etc..) so if it's working in windows, it should
work fine in Linux too.
However, before committing, try it out with backed up data of course!
-Micah
On 12/24/2007
Look at the data files. The extension of the file will tell you.
On 11/21/2007 12:42 PM, Richard Edward Horner wrote:
Hey everybody,
Hopefully some of you are already enjoying time off. I am not...yet :)
Anyway, is there a way to determine what storage engine a table is
using if it's crashed?
I think you may be able to get around this by using multiple key
buffers? (MySQL 4.1 or later)
-Micah
On 05/15/2007 01:24 AM, Christoph Klünter wrote:
Hi List,
We have a mysql-Server with 8G of Ram. But mysql doesn't use this ram.
But we get following error:
May 14 22:56:11 sql mysqld
would be much faster still than dealing with the added
overhead of a SQL server. You're ignoring the advantages of having a SQL
setup in this case anyhow.
-Micah
m:
select * from answers where questionID = '100'
Or, you can do a join, and get the question information in the same query.
-Micah
The problem with the first solution is, that MyISAM storage engine is limited
to 2599 columns i think. So what's happening if i have more answers than
Yeah, in SQL:
RENAME DATABASE start_name TO new_name;
-Micah
On 04/12/2007 01:34 AM, Octavian Rasnita wrote:
Hi,
How can I rename a database if it contains InnoDB tables?
I have tried renaming the directory where it is located, but it
doesn't work this way.
Is there a method that
It's just telling you how many queries per second on average the server
is receiving. This says nothing about how long it takes to execute a
particular query.
-Micah
On 04/06/2007 01:22 AM, C.R.Vegelin wrote:
Hi List,
Using printf(" System status: %s\n", mysqli_stat($link));
want it at the song level.
Year wouldn't ever apply to artist I don't think, unless they're truly a
one hit wonder. :)
-Micah
On 04/02/2007 09:14 PM, Daniel Cousineau wrote:
So I'm currently designing a database for a web site and intra net for my
campuses student radio.
Not to digress - but I would advise (strongly) the author to consider
svn
instead of cvs (svn: subversion is the new cvs built fresh from bottom
keeping in mind the deficiencies of cvs)
http://subversion.tigris.org/
Agreed, my experience with Subversion has been a pleasurable one.
-Micah
--
M
Sounds like perhaps an unnecessary complication, why would this be
better than the root SQL CREATE statements?
-Micah
On 04/01/2007 12:41 PM, Anoop kumar V wrote:
DDLUTILS is what you need:
check this out:
http://db.apache.org/ddlutils/
and better still (if you are using Ant as a build tool
reasons.
For this reason I backup using a SQL dump, you just need to lock the
tables and go. It compresses nicely too.
-Micah
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Using ALTER statements would make it tough to get a complete view. I
would stick with your original idea. This would enable diffs to work
nicely, and the latest revision would contain everything you need to
know to create the database.
-Micah
On 04/01/2007 07:11 AM, Miles Thompson wrote
M,
the command line rebuilding tools are where I'd start.
-Micah
On 03/31/2007 06:09 AM, Francois Colonna wrote:
Hello
I am using MySql to store two MediaWiki databases named dftdb and
framesdb
I am using MySql 4.1.20
I am using MediaWiki 1.9.3
I am using Scientific Linux 4.4
Each week I
,
`quote` text,
`author` text,
`category` text,
`class` text,
`active` text,
`group` varchar(5) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
-Micah
On 03/26/2007 10:31 AM, Rob Tanner wrote:
Hi,
I am porting over 6 databases from a MySQL v4 installation to a MySQL
v5 installation and
.
Read up on joins, that may help.
-Micah
Sid Price wrote:
I am sorry but I don't understand the select query you wrote, could you
perhaps explain how it works or point me to a reference that might help me
understand it?
Many thanks for responding,
Sid.
Sid Price Software Design
This doesn't work?
SELECT businesses.name from businesses
left join links using (businessID)
left join categories using (categoryID)
where category.name = 'something'
order by businesses.name ASC
On 03/25/2007 12:40 PM, Sid Price wrote:
Hello,
I have a MySQL database design that provides
Oh, I didn't see the first comment. My mistake. It's likely a 32bit
integer size limit of some sort then. 32bit = 4gbytes
-Micah
On 03/22/2007 02:08 PM, JP Hindin wrote:
Micah;
In the first eMail I mentioned that I had excluded filesystem size limits
by manually producing a 14GB ta
This table size is based on your filesystem limits. This is a limit of
the OS, not MySQL.
-Micah
On 03/22/2007 01:02 PM, JP Hindin wrote:
Addendum;
On Thu, 22 Mar 2007, JP Hindin wrote:
Zero improvement. I used the following CREATE:
MAX_ROWS=10;
At first I thought
System.err.println("Exception creating the database connection: ");
> System.out.println(se.getMessage());
> }
> catch ( Exception e )
> {
> System.err.println("Exception creating the database connection: ");
> System.out.println(e.getMessage());
> }
>
> I tried it with the DriverManager class as well. The exception is stil not
caught.
>
> Thanks
> Micah
39 matches
Mail list logo
