|
 |
| Recent blog posts: | |
|
| Forums: | | |
|
| Discuss: | |
|
| Recent forum topics: | |
|
| Recent forum comments: | |
|
| Модератор: | |
|
Friday, 26 January 2007
|
| requirements specification of GUI tools Parul Jain 00:41:04 |
| | Hi All
I am trying to find user-requirements behind the MySQL - Query Browser.
Something that says what functions are included etc.
Please help if you know where I can find something like that.
thanks
-parul
--
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe: http://lists.mysql.com/gui-tools?unsub=gcdmm-mycc@m.gmane.org
|
| | Add comment |
Thursday, 25 January 2007
|
| Easiest Way To Replicate DB John Kopanas 22:14:42 |
| | I am doing tests so I want to easy take my DB and make a full copy of
it into a test db everytime I want to test something against the
non-produciton version of DB. What is the easiest way to do this.
So I have a DB called "backlog" and I want to copy it's structure and
data into "backlog_test" with ease  . Any sexy suggetions?
Your Friend,
John
--
John Kopanas
john@kopanas.com
http://www.kopanas.com
http://www.cusec.net
http://www.soen.info
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| |  1 answer | Add comment |
|
| speeding up a join COUNT James Tu 21:14:55 |
| | I'm performance testing my 'users' table. It currently has roughly
1M user records. The 'geo_entities' table has ~ 250 records.
Here's my query.
SELECT users.entity_id, geo_entities.entity_name,
geo_entities.short_code, COUNT( users.entity_id )
FROM users, geo_entities
WHERE users.user_type = 'user'
AND users.entity_id = geo_entities.id
GROUP BY entity_id
LIMIT 0 , 30
It took 51 seconds to execute.
Both tables only have an index on their unique record id.
Is there a way to speed up this up?
-James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 4 answer | Add comment |
|
| MySQL GUI Common 5.0r9 compile problem Doruk Fisek 20:13:35 |
| | Hi,
I am getting an error when compiling mysql-gui-common from
MySQL-Gui-Tools 5.0r9. The installed version of MySQL is 5.0.27.
configure script (without any additional parameters) doesn't generate
an error. During compilation I get :
gcc -DHAVE_CONFIG_H -I. -I. -I../../.. -I../include
-I../../../library/utilities/shared_include
-I../../../library/utilities/include
-I../../../library/sql-parser/include -I/usr/include/mysql -mtune=i686
-pipe -fomit-frame-pointer -DHAVE_ERRNO_AS_DEFINE=1
-I/usr/include/glib-2.0 -I/usr/lib/glib-2.0/include
-I/usr/include/libxml2 -Wall -Wsign-compare -MT myx_library.lo -MD -MP
-MF .deps/myx_library.Tpo -c myx_library.c -fPIC -DPIC
-o .libs/myx_library.o In file included
from /usr/include/mysql/my_global.h:84, from
myx_library.c:35: /usr/include/mysql/my_config.h:979:1: warning:
"PACKAGE" redefined In file included from
myx_library.c:28: ../../../config.h:65:1: warning: this is the location
of the previous definition In file included
from /usr/include/mysql/my_global.h:84, from
myx_library.c:35: /usr/include/mysql/my_config.h:985:1: warning:
"PACKAGE_NAME" redefined In file included from
myx_library.c:28: ../../../config.h:71:1: warning: this is the location
of the previous definition In file included
from /usr/include/mysql/my_global.h:84, from
myx_library.c:35: /usr/include/mysql/my_config.h:988:1: warning:
"PACKAGE_STRING" redefined In file included from
myx_library.c:28: ../../../config.h:74:1: warning: this is the location
of the previous definition In file included
from /usr/include/mysql/my_global.h:84, from
myx_library.c:35: /usr/include/mysql/my_config.h:991:1: warning:
"PACKAGE_TARNAME" redefined In file included from
myx_library.c:28: ../../../config.h:77:1: warning: this is the location
of the previous definition In file included
from /usr/include/mysql/my_global.h:84, from
myx_library.c:35: /usr/include/mysql/my_config.h:994:1: warning:
"PACKAGE_VERSION" redefined In file included from
myx_library.c:28: ../../../config.h:80:1: warning: this is the location
of the previous definition In file included
from /usr/include/mysql/my_global.h:84, from
myx_library.c:35: /usr/include/mysql/my_config.h:1110:1: warning:
"VERSION" redefined In file included from
myx_library.c:28: ../../../config.h:86:1: warning: this is the location
of the previous definition In file included from
myx_library.c:35: /usr/include/mysql/my_global.h:318:24: asm/atomic.h:
No such file or directory make[4]: *** [myx_library.lo] Hata 1
I had no problem compiling in MySQL-Gui-Tools 5.0r8. Any advice?
Doruk
--
FISEK INSTITUTE - http://www.fisek.org.tr
--
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe: http://lists.mysql.com/gui-tools?unsub=gcdmm-mycc@m.gmane.org
|
| | Add comment |
|
| SSQLS v2 :) Королев Илья 18:18:54 |
| | Hello
I'm studying expanded SSQLS code and I have a question.
As I can see, field_list() (for example) return a temporary object of
<ClassName>_field_list. And real output to stream operate with it. I wonder,
what are advantages of such approach? Why we can't just return std::string in
field_list()? Disadvantage is heavy *.h.
Thanks
--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsub=gcdmc-plusplus@m.gmane.org
|
| | 11 answers | Add comment |
|
| Query Two Databases Neil Tompkins 14:09:44 |
| | Not sure if this is possible or not. But I've two identical tables in two
different databases. Is it possible to retrieve data from the different
tables in one query ?
Thanks
Neil
_________________________________________________________________
MSN Hotmail is evolving check out the new Windows Live Mail
http://ideas.live.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 5 answers | Add comment |
|
| low-priority-updates and innodb tables Vitaliy Okulov 12:27:25 |
| | Здравствуйте, mysql.
Hi all.
I want to ask about low-priority-updates and innodb tables. Does
low-priority-updates=1 affect on priority of select or update query on
innodb type tables?
--
С уважением,
Vitaliy mailto:vitaliy.okulov@gmail.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 1 answer | Add comment |
|
| MySql Version difference Nilesh 09:50:23 |
| | Hi,
I have a webapplication developed using J2EE. For the application, the
database is on MySQL 5.0.18 version . Now I plan to use the lastest MySQL
version (5.0.27). But before that i want to know the differences between
these 2 versions and whether the current database will work fine with 5.0.27
version.
How could i know the difference between these 2 version and there
compatiblity.
Thanks and Regards,
Nilesh
|
| | 2 answer | Add comment |
|
| best way to query this table Randy Paries 00:39:13 |
| | Hello,
I have a table that has a column that has a timestamp Column.
This table is going to get very large ( 1 or 2 million rows) and will
be queried alot.
Alot of these queries will be against timestamp column.
These queries will be like, getting entries for today, this week and this month
I have indexed the column, but i am wondering if i should create a
couple of int columns that would be day of week, week of year and
month and query against these instead.
would love you opinions
thanks
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 2 answer | Add comment |
|
| ODBC per Mysql da Windows Guest 00:39:13 |
| |
I wont to connect:
Client: Windows Microsoft Acces
Server: Linus - DB: Mysql
Is possible?
Tank you.
Francesco Moscatelli
fmoscatelli@interfree.it
Tel. 335 373675
----------------------------------------------------------------------------
Vuoi rendere inaccessibili agli altri i tuoi documenti riservati?
Prova Ksek! Il potente software di cifratura di Interfree.
Scopri le sue funzionalita': http://ksek.interfree.it/
Lo Staff di Interfree
----------------------------------------------------------------------------
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org
|
| | 1 answer | Add comment |
|
| mysqlmanager safe? David Sparks 00:39:13 |
| | I've switched over to the mysqlmanager startup system instead of the old
mysqld_safe because thats the only supported method in mysql5.
I needed to restart a DB so I did a `/etc/init.d/mysqlmanager restart`
which seemed to work, but there were some problems:
- the daemon was no longer accepting connections
- ps showed 2 copies of mysqld running
I also noticed a lot of errors like this in mysqld.err:
070124 15:27:02 [ERROR] /usr/sbin/mysqld: Incorrect information in file:
'./databasename/table.frm'
One of the daemon processes would not respond to kill so eventually I
fired up gdb and killed it (it was stuck on a futex operation). I then
restarted mysql and it went through a huge crash recovery.
A co-worker tells me that mysqlmanager has been known to do this for
ages. Is this true? The DB in question is all InnoDB, approx 150GB in
12 tables. mysql version 5.0.30.
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | Add comment |
Wednesday, 24 January 2007
|
| Problem with localtime_s in vs2003 Martin Jones 23:35:49 |
| | Hi,
I have just installed mysql++ 2.2.0 with vs2003 RTL
This generates the following compiler error:
lib\datetime.cpp(194): error C3861: 'localtime_s': identifier not found,
even with argument-dependent lookup
localtime_s only exists in vs2005, in 2003 we only have localtime
Suggest change it to something like the following:
DateTime::DateTime(time_t t)
{
struct tm tm;
#if defined(_MSC_VER) && !defined(_STLP_VERSION)
# if _MSC_VER >= 1400
localtime_s(&tm, &t);
# else
tm = *localtime(&t);
# endif
#elif ...
Martin
--------------------------------------------------------
If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail. http://www.ml.com/email_terms/
--------------------------------------------------------
--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsub=gcdmc-plusplus@m.gmane.org
|
| | 1 answer | Add comment |
|
| After backup/restore view turns to table Davor Dundovic 17:56:33 |
| |
Hi All !
I did "mysqldump mydb -uroot -ppass --databases --add-locks
--allow-keywords --create-options --extended-insert --routines -r file.sql"
and after that in MySQL Command Line Client "source file.sql"
After that my view was converted to an empty table.
What should I do to backup and restore my view correctly ?
Regards, Dundo.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 1 answer | Add comment |
|
| Alias a function result? Jerry Schwartz 17:32:54 |
| | I know that you can alias a function result as easily as anything else, but
I've run into a problem with an application I inherited. For reasons too
murky to go into, I would like to refer to the result of a group function as
the name of the argument of the function. Here's an example of what I mean:
SELECT book_author, GROUP_CONCAT(book_title) AS book_title GROUP BY
book_author WHERE book_title LIKE "<something>";
This actually seems to work, but it makes me ill to look at it. Is this
legal, or have I found a loophole that might be closed in the future?
I'm using server version 4.1.21-standard.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
|
| | 5 answers | Add comment |
|
| [urgent] - Problem with index_merge Ratheesh K J 15:03:31 |
| | Hello all,
I have struck with a big problem with MySQL 5.0.22 server on RHEL 3.
After an upgradation from MySQL 4.1.11 to MySQL 5.0.22 almost all the queries are struggling to execute and the DB server is clogged. Below is an example of what is happening.
This query usd to execute very fast on MySQL 4.1.11 (in about less than 10 seconds). But on MySQL 5.0.22 it is taking an eternity. Running an EXPLAIN shows that an index_merge is being used as shown below in the EXPLAIN result. On MySQL 4.1.11 the the PRIMARY key was being used as the index as shown in the second query(The same query with FORCE index on PRIMARY). I am really confused as to why it is taking such a long time to execute when an index_merge is being used. As we can see that the number of row scans using index_merge is way too less when compared to the second query.
Why is the first query so slow when compared to the second one even if the number of rows to be examined is too less in the former?
Is this a bug in index_merge?
And we have atleast 15 such queries always running on the system. The server is clogged !!
Query with index_merge
# Execution time : 53 seconds
EXPLAIN
SELECT
SUM(1) AS ELE13,
SUM( IF( TFMM.FLD_ISSUE_CLOSED = 1, 1, 0 ) ) AS ELE14,
SUM( IF( ( TFMM.FLD_ISSUE_CLOSED = 2 OR TFMM.FLD_ISSUE_CLOSED = 5 ) , 1, 0 ) ) AS ELE15,
SUM( IF( TFMM.FLD_ISSUE_CLOSED = 4, 1, 0 ) ) AS ELE16,
SUM( IF( TFMM.FLD_ISSUE_CLOSED = 3, 1, 0 ) ) AS ELE17,
SUM( IF( TFMM.FLD_ASSIGNED_TO = 134, 1, 0 ) ) AS ELE18,
SUM( IF( TFMM.FLD_ISSUE_CLOSED != 3 AND TFMM.FLD_ASSIGNED_TO = 134 AND TFMM.FLD_USR_SEEN_FLAG = 0, 1, 0 ) ) AS ELE19,
SUM( IF( ( TFMM.FLD_ISSUE_CLOSED = 2 OR TFMM.FLD_ISSUE_CLOSED = 5 ) AND TFMM.FLD_ASSIGNED_TO = 134 AND TFMM.FLD_USR_SEEN_FLAG = 1, 1, 0 ) ) AS ELE20,
SUM( IF( TFMM.FLD_ISSUE_CLOSED = 4 AND TFMM.FLD_ASSIGNED_TO = 134, 1, 0 ) ) AS ELE21,
SUM( IF( TFMM.FLD_ISSUE_CLOSED = 3 AND TFMM.FLD_ASSIGNED_TO = 134, 1, 0 ) ) AS ELE22
FROM TBL_FORUMS_MSG_MAIN TFMM
WHERE TFMM.FLD_ACC_ID in (6)
AND TFMM.FLD_PARENT_ID = 0
AND TFMM.FLD_MSG_ID > 0
AND TFMM.FLD_MARK_AS_DELETED = 0
AND TFMM.FLD_BLOCK_STATE = 0
AND TFMM.FLD_BOUNCED_MAIL_FLAG = 0
AND TFMM.FLD_ESCALATED_FLAG = 0
AND TFMM.FLD_ADD_DATE_TIME >= '2007-01-23 00:00:00'
AND TFMM.FLD_ADD_DATE_TIME <='2007-01-23 23:59:00'
ORDER BY TFMM.FLD_ADD_DATE_TIME
;
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
*** row 1 ***
table: TFMM
type: index_merge
possible_keys: PRIMARY,FLD_PARENT_ID,FLD_ADD_DATE_TIME,FLD_MARK_AS_DELETED,FLD_ACC_ID,FLD_BLOCK_STATE,FLD_ESCALATED_FLAG,FLD_BOUNCED_MAIL_FLAG
key: FLD_PARENT_ID,FLD_MARK_AS_DELETED,FLD_ACC_ID,FLD_BLOCK_STATE,FLD_ESCALATED_FLAG,FLD_BOUNCED_MAIL_FLAG
key_len: 4,2,2,2,2,2
ref: NULL
rows: 10170
Extra: Using intersect(FLD_PARENT_ID,FLD_MARK_AS_DELETED,FLD_ACC_ID,FLD_BLOCK_STATE,FLD_ESCALATED_FLAG,FLD_BOUNCED_MAIL_FLAG); Using where
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Query with FORCE INDE PRIMARY)
# Execution time : 13 seconds
EXPLAIN
SELECT
SUM(1) AS ELE13,
SUM( IF( TFMM.FLD_ISSUE_CLOSED = 1, 1, 0 ) ) AS ELE14,
SUM( IF( ( TFMM.FLD_ISSUE_CLOSED = 2 OR TFMM.FLD_ISSUE_CLOSED = 5 ) , 1, 0 ) ) AS ELE15,
SUM( IF( TFMM.FLD_ISSUE_CLOSED = 4, 1, 0 ) ) AS ELE16,
SUM( IF( TFMM.FLD_ISSUE_CLOSED = 3, 1, 0 ) ) AS ELE17,
SUM( IF( TFMM.FLD_ASSIGNED_TO = 134, 1, 0 ) ) AS ELE18,
SUM( IF( TFMM.FLD_ISSUE_CLOSED != 3 AND TFMM.FLD_ASSIGNED_TO = 134 AND TFMM.FLD_USR_SEEN_FLAG = 0, 1, 0 ) ) AS ELE19,
SUM( IF( ( TFMM.FLD_ISSUE_CLOSED = 2 OR TFMM.FLD_ISSUE_CLOSED = 5 ) AND TFMM.FLD_ASSIGNED_TO = 134 AND TFMM.FLD_USR_SEEN_FLAG = 1, 1, 0 ) ) AS ELE20,
SUM( IF( TFMM.FLD_ISSUE_CLOSED = 4 AND TFMM.FLD_ASSIGNED_TO = 134, 1, 0 ) ) AS ELE21,
SUM( IF( TFMM.FLD_ISSUE_CLOSED = 3 AND TFMM.FLD_ASSIGNED_TO = 134, 1, 0 ) ) AS ELE22
FROM TBL_FORUMS_MSG_MAIN TFMM FORCE INDEPRIMARY)
WHERE TFMM.FLD_ACC_ID in (6)
AND TFMM.FLD_PARENT_ID = 0
AND TFMM.FLD_MSG_ID > 0
AND TFMM.FLD_MARK_AS_DELETED = 0
AND TFMM.FLD_BLOCK_STATE = 0
AND TFMM.FLD_BOUNCED_MAIL_FLAG = 0
AND TFMM.FLD_ESCALATED_FLAG = 0
AND TFMM.FLD_ADD_DATE_TIME >= '2007-01-23 00:00:00'
AND TFMM.FLD_ADD_DATE_TIME <='2007-01-23 23:59:00'
ORDER BY TFMM.FLD_ADD_DATE_TIME
;
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
*** row 1 ***
table: TFMM
type: range
possible_keys: PRIMARY
key: PRIMARY
key_len: 4,
ref: NULL
rows: 1059133
Extra: Using where
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Thanks
Ratheesh K J
|
| | Add comment |
|
| Innodb Error 1030 Gary Huntress 14:46:52 |
| | I'm trying to fix a problem with a users innodb database (mysql 5.0). When they try a very simple insert they get "ERROR 1030 (HY000): Got error -1 from storage engine" I have dumped and reloaded the tables but the problem persists. CHECK TABLE does not indicate an error.
I stopped and restarted the server once normally, without attempting any innodb_force_recovery options.
There are no other unusual indications on the server. It has not been shut down abruptly recently, the load is low, memory and disk space is fine.
Does anyone have any suggestions for correcting this error?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | Add comment |
|
| MySQL5 becomes so slowly when bin log is open Gulei 11:28:06 |
| | MySQL5 becomes so slowly when bin log is open.
I used sysbench to test mysql.
MySQL version is mysql-standard-5.0.27-linux-i686-icc-glibc23.tar.gz
OS is RHEL 4.0
my.cnf is :
[mysqld]
#log-bin=icc
max_connections=3000
innodb_log_file_size=50M
max_prepared_stmt_count=32765
#log=Buddha.log
query_cache_size=16M
innodb_buffer_pool_size=800M
#key_buffer_size=512M
server-id=55
port=3309
I used sysbench to test mysql just like this:
sysbench --max-requests=10000 --mysql-host=172.20.23.28
--mysql-user=sbtest --mysql-password=sbtest --mysql-port=3309
--num-threads=50 --test=oltp --oltp-table-size=10000 run
It completed 396 transactions per second whithout bin log.
But when bin log is enabled, only 76 transactions per second.
I also tested MySQL5.0.33. Almost the same result.
But mysql4.1.22 didn't have that problem.
The whole sysbench's result is below:
When bin log is closed:
sysbench --max-requests=10000 --mysql-host=172.20.23.28 --
mysql-user=sbtest --mysql-password=sbtest --mysql-port=3309
--num-threads=50 --test=oltp -
-oltp-table-size=10000 run
sysbench v0.4.8: multi-threaded system evaluation benchmark
No DB drivers specified, using mysql
WARNING: Preparing of "BEGIN" is unsupported, using emulation
(last message repeated 49 times)
Running the test with following options:
Number of threads: 50
Doing OLTP test.
Running mixed OLTP test
Using Special distribution (12 iterations, 1 pct of values are returned
in 75 pct cases)
Using "BEGIN" for starting transactions
Using auto_inc on the id column
Maximum number of requests for OLTP test is limited to 10000
Threads started!
Done.
OLTP test statistics:
queries performed:
read: 140042
write: 50009
other: 20004
total: 210055
transactions: 10001 (396.49 per sec.)
deadlocks: 2 (0.08 per sec.)
read/write requests: 190051 (7534.67 per sec.)
other operations: 20004 (793.07 per sec.)
Test execution summary:
total time: 25.2235s
total number of events: 10001
total time taken by event execution: 1258.4014
per-request statistics:
min: 0.0301s
avg: 0.1258s
max: 0.4040s
approx. 95 percentile: 0.1926s
Threads fairness:
events (avg/stddev): 200.0200/3.52
execution time (avg/stddev): 25.1680/0.03
When bin log is open :
sysbench --max-requests=10000 --mysql-host=172.20.23.28 --
mysql-user=sbtest --mysql-password=sbtest --mysql-port=3309
--num-threads=50 --test=oltp -
-oltp-table-size=10000 run
sysbench v0.4.8: multi-threaded system evaluation benchmark
No DB drivers specified, using mysql
WARNING: Preparing of "BEGIN" is unsupported, using emulation
(last message repeated 49 times)
Running the test with following options:
Number of threads: 50
Doing OLTP test.
Running mixed OLTP test
Using Special distribution (12 iterations, 1 pct of values are returned
in 75 pct cases)
Using "BEGIN" for starting transactions
Using auto_inc on the id column
Maximum number of requests for OLTP test is limited to 10000
Threads started!
Done.
OLTP test statistics:
queries performed:
read: 144886
write: 50743
other: 20349
total: 215978
transactions: 10000 (76.92 per sec.)
deadlocks: 349 (2.68 per sec.)
read/write requests: 195629 (1504.68 per sec.)
other operations: 20349 (156.51 per sec.)
Test execution summary:
total time: 130.0134s
total number of events: 10000
total time taken by event execution: 6485.2686
per-request statistics:
min: 0.0353s
avg: 0.6485s
max: 6.0622s
approx. 95 percentile: 1.8840s
Threads fairness:
events (avg/stddev): 200.0000/14.86
execution time (avg/stddev): 129.7054/0.17
Are there any tips?
Or maybe I should use mysql4.1 ?
Thanks
Gu Lei
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | Add comment |
|
| RELEASE: v2.2.0 Warren Young 00:43:38 |
| | At long last, v2.2.0 is here. There is only one minor bug fix since the
beta, but if you didn't see the previous announcement, here's the change
list since v2.1.1:
o ColData, const_string, and SQLString can now be constructed
with an explicit length parameter. Furthermore, Query
class's execute(), store() and use() call chains terminate
in a version taking an explicit length parameter, instead
of one taking a simple C string. Together, this means
that it's now easier to handle data from the SQL server
containing nulls. The library is almost certainly not yet
capable of handling embedded nulls in all cases, but this
is a big first step towards that.
o Can now construct a DateTime object from a time_t, and
convert a DateTime back to a time_t. Patch by Korolyov Ilya.
o Changed the way we're handling exported functions in the
Windows DLL case so that it works more reliably under MinGW.
o Added proper copy semantics to Connection, so that you get a
new connection with the same parameters, not just a bitwise
copy of the object.
o Using an explicitly thread-safe variant of localtime() for
time conversions where one is available.
o Removed ListInsert template from myset.h. This wasn't used
within the library, and was never documented, so I'm betting
that no one actually uses it.
o Result::copy() was not copying the exception flag in
all cases. Fix by Steven Van Ingelgem.
o Added exrun shell script and exrun.bat files to distribution,
to avoid linkage errors when running the examples while
you still have an older version of MySQL++ installed.
o Renamed MYSQLPP_LIB_VERSION to MYSQLPP_HEADER_VERSION, as
what it really encodes is the version number in the mysql++.h
file you're using, not the actual library version number.
o Added mysqlpp::get_library_version(), which returns the
library version number at build time. Between this and
the header version constant, you can check that you're not
mixing MySQL++ header and library versions.
o resetdb example uses these new version number affordances to
double-check that you're not mixing libraries and headers
from different versions. This happens easily unless you
take care of it (such as by using exrun) when you have one
version of MySQL++ installed and you're trying to build and
test a new version without blowing away the old one first
or overwriting it.
o No longer using recursive Makefiles on Unixy platforms
or split lib + examples project files on VC++. Everything is
handled by a single top-level Makefile or project file, which
is simpler for the end user, and makes better dependency
management possible.
o When looking for the MySQL C library on systems using
autoconf, looking in .../lib64 wherever we are also looking
in .../lib.
o RPM build process no longer depends on Bakefile. It means
you have to build the examples when building an RPM even
though they're never used within the RPM, but it's a better
tradeoff in my opinion.
o Updated include and library paths on Windows to reflect
changes in the most recent MySQL installers.
o Merged lib/defs.h and lib/platform.h into new file,
lib/common.h. Just cleans up the library internals.
o Fixed build errors on Windows due to recent changes in MySQL.
o Fixed a few memory leaks and double-deletes in Query class.
o Fixed compatibility with STLPort's string implementation.
Patch by dengxy at cse.buaa.edu.cn.
o Fixed a compatibility problem between Set<> template and
SSQLS. Patch by Korolyov Ilya.
o Fixed build bug in SQLQueryParms due to a character
signedness issue on PowerPC with GCC. Patch by Michael
Hanselmann.
o ~Transaction() can no longer throw exceptions. It'll just
quietly eat them, to avoid program termination. Fix
suggested by Alex Burton.
o Fixed thread safety testing in autoconf case, accidentally
broken during v2.1.0 development cycle.
o Using Doxygen 1.5.1 to generate documentation.
As always, you can get it from http://tangentsoft.net/mysql++/
--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsub=gcdmc-plusplus@m.gmane.org
|
| | Add comment |
Tuesday, 23 January 2007
|
| Re: Broken Links - 2nd Try Warren Young 23:49:05 |
| | Bill K wrote:>
These links are broken, currently, on your site.
Patience, my man. I'm literally in the process of updating the site
right now. You can check for link integrity once the RELEASE message
hits the list.
--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsub=gcdmc-plusplus@m.gmane.org
|
| | Add comment |
|
| Unable to put data on a different computer from mysql Kelly Solakofski 22:46:05 |
| | I've been trying to put the data onto our data drive, and the mysql
application on the main server. I've edited the my.ini file correctly.
I can get it to work on different drives where the data is on the same
computer as mysql. I can't get it to work where the data is on a
different computer.
Below is a copy of the my.ini. I've also tried it where my
datadir=S:/mydata/data where I put the virtual drive letter in. No go.
the service will not start. I'm using version 4.0.18-nt. I've also
tried it with version 4.1.21-win32. Same result. Works on a different
drive but both mysql and data must be on the same computer. Any thoughts?
#This File was made using the WinMySQLAdmin 1.4 Tool
#10/17/2005 10:37:37 AM
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
[mysqld]
basedir=C:/mysql
#bind-address=127.0.0.1
datadir=//SOFTWOODSERVER/SharedDocs/mydata/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
#set-variable=max_allowed_packet=3M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=PTurk
password=password
--
Kelly Solakofski
Softwood Technology
Customer Service Manager
416-504-8724
Kelly.Solakofski@SoftwoodTechnology.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 2 answer | Add comment |
|
| Backup: Copy MYSQL Directory or use MysqlDump Altendew 17:10:20 |
| |
I want to create a backup for my MySQL database every single night.
I am currently running on a linux box. I have a backup drive located as
/backup
Would it be more effecient to use mysqldump tool, or use the unix command
"dump or cp"
Andrew
--
View this message in context: http://www.nabble.com/Backup%3A-Copy-MYSQL-Directory-or-use-MysqlDump-tf3061490.html#a8513292
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org
|
| | 4 answer | Add comment |
|
|
