Hi Krishna,
Its the bottom-up approach in all db's which follow SQL standards.
Can u please show us the explain plan of the below query.
regards
anandkl
On 8/14/07, krishna chandra prajapati <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> i have to optimize complex join queries. i am not able to unde
Hi all,
i have to optimize complex join queries. i am not able to understand how the
complex queries gets executed. Whether it follow top-down or bottom-up
approach. There is millions of data.
The queries is:
select ucp.user_id as RESULTANT_ID from user_course_payment
ucp,crm_sales_contact sc, c
Hello,
My server box has 8G memory and 8CPU (DELL Standard Server),when I
configure Mysql server (5.0.45) using large memory,mysqld would say it
run out of memory.
For example,when this line appear in my.cnf,
key_buffer = 4000M
mysqld can't startup.When I change it to,
key_buffer = 2560M
mysq
It looks like u dont have index on fsys.src_ip and host.ip, please create
index on these two columns, and also do a explain of ur query, u will know ,
where the problem is.
regards
anandkl
On 8/13/07, Mark Ponthier <[EMAIL PROTECTED]> wrote:
>
> Fellow MySQLers,
>
>
>
> I have a query that perfo
Hi James,
Since your queries have both receiver_id and sender_id in the where
condition and u want this to be unique, just create one combined unique
index on both these columns.
Do this at db level will give you much better options, performance, rather
than doing at code level, which might involv
I have a table that has a Primary key using the 'id' column.
The table also has a 'receiver_id' and a 'sender_id'.
I have queries that will use
(1) "WHERE receiver_id ="
or
(2) "WHERE sender_id="
but never "WHERE receiver_id='###' AND sender_id='###'"
Also, I want the receiver_id/sender_id pair
It could have to do with 5.1 not being released as alpha until 5.0 was
gamma. Here is a breakdown of the 4.0-5.1 releases and ho2 5.1 was
different from the previous versions.
http://ebergen.net/wordpress/2006/10/17/where-was-51/
-Eric
On 8/13/07, Ed Reed <[EMAIL PROTECTED]> wrote:
> Does anyone
Does anyone have an explanation as to why it's taking so long for an official
release of version 5.1? Is it me or does it seem like 5.1 is taking a lot
longer to be released. I don't remember previous versions having 20 beta revs
before an official release. Is there a real date available for an
I think we/he is referring to the future of SOURCE tarballs being RELEASED
by MySQL (in UPCOMING releases), not just current releases which is what the
mirror hosts.
On 8/13/07, Eric Bergen <[EMAIL PROTECTED]> wrote:
>
> It's nothing to be concerned about because the source tar balls and
> binarie
It's nothing to be concerned about because the source tar balls and
binaries are being mirrored at http://mirror.provenscaling.com/mysql/
-Eric
On 8/10/07, Daevid Vincent <[EMAIL PROTECTED]> wrote:
> Is this anything to be concerned about?
> We are Enterprise customers. We distribute mySQL on our
On 8/13/07, Dan Buettner <[EMAIL PROTECTED]> wrote:
>
> Michael, it looks to me like your root partition is absolutely 100% chock
> full. Am I misunderstanding your request for help? Sounds like you are
> saying you think you have nothing in that partition - but your 'df -h'
> command is showing
Thanks. That fixed the problem. I put all of my DECLARE statements at the
beginning of the procedure. I finally got the thing to compile and it looks
like this:
DELIMITER $$
DROP PROCEDURE IF EXISTS `code_library`.`Search_Code_Samples` $$
CREATE [EMAIL PROTECTED] PROCEDURE `Search_Code_Sampl
Tom,
I think the problem might be that you have to put all the DECLARE
statements at the top before the other statements. It seems like I had
a similar problem with this once.
Hope this helps.
Randall Price
Secure Enterprise Technology Initiatives
Microsoft Implementation Group
Virginia Tech I
Michael, it looks to me like your root partition is absolutely 100% chock
full. Am I misunderstanding your request for help? Sounds like you are
saying you think you have nothing in that partition - but your 'df -h'
command is showing 0 bytes available in /.
Dan
On 8/13/07, Michael Habashy <[E
Below is a new stored procedure that I am trying to make for building a SQL
with the supplied parameters.
1:DELIMITER $$
2:CREATE PROCEDURE `Search_Code_Samples`(
3:IN search_words VARCHAR(300)
4: , IN multi_word_condition VARCHAR(3)
5: , IN language_id INT
6: , IN sample_type
I am using debian 4.0 and mysql-server-5.0 package.
My server will not start because it states that there is not enough
spaceCan someone assist?
rider:~# df -h
FilesystemSize Used Avail Use% Mounted on
/dev/mapper/vg_house-lv_root
493G 468G 0 100% /
tmpf
I built a laptop this weekend with mysql server version 5.0.37-log. The
laptop is running Fedora 7. Last night I was able to create a database
directory -- sym linking from /var/lib/mysql to a larger disk,
/usr/local/data. I was able to create tables and loaded 10 million rows of
data into thre
On 8/13/07, Jonathan Horne <[EMAIL PROTECTED]> wrote:
>
> i finally have a real need that i need to sit down and learn the basics of
> databases. i need to learn to create a database that i can use to track
> assets at my company, and have it be readable/updatable from a web
> interface
> (and hop
On 8/13/07, Jonathan Horne <[EMAIL PROTECTED]> wrote:
>
> i finally have a real need that i need to sit down and learn the basics of
> databases. i need to learn to create a database that i can use to track
> assets at my company, and have it be readable/updatable from a web
> interface
> (and hop
Fellow MySQLers,
I have a query that performs poorly and I was hoping that someone could
make a recommendation as to how to
improve it's performance. The query involves a join between the
fs_syslog table (~700K rows) and the hosts
table (~100 rows). I am using MySQL 5.0.41 running on CentOS 4.
On Monday 13 August 2007 10:43:33 Gary Josack wrote:
> Jonathan Horne wrote:
> > i finally have a real need that i need to sit down and learn the basics
> > of databases. i need to learn to create a database that i can use to
> > track assets at my company, and have it be readable/updatable from a
Jonathan Horne wrote:
i finally have a real need that i need to sit down and learn the basics of
databases. i need to learn to create a database that i can use to track
assets at my company, and have it be readable/updatable from a web interface
(and hopefully also export data to .csv).
can
i finally have a real need that i need to sit down and learn the basics of
databases. i need to learn to create a database that i can use to track
assets at my company, and have it be readable/updatable from a web interface
(and hopefully also export data to .csv).
can someone recommend a book
[EMAIL PROTECTED] wrote:
Hi,
I have a table with records dated 01-01-2007 00:00:00 to 01-02-2007
23:59:59. What I want to do is grab 1 random record in every 10 minutes
between the date. Please help me.
Regards,
Willy
Does it really need to be random? This works from me:
mysql> select `da
Good morning, Willy -
If you're using some sort of scripting language, like PHP, this would be
easily done by starting a variable at the beginning of the date range, then
repeating the below query and incrementing the variable by 10 minutes each
time through a while loop until you've passed the ot
I install MySQL on Linux 2.6.9-52bs #2 x86_64 x86_64 x86_64 GNU/Linux, 16G
memory with followiing step: 1. ./configure --prefix=/home/mysql/mysql2. make3.
make install I set innodb_pool_buffer_size = 8G in my.cnf, but when I use "show
variables like 'innodb_buffer_pool_size';" the result is :
+
-- Forwarded message --
From: C K <[EMAIL PROTECTED]>
Date: Aug 13, 2007 11:37 AM
Subject: [commercial] MySQL cluster setup and support
To: [EMAIL PROTECTED]
Dear all,
we are a medium sized company in India having mfg. facilities about 65 kms.
from Pune and Head Office in Pune. We
st of features and fixes: http://www.upscene.com/news/20070813.htm
Database Workbench supports:
- Borland InterBase ( 4.x - 8.x )
- Firebird ( 1.x, 2.0 )
- MS SQL Server/MSDE ( v6.5, 7, 2000, 2005, MSDE 1 & 2, SQL Express )
- MySQL 4, 4.1, 5.0
- Oracle Database ( 8i, 9i, 10g )
- NexusDB ( 2.05 and
28 matches
Mail list logo
