Linux ip-172-26-2-223 5.4.0-1018-aws #18-Ubuntu SMP Wed Jun 24 01:15:00 UTC 2020 x86_64
Apache
: 172.26.2.223 | : 3.140.247.39
Cant Read [ /etc/named.conf ]
8.1.13
www
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
BLACK DEFEND!
README
+ Create Folder
+ Create File
/
www /
server /
mysql /
mysql-test /
suite /
ndb /
r /
[ HOME SHELL ]
Name
Size
Permission
Action
bug36547.result
455
B
-rw-r--r--
loaddata_autocom_ndb.result
740
B
-rw-r--r--
ndb_add_partition.result
13.36
KB
-rw-r--r--
ndb_addnode_restart.result
384
B
-rw-r--r--
ndb_addnode_restart2.result
454
B
-rw-r--r--
ndb_alter_table.result
19.49
KB
-rw-r--r--
ndb_alter_table2.result
685
B
-rw-r--r--
ndb_alter_table3.result
1.48
KB
-rw-r--r--
ndb_alter_table_backup.result
1.76
KB
-rw-r--r--
ndb_alter_table_dml.result
1.83
KB
-rw-r--r--
ndb_alter_table_error.result
664
B
-rw-r--r--
ndb_alter_table_online.result
29.02
KB
-rw-r--r--
ndb_alter_table_online2.result
3.21
KB
-rw-r--r--
ndb_alter_table_online_multi.r...
2
KB
-rw-r--r--
ndb_auto_increment.result
11.49
KB
-rw-r--r--
ndb_autoinc.result
2.69
KB
-rw-r--r--
ndb_backup_rate.result
912
B
-rw-r--r--
ndb_basic.result
32.68
KB
-rw-r--r--
ndb_bitfield.result
8.39
KB
-rw-r--r--
ndb_blob.result
26.47
KB
-rw-r--r--
ndb_blob_big.result
1.24
KB
-rw-r--r--
ndb_blob_partition.result
9.03
KB
-rw-r--r--
ndb_bug13563280.result
224
B
-rw-r--r--
ndb_bug14166590.result
416
B
-rw-r--r--
ndb_bug17624736.result
1.71
KB
-rw-r--r--
ndb_bug17719439.result
439
B
-rw-r--r--
ndb_bug19390895.result
1.67
KB
-rw-r--r--
ndb_bug26793.result
286
B
-rw-r--r--
ndb_bug31477.result
1.85
KB
-rw-r--r--
ndb_bulk_delete.result
1.87
KB
-rw-r--r--
ndb_bushy_joins.result
88.95
KB
-rw-r--r--
ndb_cache.result
9.35
KB
-rw-r--r--
ndb_cache2.result
13.9
KB
-rw-r--r--
ndb_cache_multi.result
2.44
KB
-rw-r--r--
ndb_cache_multi2.result
3.04
KB
-rw-r--r--
ndb_cache_trans.result
6.65
KB
-rw-r--r--
ndb_charset.result
5.77
KB
-rw-r--r--
ndb_checksum.result
38
B
-rw-r--r--
ndb_column_properties.result
16.01
KB
-rw-r--r--
ndb_condition_pushdown.result
131.71
KB
-rw-r--r--
ndb_config.result
3.36
KB
-rw-r--r--
ndb_config2.result
475
B
-rw-r--r--
ndb_create_table.result
1.02
KB
-rw-r--r--
ndb_cursor.result
792
B
-rw-r--r--
ndb_database.result
1.25
KB
-rw-r--r--
ndb_dbug_lock.result
1.64
KB
-rw-r--r--
ndb_dbug_tc_select.result
6.71
KB
-rw-r--r--
ndb_dd_alter.result
28.43
KB
-rw-r--r--
ndb_dd_basic.result
21.17
KB
-rw-r--r--
ndb_dd_bug12581213.result
334
B
-rw-r--r--
ndb_dd_ddl.result
5.94
KB
-rw-r--r--
ndb_dd_disk2memory.result
15.44
KB
-rw-r--r--
ndb_dd_dump.result
15.97
KB
-rw-r--r--
ndb_dd_initial_lg.result
941
B
-rw-r--r--
ndb_dd_restore_check_tablespac...
8.3
KB
-rw-r--r--
ndb_dd_restore_compat.result
3.73
KB
-rw-r--r--
ndb_dd_sql_features.result
22.62
KB
-rw-r--r--
ndb_ddl_open_trans.result
1.44
KB
-rw-r--r--
ndb_disconnect_ddl.result
291
B
-rw-r--r--
ndb_discover_db.result
1.92
KB
-rw-r--r--
ndb_dist_priv.result
6.36
KB
-rw-r--r--
ndb_dist_priv_bug_13340854.res...
248
B
-rw-r--r--
ndb_err4012.result
2.22
KB
-rw-r--r--
ndb_error_reporter.result
5.61
KB
-rw-r--r--
ndb_fired_trigger_shortage.res...
694
B
-rw-r--r--
ndb_fk_addnode.result
1.39
KB
-rw-r--r--
ndb_fk_alter.result
8.34
KB
-rw-r--r--
ndb_fk_bugs.result
27.58
KB
-rw-r--r--
ndb_fk_build.result
2.31
KB
-rw-r--r--
ndb_fk_cascade_delete.result
4.82
KB
-rw-r--r--
ndb_fk_cascade_delete_multi.re...
2.56
KB
-rw-r--r--
ndb_fk_cascade_update.result
1.66
KB
-rw-r--r--
ndb_fk_create_drop.result
4.8
KB
-rw-r--r--
ndb_fk_db.result
7.18
KB
-rw-r--r--
ndb_fk_deferred_cascade.result
2.82
KB
-rw-r--r--
ndb_fk_disable.result
11.64
KB
-rw-r--r--
ndb_fk_is.result
8.49
KB
-rw-r--r--
ndb_fk_locase.result
2.44
KB
-rw-r--r--
ndb_fk_locking.result
1.47
KB
-rw-r--r--
ndb_fk_multi_column.result
2.04
KB
-rw-r--r--
ndb_fk_mysqldump.result
2.93
KB
-rw-r--r--
ndb_fk_mysqldump2.result
72
B
-rw-r--r--
ndb_fk_no_fk.result
30.14
KB
-rw-r--r--
ndb_fk_no_fk_legacy.result
2.77
KB
-rw-r--r--
ndb_fk_noaction.result
5.68
KB
-rw-r--r--
ndb_fk_resources.result
2.58
KB
-rw-r--r--
ndb_fk_restore.result
14.08
KB
-rw-r--r--
ndb_fk_restrict.result
6.82
KB
-rw-r--r--
ndb_fk_self_ref.result
3.74
KB
-rw-r--r--
ndb_fk_setdefault.result
1.03
KB
-rw-r--r--
ndb_fk_setnull.result
3.23
KB
-rw-r--r--
ndb_global_schema_lock.result
3.6
KB
-rw-r--r--
ndb_global_schema_lock_error.r...
1.88
KB
-rw-r--r--
ndb_grant.result
17.65
KB
-rw-r--r--
ndb_hashmap.result
624
B
-rw-r--r--
ndb_hidden_pk.result
10.55
KB
-rw-r--r--
ndb_index.result
17.84
KB
-rw-r--r--
ndb_index_ordered.result
16.73
KB
-rw-r--r--
ndb_index_stat.result
17.74
KB
-rw-r--r--
ndb_index_stat_partitions.resu...
3.82
KB
-rw-r--r--
ndb_index_stat_restart.result
2.2
KB
-rw-r--r--
ndb_index_unique.result
20.29
KB
-rw-r--r--
ndb_insert.result
36.52
KB
-rw-r--r--
ndb_join_pushdown_bka.result
949.68
KB
-rw-r--r--
ndb_join_pushdown_default.resu...
865.61
KB
-rw-r--r--
ndb_join_pushdown_nobnl.result
864.87
KB
-rw-r--r--
ndb_join_pushdown_none.result
865.08
KB
-rw-r--r--
ndb_limit.result
1.99
KB
-rw-r--r--
ndb_load.result
2.66
KB
-rw-r--r--
ndb_loaddatalocal.result
1.57
KB
-rw-r--r--
ndb_lock.result
4.17
KB
-rw-r--r--
ndb_lock_table.result
205
B
-rw-r--r--
ndb_many_fragments.result
26.72
KB
-rw-r--r--
ndb_mgm.result
5.7
KB
-rw-r--r--
ndb_mgmd.result
198
B
-rw-r--r--
ndb_minmax.result
1.47
KB
-rw-r--r--
ndb_multi.result
8.83
KB
-rw-r--r--
ndb_multi_row.result
1.33
KB
-rw-r--r--
ndb_multi_update_delete.result
1.83
KB
-rw-r--r--
ndb_native_default_support.res...
50.29
KB
-rw-r--r--
ndb_one_fragment.result
4.05
KB
-rw-r--r--
ndb_optimize_table.result
2
KB
-rw-r--r--
ndb_optimized_node_selection.r...
1017
B
-rw-r--r--
ndb_partition_error.result
1.44
KB
-rw-r--r--
ndb_partition_error2.result
150
B
-rw-r--r--
ndb_partition_hash.result
890
B
-rw-r--r--
ndb_partition_key.result
8.82
KB
-rw-r--r--
ndb_partition_list.result
2.31
KB
-rw-r--r--
ndb_partition_range.result
7.91
KB
-rw-r--r--
ndb_print_file.result
709
B
-rw-r--r--
ndb_rbwr.result
0
B
-rw-r--r--
ndb_read_multi_range.result
15
KB
-rw-r--r--
ndb_reconnect.result
1.7
KB
-rw-r--r--
ndb_rename.result
910
B
-rw-r--r--
ndb_replace.result
3.64
KB
-rw-r--r--
ndb_restore_bug17916243.result
537
B
-rw-r--r--
ndb_restore_compat_downward.re...
132.43
KB
-rw-r--r--
ndb_restore_compat_endianness....
10.97
KB
-rw-r--r--
ndb_restore_conv_lossy_charbin...
15.46
KB
-rw-r--r--
ndb_restore_conv_lossy_integra...
20.72
KB
-rw-r--r--
ndb_restore_conv_more.result
56.57
KB
-rw-r--r--
ndb_restore_conv_padding.resul...
6.14
KB
-rw-r--r--
ndb_restore_conv_promotion.res...
23.26
KB
-rw-r--r--
ndb_restore_discover.result
540
B
-rw-r--r--
ndb_restore_misc.result
25.16
KB
-rw-r--r--
ndb_restore_print.result
9.8
KB
-rw-r--r--
ndb_restore_schema_blobs.resul...
6.44
KB
-rw-r--r--
ndb_restore_schema_partitions....
13.25
KB
-rw-r--r--
ndb_restore_schema_rewrites.re...
12.22
KB
-rw-r--r--
ndb_restore_schema_subsets.res...
95.9
KB
-rw-r--r--
ndb_restore_schema_tolerance.r...
4.53
KB
-rw-r--r--
ndb_restore_undolog.result
18.76
KB
-rw-r--r--
ndb_row_count.result
5.19
KB
-rw-r--r--
ndb_row_format.result
1.74
KB
-rw-r--r--
ndb_select_count.result
334
B
-rw-r--r--
ndb_share.result
11.29
KB
-rw-r--r--
ndb_short_sigs.result
2.54
KB
-rw-r--r--
ndb_single_user.result
4.01
KB
-rw-r--r--
ndb_sp.result
1.17
KB
-rw-r--r--
ndb_spj_dict.result
11.63
KB
-rw-r--r--
ndb_sql_allow_batching.result
918
B
-rw-r--r--
ndb_startup.result
358
B
-rw-r--r--
ndb_statistics0.result
16.23
KB
-rw-r--r--
ndb_statistics1.result
15.99
KB
-rw-r--r--
ndb_subquery.result
9.29
KB
-rw-r--r--
ndb_suma_handover.result
427
B
-rw-r--r--
ndb_temporary.result
949
B
-rw-r--r--
ndb_tmp_table_and_DDL.result
3.11
KB
-rw-r--r--
ndb_transaction.result
4.62
KB
-rw-r--r--
ndb_trigger.result
9.38
KB
-rw-r--r--
ndb_truncate.result
425
B
-rw-r--r--
ndb_types.result
4.91
KB
-rw-r--r--
ndb_update.result
2.97
KB
-rw-r--r--
ndb_update_no_read.result
11.23
KB
-rw-r--r--
ndb_view.result
597
B
-rw-r--r--
ndb_wait_until_ready.result
533
B
-rw-r--r--
ndb_wl946_main.result
19.39
KB
-rw-r--r--
ndb_wl946_post.result
3.7
KB
-rw-r--r--
ndb_wl946_pre.result
6.62
KB
-rw-r--r--
ndbapi-examples.result
3.34
KB
-rw-r--r--
ndbinfo.result
44.04
KB
-rw-r--r--
ndbinfo_cache.result
775
B
-rw-r--r--
ndbinfo_dump.result
95
B
-rw-r--r--
ndbinfo_upgrade.result
382
B
-rw-r--r--
ps_7ndb.result
103.05
KB
-rw-r--r--
strict_autoinc_5ndb.result
894
B
-rw-r--r--
wl10837.result
524
B
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : ndb_cache_trans.result
result_format: 2 drop table if exists t1; set GLOBAL query_cache_type=on; set GLOBAL query_cache_size=1355776; reset query cache; flush status; ## Turn off autocommit, instead use COMMIT after each statement set AUTOCOMMIT=off; ## Create test table in NDB CREATE TABLE t1 ( pk int not null primary key, a int, b int not null, c varchar(20) ) ENGINE=ndbcluster; ## Add first row insert into t1 value (1, 2, 3, 'First row'); COMMIT; ## Query should be inserted in qcache Qcache_queries 0 Qcache_inserts 0 Qcache_hits 0 select * from t1; pk a b c 1 2 3 First row Qcache_queries 1 Qcache_inserts 1 Qcache_hits 0 COMMIT; Qcache_queries 1 Qcache_inserts 1 Qcache_hits 0 ## Perform the same query and make sure the query cache is hit Qcache_queries 1 Qcache_inserts 1 Qcache_hits 0 select * from t1; pk a b c 1 2 3 First row COMMIT; Qcache_queries 1 Qcache_inserts 1 Qcache_hits 1 ## Update the table, should be no queries in cache afterwards update t1 set a=3 where pk=1; COMMIT; Qcache_queries 0 Qcache_inserts 1 Qcache_hits 1 ## Read row after update, should not hit the cache, but get inserted select * from t1; pk a b c 1 3 3 First row COMMIT; Qcache_queries 1 Qcache_inserts 2 Qcache_hits 1 ## Read row from cache select * from t1; pk a b c 1 3 3 First row COMMIT; Qcache_queries 1 Qcache_inserts 2 Qcache_hits 2 ## Insert two new rows, queries in cache should be zero insert into t1 value (2, 7, 8, 'Second row'); insert into t1 value (4, 5, 6, 'Fourth row'); COMMIT; Qcache_queries 0 Qcache_inserts 2 Qcache_hits 2 ## Read the three rows, should not hit the cache select * from t1 order by pk; pk a b c 1 3 3 First row 2 7 8 Second row 4 5 6 Fourth row COMMIT; Qcache_queries 1 Qcache_inserts 3 Qcache_hits 2 ## Read the three rows, should now hit the cache! select * from t1 order by pk; pk a b c 1 3 3 First row 2 7 8 Second row 4 5 6 Fourth row COMMIT; Qcache_queries 1 Qcache_inserts 3 Qcache_hits 3 ## Two selects in the same transaction should hit cache select * from t1 order by pk; pk a b c 1 3 3 First row 2 7 8 Second row 4 5 6 Fourth row select * from t1 order by pk; pk a b c 1 3 3 First row 2 7 8 Second row 4 5 6 Fourth row COMMIT; Qcache_queries 1 Qcache_inserts 3 Qcache_hits 5 ## Perform a "new" query and make sure the query cache is not hit select * from t1 where b=3; pk a b c 1 3 3 First row COMMIT; Qcache_queries 2 Qcache_inserts 4 Qcache_hits 5 ## Same query again... select * from t1 where b=3; pk a b c 1 3 3 First row COMMIT; Qcache_queries 2 Qcache_inserts 4 Qcache_hits 6 ## Delete from the table, should clear the cache delete from t1 where c='Fourth row'; COMMIT; Qcache_queries 0 Qcache_inserts 4 Qcache_hits 6 select * from t1 where b=3; pk a b c 1 3 3 First row COMMIT; Qcache_queries 1 Qcache_inserts 5 Qcache_hits 6 ## Start another connection and check that the query cache is hit set AUTOCOMMIT=off; use test; select * from t1 order by pk; pk a b c 1 3 3 First row 2 7 8 Second row select * from t1 where b=3; pk a b c 1 3 3 First row Qcache_queries 2 Qcache_inserts 6 Qcache_hits 7 ## Update the table and switch to other connection update t1 set a=4 where b=3; COMMIT; ## Connection 2 set AUTOCOMMIT=off; use test; ## Should not hit cache, table updated Qcache_queries 0 Qcache_inserts 6 Qcache_hits 7 select * from t1 order by pk desc; pk a b c 2 7 8 Second row 1 4 3 First row Qcache_queries 1 Qcache_inserts 7 Qcache_hits 7 ## Should hit cache select * from t1 order by pk desc; pk a b c 2 7 8 Second row 1 4 3 First row Qcache_queries 1 Qcache_inserts 7 Qcache_hits 8 ## Connection 1, should hit the cache Qcache_queries 1 Qcache_inserts 7 Qcache_hits 8 select * from t1 order by pk desc; pk a b c 2 7 8 Second row 1 4 3 First row select * from t1 order by pk desc; pk a b c 2 7 8 Second row 1 4 3 First row Qcache_queries 1 Qcache_inserts 7 Qcache_hits 10 ## Starting transaction and update t1 begin; update t1 set a=5 where pk=1; Qcache_queries 0 Qcache_inserts 7 Qcache_hits 10 ## Connection 2 ## Update has flushed the qc for t1, should not hit qc select * from t1 order by pk desc; pk a b c 2 7 8 Second row 1 4 3 First row Qcache_queries 1 Qcache_inserts 8 Qcache_hits 10 ## Connection 1 commit; Qcache_queries 1 Qcache_inserts 8 Qcache_hits 10 ## Connection 2 ## Update is now committed, should not hit the cache select * from t1 order by pk desc; pk a b c 2 7 8 Second row 1 5 3 First row Qcache_queries 1 Qcache_inserts 9 Qcache_hits 10 COMMIT; Qcache_queries 1 Qcache_inserts 9 Qcache_hits 10 ## Connection 1 ## Should hit the cache select * from t1 order by pk desc; pk a b c 2 7 8 Second row 1 5 3 First row Qcache_queries 1 Qcache_inserts 9 Qcache_hits 11 update t1 set a=6 where pk=1; ## Following query should not be taken from cache, trans is ongoing select * from t1 order by pk desc; pk a b c 2 7 8 Second row 1 6 3 First row Qcache_queries 0 Qcache_inserts 9 Qcache_hits 11 ## Connection 2 should still see old data and not hit cache Qcache_queries 0 Qcache_inserts 9 Qcache_hits 11 select * from t1 order by pk desc; pk a b c 2 7 8 Second row 1 5 3 First row Qcache_queries 1 Qcache_inserts 10 Qcache_hits 11 ## Connection 1 COMMIT; ## Update has just been committed, should not hit cache Qcache_queries 1 Qcache_inserts 10 Qcache_hits 11 select * from t1 order by pk desc; pk a b c 2 7 8 Second row 1 6 3 First row Qcache_queries 1 Qcache_inserts 11 Qcache_hits 11 ## Connection 2 ## Should hit cache Qcache_queries 1 Qcache_inserts 11 Qcache_hits 11 select * from t1 order by pk desc; pk a b c 2 7 8 Second row 1 6 3 First row Qcache_queries 1 Qcache_inserts 11 Qcache_hits 12 drop table t1; ## Finally, there should be no queries in cache Qcache_queries 0 Qcache_inserts 11 Qcache_hits 12 SET GLOBAL query_cache_size=0;
Close