Edition
More info and a 30-day trial version on www.upscene.com
Pricing information available on:
http://www.upscene.com/purchase.htm#adg
More information available here:
http://www.upscene.com/news/20080104.htm
With regards,
Martijn Tonies
Upscene Productions - Database Tools for Developers
Hi Krishna,
Did you try this option to start mysql
cd mysql-enterprise-gpl-5.0.40-linux-x86_64-glibc23/bin
./mysqld_safe --user=mysql
On 1/4/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote:
Hi All,
I was trying to change the data directory of mysql on debian. I have added
two thins
You must copy all files from old location, probably /var/lib/mysql to
/data/mysqldata/.
Also open your mysql error log file read it.
2008/1/4, Krishna Chandra Prajapati [EMAIL PROTECTED]:
Hi All,
I was trying to change the data directory of mysql on debian. I have added
two thins in my.cnf
Hi,
On Jan 4, 2008 1:04 AM, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote:
Hi All,
On mysql production server one of the innodb component
Innodb_buffer_pool_pages_free =1 . Although there are no issue with the
performance with the server. What should be the optimum value of
You should paste all your error messages here.
On Jan 4, 2008 7:29 PM, Vitaliy Okulov [EMAIL PROTECTED] wrote:
You must copy all files from old location, probably /var/lib/mysql to
/data/mysqldata/.
Also open your mysql error log file read it.
2008/1/4, Krishna Chandra Prajapati [EMAIL
LOL! True. I'm a Python guy ;)
On Jan 4, 2008 1:14 PM, Gerald L. Clark [EMAIL PROTECTED] wrote:
Victor Subervi wrote:
Hi;
I discovered I can use a $ sign in table names:
my$table
Is this recommended against? It's kind of handy in my app.
TIA,
Victor
If you write any PHP or Perl
Hmm. The idea is to take this open source. I'll eventually switch over to
Java. I guess there may be some people tempted to write a quick perl script,
as you say, but on the other hand it wouldn't be part of the open source
package, which will be either all Python or all Java. Your thoughts?
Question is, will anyone ever have to write a quick utility in perl (or
any language which uses '$' as a delimiter) to support this? Will you
have to explain your tables to anyone else?
On Fri, January 4, 2008 09:15, Victor Subervi wrote:
LOL! True. I'm a Python guy ;)
On Jan 4, 2008 1:14 PM,
On Fri, January 4, 2008 10:07, Victor Subervi wrote:
Hmm. The idea is to take this open source. I'll eventually switch over to
Java. I guess there may be some people tempted to write a quick perl
script,
as you say, but on the other hand it wouldn't be part of the open source
package, which
Thanks. It doesn't make the programming easier...it's just easier to read
the tables!
Victor
On Jan 4, 2008 2:23 PM, Scott Helms [EMAIL PROTECTED] wrote:
Let me ask this another way, what does this gain you that makes it
worthwhile to make it harder to work with your database in (at least) two
At 12:36 PM 1/4/2008, you wrote:
Thanks. It doesn't make the programming easier...it's just easier to read
the tables!
Victor
Victor,
Just use an underscore as in My_Table which is quite readable.
Using a $ is just asking for trouble. Unless you're the type of guy who
likes going into
I left something out, the query looks like:
SELECT SQL_CALC_FOUND_ROWS table_1.id,table_2.*
FROM table_2
LEFT JOIN table_1 ON table_2.shared_id = table_1.shared_id
WHERE MATCH table_2.field AGAINST ('value')
AND table_2.current = 1
AND table_2.shared_id IN (SELECT shared_id FROM table_1_view)
On Jan 4, 2008 5:51 PM, Eben [EMAIL PROTECTED] wrote:
The resultset is paginated on the front end using the
SQL_CALC_FOUND_ROWS functionality...
Usually a bad idea:
http://www.mysqlperformanceblog.com/2007/08/28/to-sql_calc_found_rows-or-not-to-sql_calc_found_rows/
- Perrin
--
MySQL General
Hi,
I have a query that has to run on a full text indexed table with many
millions of records. I'm trying to figure out some optimizations for
it. Here's the general query:
SELECT SQL_CALC_FOUND_ROWS table_1.id,table_2.*
FROM table_2
LEFT JOIN table_1 ON table_2.shared_id =
I've never used this feature before on my application.
On Jan 5, 2008 7:06 AM, Perrin Harkins [EMAIL PROTECTED] wrote:
On Jan 4, 2008 5:51 PM, Eben [EMAIL PROTECTED] wrote:
The resultset is paginated on the front end using the
SQL_CALC_FOUND_ROWS functionality...
Usually a bad idea:
In my opinion ,I alway use underscore as f_table in my appication.
It runs well all the time.
On Jan 5, 2008 6:22 AM, mos [EMAIL PROTECTED] wrote:
At 12:36 PM 1/4/2008, you wrote:
Thanks. It doesn't make the programming easier...it's just easier to read
the tables!
Victor
Victor,
But why I have not found this parameter in my version.
Something is like this:
mysql show variables like '%innodb_buffer%';
+-+---+
| Variable_name | Value |
+-+---+
| innodb_buffer_pool_size | 268435456 |
://www.upscene.com/news/20080104.htm
With regards,
Martijn Tonies
Upscene Productions - Database Tools for Developers
http://www.upscene.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
I'm
The script mysql_install_db will initilize all the data in database mysql.
So the user you created losted certaintly.
On Jan 4, 2008 3:10 PM, Chris [EMAIL PROTECTED] wrote:
Krishna Chandra Prajapati wrote:
Hi all,
Mysql on debian operating system has debian-sys-maint user. What is the
learnt.
On Jan 4, 2008 10:15 AM, B. Keith Murphy [EMAIL PROTECTED] wrote:
Martin,
I took a quick look at the tools that you mentioned. Seems you are
heavily involved in Java :)
We don't use Java at all, and other than using cron (which I do use for
backups and standard stuff like that)
I always use stored procedure when I meet such demand.
On Jan 3, 2008 11:09 PM, Baron Schwartz [EMAIL PROTECTED] wrote:
Hi,
On Jan 3, 2008 9:28 AM, GF [EMAIL PROTECTED] wrote:
I need to create a view, about a ranking.
The select from which I generate the view has a ORDER BY and I need
21 matches
Mail list logo