meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 10 months |
| seen | May 21 at 14:16 | |
| stats | profile views | 3 |
|
Sep 21 |
awarded | Custodian |
|
Sep 20 |
comment |
High MySQL CPU usage, queries seem fine, not running ntp Sure, just: set global long_query_time=0; However, I believe that if your clients are already connected, they won't pick up the setting until you disconnect/reconnect. |
|
Sep 20 |
answered | High MySQL CPU usage, queries seem fine, not running ntp |
|
Sep 18 |
answered | How do I persist recurring events? |
|
Sep 18 |
comment |
What is the difference between 'two way transactional replication' and 'peer to peer replication'? It would probably be helpful if you specified what database software you are talking about. |
|
Sep 18 |
comment |
change encoding of database from latin1_swedish_ci to utf8 A common technique would be to create an identical table structure with the new collation and then do a INSERT INTO new_table_name SELECT * from old_table_name. Then you can inspect the results of the collation change. |
|
Sep 18 |
comment |
change encoding of database from latin1_swedish_ci to utf8 I don't know, but I gave a +1 for being a good question. My sense is that Rolando is right, changing the databases default collation would only affect new tables being created, you'll still have to alter all your tables. |
|
Sep 17 |
awarded | Supporter |
|
Sep 17 |
reviewed | Reviewed Maximum number of databases for single instance of PostgreSQL 9 |
|
Sep 17 |
answered | Merge 2 tables and fetch data one by one |
|
Jul 18 |
answered | How to concatenate psql variables? |
|
Jul 12 |
comment |
How to configure postgresql to use multiple cores? Oh, I didn't even see that was the version that came up in Google. The text is the same even in the current 9.3 dev version: postgresql.org/docs/devel/static/connect-estab.html |
|
Jul 12 |
answered | MySQL, “columns partitioning” when multiple columns are individiually important |
|
Jul 12 |
awarded | Teacher |
|
Jul 12 |
answered | How to configure postgresql to use multiple cores? |
