meta user
network profile
| bio | website | logicworks.net/products |
|---|---|---|
| location | New York, NY (USA) | |
| age | 48 | |
| visits | member for | 2 years, 3 months |
| seen | 21 mins ago | |
| stats | profile views | 4,527 |
One of JEHOVAH's Witnesses (Ex 6:2,3; 9:16; Isa 12:2,4,5)
Senior MySQL DBA (SCMDBA since 2007-08-11) with LogicWorks, provider of The Cloud Your Way (LinkedIn,Twitter,FaceBook). I currently support various MySQL Replication Topologies (Master/Slave, Master/Master, DRBD, Percona XtraDB Cluster) for Clients of Managed DB Services (Hardware and High Availability) in DB/Web/Cloud Hosting Environments (60+ MySQL Clients) since November 12, 2007.
|
17m |
reviewed | Close Postgresql - how to drop a trigger |
|
2h |
reviewed | Close Is Logical Fragmentation Meaningful in the age of huge SANs? |
|
2h |
reviewed | Close MySQL - Match two tables contains HUGE DATA and find the similar data |
|
1d |
comment |
Allocating 8GB memory to MySQL on a 64bit system +1 for finding your own solution |
|
1d |
comment |
Allocating 8GB memory to MySQL on a 64bit system Please run this query : SHOW VARIABLES LIKE 'version_comment';. This will tell us the OS and bit version of mysqld. |
|
1d |
comment |
Allocating 8GB memory to MySQL on a 64bit system You should try to post your entire my.cnf into the question |
|
1d |
comment |
Allocating 8GB memory to MySQL on a 64bit system Lower it back to 4G, restart mysql, and run this one also : SELECT SUM(data_length + index_length) POWER(1024,3) innodb_space FROM information_schema.tables WHERE engine='InnoDB'; |
|
1d |
reviewed | Close Data Migration from Oracle to SQL Server |
|
1d |
revised |
Allocating 8GB memory to MySQL on a 64bit system deleted 2 characters in body; edited tags |
|
1d |
reviewed | Approve suggested edit on Storing history of full/partial tables in MySQL |
|
2d |
comment |
MySQL : Query WHERE clause and JOIN Did the index on StartTime help ? |
|
2d |
comment |
MySQL Insert Row With Foreign Key Equal to ID - Circular ReferenceSHOW CREATE TABLE events\G will display the SQL statement that will create the table as well as the storage engine the table is using. This is what @ypercube was asking you. When you run this command, copy and paste the output of SHOW CREATE TABLE events\G into the question. |
|
2d |
revised |
MySQL : Query WHERE clause and JOIN added 115 characters in body |
|
2d |
comment |
MySQL : Query WHERE clause and JOIN Is StartTime indexed ??? |
|
2d |
revised |
MySQL Master/Slave without populating tables added 193 characters in body |
|
2d |
answered | MySQL Master/Slave without populating tables |
|
2d |
awarded | Reviewer |
|
2d |
reviewed | Close How do I add a index column to a database with non unique columns |
|
2d |
reviewed | Close When is it worth it to use Triggers and stored procedures/functions? |
|
2d |
reviewed | Close populate table header and data in another table column |
