|
More site info...
MySQL AB - MySQL Forums - www.mysql.com | Site profile
|
|
Site profile page for http://www.mysql.com.
This report page has aggregated and summarized the online discussions from the Message Board located at http://www.mysql.com.
This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional site profile information for http://www.mysql.com is also shown in the following divisions:
1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a site's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity table on MySQL AB - MySQL Forums:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
223
|
807
|
2,367
|
|
Post:
|
284
|
1,178
|
3,299
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for MySQL AB - MySQL Forums (http://www.mysql.com)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
MySQL AB - MySQL Forums posting activity graph:
|
|
http://www.mysql.com Alexa graph:
|
Top authors on MySQL AB - MySQL Forums during last week:
user's latest post:
Re: partitioning
Published (2009-11-20 19:47:00)
* Shoveling the 50M rows into the table will take time. * Why did you decide to use Partition? * Can you live without FOREIGN KEYs? * If you need to SELECT by either week or month, you should consider partitioning by DAY.
user's latest post:
Re: Need table name
Published (2009-11-19 23:08:00)
Not doable. By its nature, a Trigger is specific to one table and one table only, so if your trigger doesn't know what table it's servicing, something is wrong. PB http://www.artfulsoftware.com
user's latest post:
Re: partitioning
Published (2009-11-20 05:01:00)
You colud use table partitioned by range as an example. Note that partitioning is based on DATE column. This script creates some partitions for some months. CREATE TABLE l_play( ... dateField DATE DEFAULT NULL) PARTITION BY RANGE (TO_DAYS(dateField)) ( PARTITION p0 VALUES LESS THAN (TO_DAYS('2009-11-01')), PARTITION p1 VALUES LESS THAN (TO_DAYS('2009-12-01')), PARTITION p2 VALUES LESS THAN (TO_DAYS('2010-01-01')),...
user's latest post:
MySQL Workbench 5.2.8 (BETA 1):...
Published (2009-11-18 17:29:00)
WB 5.2.8 includes: - Model (upgrade from DBDesigner) - Query (upgrade from MySQL Query Browser) - Admin (upgrade from MySQL Administrator) - SSH-Tunnel (new) Quick-Start Tutorial: http://wb.mysql.com/?p=406 Download WB 5.2: http://dev.mysql.com/downloads/workbench/
user's latest post:
Re: errno 136 while importing db...
Published (2009-11-19 09:52:00)
sarang. s Wrote: ------------------------------------------------------- > This is my config file : > > > DataMemory=4000M > IndexMemory=1024M > MaxNoOfTables=4096 > MaxNoOfAttributes=24756 > MaxNoOfOrderedIndexes=30000 > MaxNoOfUniqueHashIndexes=1250 From your log we can telll IndexMemory is sufficient. I assume that you had restarted the ndb_mgmd nodes and both ndbd nodes...
user's latest post:
Re: innodb monitor output
Published (2009-11-19 22:41:00)
Hi Just sharing some ideas with experts to improvise the scope my MySQL skills 1. Best option will be query tuning as rick said, 2. try to avoid limit as much as possible 3. Use mysql slow query analyzer http://www.mysqlperformanceblog.com/files/utils/mysql_slow_log_parser sometimes a simple query might logged as slow query based on various conditions, for example based on waiting of result of other query or whatever, but this tool will let...
user's latest post:
Re: Issue looping through cursor...
Published (2009-11-12 09:01:00)
Liam, I think you can do what you want without cursors. Here's what it looks like you are trying to do: 1) Get all the data from mtor_srf_test into mrp_database, inserting or updating as necessary. 2) Populate mrp_update with all rows from mtor_sft_test that caused a changed to mrp_database. If those two assertions are correct, then this query should pull the data you are intersted in from mtor_sft_test: select t.msisdn, t.mrpOperator...
user's latest post:
Re: errno 136 while importing db...
Published (2009-11-19 09:12:00)
Andrew Hutchings Wrote: ------------------------------------------------------- > 2. MaxNoOfAttributes is full Sorry, I was wrong here, MaxNoOfOrderedIndexes/MaxNoOfUniqueHashIndexes. -- Andrew Hutchings, MySQL Support Engineer, Americas Sun Microsystems, United Kingdom http://www.sun.com/mysql/
user's latest post:
New to Workbench
Published (2009-11-13 11:36:00)
Using mysql admin, backup was easy. I cant find backup in workbench, where is it using mysql 5.4.
|
|
|
Top 10 active forums on MySQL AB - MySQL Forums during last week:
|
|
Top 10 forums on MySQL AB - MySQL Forums:
Stored Procedures
- 4,062 posts
|
Performance
- 2,759 posts
|
Cluster
- 2,321 posts
|
Replication
- 1,900 posts
|
InnoDB
- 1,887 posts
|
Triggers
- 1,086 posts
|
MySQL Proxy
- 1,028 posts
|
Source, Builds, Binaries
- 868 posts
|
Workbench - Newbie
- 758 posts
|
Character Sets, Collation, Unicode
- 731 posts
|
|
|
|
|
Latest active threads on MySQL AB - MySQL Forums:
No activity within last 3 months.
|
|
Hot threads for last week on MySQL AB - MySQL Forums:
Started 2 days, 7 hours ago (2009-11-20 04:25:00)
by Peter Fedeux
If you view the database on phpmyadmin do all the innodb tables say "in use"?
If so I also have this problem when setting any innodb settings in the my.cnf
Started 1 week, 2 days ago (2009-11-13 09:27:00)
by Pavel Bazanov
Also, is lock escalation is possible in InnoDb ?
Started 3 days, 9 hours ago (2009-11-19 02:16:00)
by Devart Team
Firstly - field and variable names have to be different in this case.
For example:
out imagelink varchar(300) -> out imagelinkValue varchar(300)
And rewrite select:
select imagelink into imagelinkValue from items limit 1;
Devart Company,
Database development tools
http://www.devart.com/dbforge .
Started 3 days, 2 hours ago (2009-11-19 08:57:00)
by Andrew Hutchings
Show Warnings needs to be done in the mysql node, not the data node. It needs to be executed straight after the error occurs and before any other statements.
As a bare minimum you should get the same error repeated in the response. In cluster this error code can happen for one of two reasons:
1. IndexMemory is full
2. MaxNoOfAttributes is full
You can test for number one with ...
Started 3 days, 15 hours ago (2009-11-18 19:39:00)
by Rick James
Well, well, this is the first time I have seen the error this far from what the "near" points to.
Course_ID int( 11 ) NOT NULL, AUTO_INCREMENT , Course_Name VARCHAR( 50 ) ,
B A
The 'near' is pointing to "A", but the bug is at "B".
Started 1 week, 1 day ago (2009-11-13 22:24:00)
by Peter Brawley
> DELETE FROM [myTable] WHERE id=3;
We can't just make up syntax. Dynamic queries are possible using PREPARE, but PREPARE is not allowed in functions and triggers.
PB
http://www.artfulsoftware.com
Started 2 days, 12 hours ago (2009-11-19 23:12:00)
by Rick James
Please show a suggested schema (SHOW CREATE TABLE...).
What do you mean by mirror?
Isolation level only applies to InnoDB.
Transactions may or may not be required; can't tell from this overview.
Most of your questions are less relevant for performance than the layout of the tables, the indexes, and the structure of the SELECTs.
If the traffic is high enough, you should ...
Started 2 days, 6 hours ago (2009-11-20 05:01:00)
by Devart Team
You colud use table partitioned by range as an example. Note that partitioning is based on DATE column. This script creates some partitions for some months.
CREATE TABLE l_play(
...
dateField DATE DEFAULT NULL)
PARTITION BY RANGE (TO_DAYS(dateField)) (
PARTITION p0 VALUES LESS THAN (TO_DAYS('2009-11-01')),
PARTITION p1 VALUES LESS THAN (TO_DAYS('2009-12-01')),
PARTITION p2 ...
Started 1 week, 4 days ago (2009-11-10 22:25:00)
by Nanda kishore Toomula
Hi,
Thanks for your input,my first question,is this severer only for DB or application as well ?
if this is only for MySQL database,i need O/P of free -m
assuming lot of free memory available ?,
You can set innodb_buffer_pool_size up to 50 - 80 % of RAM but beware of setting memory usage too high. it should be 50 - 80 % only,because, as of your input, it is only 2.5 GB out of 8 GB ...
Started 6 days, 23 hours ago (2009-11-15 12:21:00)
by Brian O'Brien
Is there something about this question that doesn't seem answerable?
|
|
MySQL AB - MySQL Forums
Size: 182 bytes
